You have a disk group， DGROUP1， with three disks and NORMAL redundancy. You execute the following command to create a template for the disk group：  ALTER DISKGROUP dgroup1  ADD TEMPLATE my_temp  ATTRIBUTES （MIRROR FINE）;  Which statement is true？（）

A、When a file is created in DGROUP1 with the template， it would have three­way mirroring. 

B、When a file is created in DGROUP1， the MY_TEMP template becomes the default template.

C、When a file is created in DGROUP1 with the template， it would have two­way mirroring and file striping.

D、When a file is created in DGROUP1 with the template， it would have three­way mirroring and file striping.

E、When a file is created in DGROUP1 with the template， it would have two­way mirroring but no file striping.

相关问题推荐

• You issued the following statement in your SQL*Plus session：   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600；   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）

  A、 creating a table in your schema and you exceed your allocated space quota on the tablespace

  B、 executing a long query that involves a sort operation and the statement runs out of temporary space

  C、 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit

  D、 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

  查看答案

• You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）

  A、 VERSIONS_STARTSCN

  B、 VERSIONS_STARTTIME

  C、 VERSIONS_XID

  D、 VERSIONS_OPERATION

  查看答案

• Your business has departmental reports that are generated every day. Each department must use the same set of queries， but accesses a different subset of data in the tables， depending on which department generates the report. The format of the reports is being developed; currently， the format changes daily.  How would you configure the database to ensure that each department generates its report （based on its target data） using the most recent report format every day？（）

  A、by having each user run the report generation procedure at the scheduled time， supplying the necessary input variables

  B、by creating a program using DBMS_JOB that accepts one or more variables， and creating a job that calls this program using DBMS_JOB

  C、by having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the report

  D、by having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the report

  E、by creating a program using DBMS_SCHEDULER that accepts one or more variables， and creating a job that calls this program using DBMS_SCHEDULER

  查看答案

• You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advisor to analyze？（）

  A

   Top SQL

  B

   snapshots

  C

   SQL Tuning sets

  D

   index access path

  E

   optimizer statistics

  F

   materialized view logs

  查看答案

• You have a read/x7fonly tablespace on read/x7fonly media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read/x7fonly tablespace was read/write when the control file was backed up. What should you consider？（）

  A、drop the read­only tablespace and re­create the tablespace after recovery

  B、take data files from the read­only tablespace offline before performing a recovery

  C、perform a recovery; status of the tablespace in control file will be changed automatically

  D、recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database

  查看答案