单选题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 rebalancingB Because the FRA disk group is not configured to support mirroringC Because disks in the FRA disk group are not formatted at this stageD Because the FRA disk group will support only a single size of allocation unit
单选题
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
参考解析
解析：
暂无解析
相关考题：
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
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 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
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.
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.120MB.320MC.480MD.600M
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.
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 MBB. 272 MBC. 362 MBD. 1,440 MB
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.
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.
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.
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.
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 diskB、Add a new disk to the system or release a disk from the one of the existing volume groupsC、Run the 'mkvg' command to create multiple volume groups on a single disk providing the disk does nothave a PVIDD、Run the 'mkvg' command to create multiple volume groups on a single disk providing the volume groups have the same PP size
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 networkB、 Two disks per node，one networkC、 Two disks per node，six networksD、 Two disks per node，three networks
To examine the Exhibit， press the Exhibit button. Which of the following addresses will be reachable without adding any routes？（）A、129.35.54.21B、129.35.57.21C、129.35.58.21D、129.35.55.21
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
Exhibit， Viewing the Exhibit and examine the Flashback Database architecture. Identify the missing component （shown with a "？`"= in the Flashback Database architecture.（）A、 DBWnB、 RVWRC、 ARCHD、 RECOE、 TRWR
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、 4B、 8C、 7D、 0
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 rebalancingB、 Because the FRA disk group is not configured to support mirroringC、 Because disks in the FRA disk group are not formatted at this stageD、 Because the FRA disk group will support only a single size of allocation unit
单选题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 rebalancingB Because the FRA disk group is not configured to support mirroringC Because disks in the FRA disk group are not formatted at this stageD Because the FRA disk group will support only a single size of allocation unit
单选题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.
单选题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-xxxxB （xxx） xxxxxxxC （xxx） xxx-xxxxD xxx-（xxx）-xxxx
单选题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
单选题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?（）A120MB320MC480MD600M
单选题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 4B 8C 7D 0
单选题View the Exhibit and examine the Flashback Database architecture. Identify the missing component （shown with a "？"） in the Flashback Database architecture.（）A DBWnB RVWRC ARCHD RECOE TRWR
多选题Which two statements about views are true?（）AA view can be created as read only.BA view can be created as a join on two or more tables.CA view cannot have an ORDER BY clause in the SELECT statement.DA view cannot be created with a GROUP BY clause in the SELECT statement.EA view must have aliases defined for the column names in the SELECT statement.
多选题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?（）ATable_open_cacheBTable_open_cache_instancsCTable_definition_cacheDTmp_table_sizeEMax_heap_table_sizeFMax_tmp_tables
单选题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.