当前位置:OCP 11G认证考试题库

问题:

[单选] What is the proper procedure to recover a lost tempfile?()

A . Restore the backup copy of the tempfile from the backup media. 
B . Re-create the tempfile with the create tempfile command. 
C . Copy an existing tempfile from another database. 
D . Re-create the tempfile with the create tablespace command. 
E . Re-create the tempfile with the alter tablespace command.

When using the Tivoli Dynamic Workload Console, which monitor tasks are available to the user?()  all those that have been created by all users。  just those created by the user in the current session。  all those created by the user and shared with user’s login group。  just those where the connection engine specifies the user’s logo。 禁止用灰口铸铁制造瓶帽是因为灰口铸铁()。 易松动;。 互换性差;。 抗撞击性能较差;。 装配性差。 具有水利工程施工专业甲级资质的监理单位,可以承担各等级水利工程的施工监理业务。 Evaluate the following command:   SQL>ALTER SYSTEM SET db_securefile = ’IGNORE’;   What is the impact of this setting on the usage of SecureFiles?()  It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB。  It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOB。  It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOB。  It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile。 You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology, you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database.   After the installation, you make the following changes in your initialization parameter file:LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’   DB_RECOVERY_FILE_DEST =    ’LOCATION=d:\product\10.1.0\flash_recovery_area’  DB_RECOVERY_FILE_DEST_SIZE=10g   Where are the archived redo logs stored for your database?()  The archived redo logs are stored in an operating system-dependent location.。  The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.。  The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.。  The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and  DB_RECOVERY_FILE_DEST.。 What is the proper procedure to recover a lost tempfile?()
参考答案:

  参考解析

本题暂无解析

在线 客服