首页计算机考试Oracle认证
(单选题)

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?()

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.

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    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?()

    答案解析

快考试在线搜题