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？（）

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 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？（）

单选题查看答案

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?（）

单选题查看答案