单项选择题

Consider the following scenario：
You have a directory， data， under the disk group tdgroup
A. 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.A
B.B
C.C
D.D
E.E

点击查看答案

上一题目录下一题

相关考题

单项选择题

Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components？（）

A.PMON
B.SMON
C.MMNL
D.MMAN
E.MMON

单项选择题

You work as a database administrator for Certkiller .com. You received the following error while working on your database：
ORA-01555： snapshot too old
In which situation would you receive such an error？（）

A.You performed rollback after commit.
B.If a log switch occurs in your database.
C.Thearchiverfails to generate an archived log file.
D.Instance recovery fails to find one of the redo log files.
E.A long-running query is unable to get read-consistent image.
F.If you perform manual undo management operations in auto mode.

单项选择题

You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure.
How would you proceed to recover the database？（）

A.Start the instance and open the database, instance recovery automatically recovers control files
B.Create a file based on the contents of the trace file and save it to the control file locations and start the database
C.Re-create the database (The recovery of the control file is not possible because you have lost all the control files.)
D.Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
E.Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.