单项选择题
Consider the following scenario： You have a directory， data， under the disk group tdgroupA. You want to create an alias for one of the data files and you execute the following command： ALTER DISKGROUP tdgroupA
ADD ALIAS ’+tdgroupA/data/datafile.dbf’
FOR ’+tdgroupA.231.45678’；
Which task would be accomplished by the command？（）
A.The command drops the file +tdgroupA·231.45678.
B.The command physically relocates the file to +tdgroupA/data and renames the file to datafile.dbf.
C.The command creates a copy of the +tdgroupA·231.45678 file and places it in +tdgroupA/data after renaming the file to datafile.dbf.
D.The command creates an alias， datafile.dbf， and places it in +tdgroupA/data and does not remove the +tdgroupA·231.45678 file.
E.The command creates a file， datafile.dbf， in +tdgroupA/data and removes the references for +tdgroupA·231.45678 from the data dictionary views.
相关考题
-
单项选择题
You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. While studying the parameter file of the ASM instance， you find the following entry： ASM_DISKSTRING = /devices/* What could be the reason for this setting？（）
A.to enable the ASM instance to identify the alert log file
B.to enable the ASM instance to identify the server parameter file
C.to enable the ASM instance to define the locations for Oracle Managed Files （OMF）
D.to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory -
单项选择题
You want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database： INSTANCE_TYPE = RDBMS DB_NAME = PROD LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K LOG_ARCHIVE_DEST = +dgroupA LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t" DB_CREATE_FILE_DEST = +dgroupA COMPATIBLE = 10.1.0.2.0 CONTROL_FILES = +dgroupA Which parameter would be ignored while starting up the instance for the database PROD？（）
A.DB_BLOCK_SIZE
B.CONTROL_FILES
C.LARGE_POOL_SIZE
D.LOG_ARCHIVE_DEST
E.LOG_ARCHIVE_FORMAT
F.DB_CREATE_FILE_DEST -
单项选择题
You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used. Which method would you follow to achieve this？（）
A.enable index monitoring and query the DBA_OBJECTS view
B.enable index monitoring and query the DBA_INDEXES view
C.enable index monitoring and query the V$OBJECT_USAGE view
D.enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view
