单选题View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management （ASM）.  Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided

题目
单选题
View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management （ASM）.  Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided with the same size？（）
A

 Because the FRA disk group will not support dynamic rebalancing

B

 Because the FRA disk group is not configured to support mirroring

C

 Because disks in the FRA disk group are not formatted at this stage

D

 Because the FRA disk group will support only a single size of allocation unit

相似考题

1.View the Exhibit and examine the output.You execute the following RMAN command to perform the backup operation:What is the multiplexing level in the preceding backup process()A. 4B. 8C. 7D. 0

2.View the exhibit and examine the output.Which statement can be an inference from the output?()A. The FRA disk group has an asynchronous I/O bottleneckB. The least number of I/Os are performed on the last data file in the listC. The number of times that the backup or restore process directed the OS to wait until an I/O was complete is the highest for the last data file in the listD. The number of times that the backup or restore process made an OS call to poll for I/O completion in Nonblocking mode is the least for the FRA disk group

3.View the Exhibit to examine the Automatic SQL Tuning result details.Which action would you suggest for the selected SQL statement in the Exhibit?()A. Accept the recommended SQL profile.B.Collect statistics for the related objects.C. Run the Access Advisor for the SQL statement.D. Run the Segment Advisor for recommendations.

4.View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error:SQL> EXECUTE dbms_resources_manager.validate_pending_area ( );What could be the reason?（）A. The pending area is automatically submitted after the plan creationB. The procedure must be executed before creating the resources plan directiveC. The SYS_GROUP resource consumer group is not included in the resource plan directiveD. The OTHER_GROUPS resources consumer group is not included in the resource plan directive

更多“View the Exhibit and examine the disk groups created at the ”相关问题

  • 第1题：

    Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.)You restart the instance.To what value will the MEMORY_MAX_TARGET parameter be set by default?()

    A.120M

    B.320M

    C.480M

    D.600M


    参考答案：D

  • 第2题：

    View the Exhibit to examine the parameter values.You are planning to set the value for the MEMORY_TARGET parameter of your database instance.What value would you recommend?()

    A. 90 MB

    B. 272 MB

    C. 362 MB

    D. 1,440 MB


    参考答案：C

  • 第3题：

    You are the administrator of a SQL Server 2000 computer. The server contains database named Sales. Users report that they cannot add new data to the database. You examine the properties of the database. The database is configured as shown in the Sales Properties exhibit.

    You examine drive E. The hard disk is configured as shown in the Local Disk Properties exhibit.

    You want the users to be able to add data, and you want to minimize administrative overhead. What should you do?

    A．Increase the maximum file size of Sales_Data to 1,500MB.

    B．Use the DBCC SHRINKDATABASE statement.

    C．Set automatic file growth to 10 percent.

    D．Create another data file named Sales_Data2 in a new SECONDARY filegroup.


    正确答案：A
    解析：Explanation: By examining the first exhibit we see that the database has reached its maximum size of 1001 MB. The data file is located on drive E and the second exhibit shows us that there is enough free space on that disk to increase the maximum size of the data file to 1,500 MB.

    Incorrect Answers:
    B: DBCC SHRINKDATABASE could possibly shrink the database and new records could be added for a while, but it would just be a temporary solution.

    C: The database is already set to automatic file growth, but it has reached the maximum size.

    D: The primary file has reached it maximum size. A secondary filegroup would help if it was set to the default file group. New data would still be added to the primary filegroup which is at its maximum size.

  • 第4题：

    While adding the forced varyon volume group option， it is decided to create a disk heartbeat  Network over the disk paths. Which HACMP function is used to create disk heartbeat devices？（）

    • A、 The Disk hearbeat facility is initialized when creating enhanced concurrent mode volume groups through HACMP.
    • B、 HACMP does not create the disk heartbeat area directly； RSCT facility creates the area used for the disk heartbeat when the device is started by Group Services.
    • C、 The ’Chdev -v-C " command creates an enhanced Volume Group from an ordinarilyVolume Group. This creates the heartbeat region on the vfirst disk in the chain.
    • D、 The disk heartbeat area on the disk is created and initialized when the device is created inHACMP "Extended Configuration -> Extended Topology -> Disk heartbeat facility" smit path.

    正确答案:A

  • 第5题：

    During the initial cluster design，a disk heartbeat，Point-to-Point non-IP network is being planned  as part of a three-node cluster implementation. The disk environment will use LVM mirroring for disk redundancy. The volume groups will be created as Enhanced Concurrent Capable.  To facilitate disk heartbeating，how many disks per node and how many networks will be required？（）  

    • A、 One disk per node，one network
    • B、 Two disks per node，one network
    • C、 Two disks per node，six networks
    • D、 Two disks per node，three networks

    正确答案:C

  • 第6题：

    Which two statements are true regarding views?（）

    • A、A subquery that defines a view cannot include the GROUP BY clause 
    • B、A view that is created with the subquery having the DISTINCT keyword can be updated 
    • C、A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated 
    • D、A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table

    正确答案:C,D

  • 第7题：

    View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation：   RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8； BACKUP DATABASE FILESPERSET 4； }   What is the multiplexing level in the preceding backup process？（）

    • A、 4
    • B、 8
    • C、 7
    • D、 0

    正确答案:A

  • 第8题：

    单选题
    View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table：   ALTER TABLE emp   ADD CONSTRAINT emp_id_pk  PRIMARY KEY （emp_id）   USING INDEX emp_id_idx；   Which statement is true regarding the effect of the command？（）
    A

     The PRIMARY KEY is created along with a new index.

    B

     The PRIMARY KEY is created and it would use an existing unique index.

    C

     The PRIMARY KEY would be created in a disabled state because it is using an existing index.

    D

     The statement produces an error because the USING clause is permitted only in the CREATE TABLE command.


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    View the Exhibit and examine the recommendation graph provided for a test database by the Undo Advisor.The graph recommends that the size of undo tablespace should be set to（）.
    A

    1 MB 

    B

    6 MB 

    C

    10 MB 

    D

    15 MB 

    E

    11 MB


    正确答案： E
    解析： 暂无解析

  • 第10题：

    单选题
    View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation：   RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8； BACKUP DATABASE FILESPERSET 4； }   What is the multiplexing level in the preceding backup process？（）
    A

     4

    B

     8

    C

     7

    D

     0


    正确答案： A
    解析： 暂无解析

  • 第11题：

    多选题
    Which two statements about views are true?（）
    A

    A view can be created as read only.

    B

    A view can be created as a join on two or more tables.

    C

    A view cannot have an ORDER BY clause in the SELECT statement.

    D

    A view cannot be created with a GROUP BY clause in the SELECT statement.

    E

    A view must have aliases defined for the column names in the SELECT statement.


    正确答案： D,E
    解析： 暂无解析

  • 第12题：

    单选题
    While adding the forced varyon volume group option， it is decided to create a disk heartbeat  Network over the disk paths. Which HACMP function is used to create disk heartbeat devices？（）
    A

     The Disk hearbeat facility is initialized when creating enhanced concurrent mode volume groups through HACMP.

    B

     HACMP does not create the disk heartbeat area directly； RSCT facility creates the area used for the disk heartbeat when the device is started by Group Services.

    C

     The ’Chdev -v-C  command creates an enhanced Volume Group from an ordinarilyVolume Group. This creates the heartbeat region on the vfirst disk in the chain.

    D

     The disk heartbeat area on the disk is created and initialized when the device is created inHACMP Extended Configuration -> Extended Topology -> Disk heartbeat facility smit path.


    正确答案： A
    解析： 暂无解析

  • 第13题：

    View the Exhibit exhibit1 to examine the series of SQL commands. View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline. The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS.Which statement is true if the SQL query in exhibit1 is executed again when the valueof OPTIMIZER_MODE is set to FIRST_ROWS?（）

    A. The optimizer uses a new plan because none of the plans in the exhibit2 are fixed plans.

    B. The optimizer uses the plan in the second row of the exhibit2 because it is an accepted plan.

    C. The optimizer uses the plan in the first row of the exhibit2 because it is the latest generated plan.

    D. The optimizer uses the plan in the first row of the exhibit2 because OPTIMIZER_MODE was set to FIRST_ROW during its creation.


    参考答案：B

  • 第14题：

    Examine the following commands and their output:View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?（）

    A. Flashback logging is not enabled for the database.

    B. The changes made to the table are not committed.

    C. Supplemental logging is not enabled for the database.

    D. The database is not configured in ARCHIVELOG mode.


    参考答案：B

  • 第15题：

    Which two statements about views are true? （）

    • A、A view can be created as read only.
    • B、A view can be created as a join on two or more tables.
    • C、A view cannot have an ORDER BY clause in the SELECT statement.
    • D、A view cannot be created with a GROUP BY clause in the SELECT statement.
    • E、A view must have aliases defined for the column names in the SELECT statement.

    正确答案:A,B

  • 第16题：

    What must an administrator do to create two new volume groups on a system with only one spare disk?（）

    • A、Run the 'mkvg -M' command to create multiple volume groups on a single disk
    • B、Add a new disk to the system or release a disk from the one of the existing volume groups
    • C、Run the 'mkvg' command to create multiple volume groups on a single disk providing the disk does not have a PVID
    • D、Run the 'mkvg' command to create multiple volume groups on a single disk providing the volume groups have the same PP size

    正确答案:B

  • 第17题：

    To examine the Exhibit， press the Exhibit button. Which of the following addresses will be reachable without adding any routes？（）

    • A、129.35.54.21
    • B、129.35.57.21
    • C、129.35.58.21
    • D、129.35.55.21

    正确答案:B

  • 第18题：

    Exhibit， Viewing the Exhibit and examine the Flashback Database architecture. Identify the missing component （shown with a "？`"= in the Flashback Database architecture.（）

    • A、 DBWn
    • B、 RVWR
    • C、 ARCH
    • D、 RECO
    • E、 TRWR

    正确答案:B

  • 第19题：

    View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management （ASM）.  Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided with the same size？（）

    • A、 Because the FRA disk group will not support dynamic rebalancing
    • B、 Because the FRA disk group is not configured to support mirroring
    • C、 Because disks in the FRA disk group are not formatted at this stage
    • D、 Because the FRA disk group will support only a single size of allocation unit

    正确答案:B

  • 第20题：

    单选题
    View the Exhibit and examine the details of the EMPLOYEES table.  The query was written to format the PHONE_NUMBER for the employees.   Which option would be the correct format in the output？（）
    A

     xxx-xxx-xxxx

    B

     （xxx） xxxxxxx

    C

     （xxx） xxx-xxxx

    D

     xxx-（xxx）-xxxx


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.) You restart the instance. To what value will the MEMORY_MAX_TARGET parameter be set by default?（）
    A

    120M

    B

    320M

    C

    480M

    D

    600M


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    View the Exhibit and examine the Flashback Database architecture.  Identify the missing component （shown with a "？"） in the Flashback Database architecture.（）
    A

    DBWn

    B

    RVWR

    C

    ARCH

    D

    RECO

    E

    TRWR


    正确答案： C
    解析： 暂无解析

  • 第23题：

    多选题
    You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing. Which two variables would likely fix this issue?（）
    A

    Table_open_cache

    B

    Table_open_cache_instancs

    C

    Table_definition_cache

    D

    Tmp_table_size

    E

    Max_heap_table_size

    F

    Max_tmp_tables


    正确答案： F,D
    解析： 暂无解析

相关内容