单选题
AThe command drops the file +tdgroupA·231.45678.
BThe command physically relocates the file to +tdgroupA/data and renames the file to datafile.dbf.
CThe command creates a copy of the +tdgroupA·231.45678 file and places it in +tdgroupA/data after renaming the file to datafile.dbf.
DThe command creates an alias， datafile.dbf， and places it in +tdgroupA/data and does not remove the +tdgroupA·231.45678 file.
EThe command creates a file， datafile.dbf， in +tdgroupA/data and removes the references for +tdgroupA·231.45678 from the data dictionary views.
正确答案
答案解析
略
相似试题
Consider this RMAN command： RMAN> CONFIGURE RETENTION POLICY CLEAR； What is the effect of this command？（）
单选题查看答案
Consider this syntax： MERGE INTO t1 USING t2 ON （join predicate）….. What does the MERGE syntax do？（）
单选题查看答案
Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）
多选题查看答案
Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）
多选题查看答案
Consider the following statement： SQL> EXECUTE DBMS_STATS.GATHER_SHEMA_STATS （- 2> ownname => ‘OE’， - 3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE， - 4> method opt => ‘for all columns size AUTO’）； What is the effect of ‘for all columns size AUTO’ of the METHOD_OPT option？（）
单选题查看答案
You work as a database administrator for Certkiller .com. You find that the database performance degrades while you backup the Certkiller database using Recovery Manager （RMAN）. The Certkiller database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）
单选题查看答案
Consider the following code snippet： BEGIN DBMS_SCHEDULER.SET_ATTRIBUTE （ name => ，，lne_job1， attribute => ，，job_priority， value => 1）； END； / If this code were executed， which of the following statements would be true？（）
单选题查看答案
You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）
单选题查看答案
Consider the following: Which statement best describes the meaning of the value for the key_len column?（）
单选题查看答案