Your database has one control file a

单选题 Your database has one control file and the instance is started using an SPFILE.Examine these steps：1 Issue SHUTDOWN IMMEDIATE2 Issue STARTUP MOUNT3 Issue STARTUP NOMOUNT4 Copy the existing control file to the new location5 Issue ALTER DATABASE OPEN6 Issue STARTUP7 Update the CONTROL_FILES initialization parameter in the SPFILE to include an additional file.Identify the minimum required steps in the correct order to multiplex the control file.

A、 7,1,3,4,5

B、 1,7,6,4

C、 7,1,2,4,5

D、 7,1,4,6

E、 1,7,2,4,6

查看答案

下载APP答题

由4l***dl提供分享举报纠错

相关试题

单选题 All of your live databases run in ARCHIVELOG mode.On the SALES database there is no LEVEL 0 backup.Examine these commands issued against the SALES database target：RMAN> BACKUP AS BACKUPSET DATABASE ;Backup set complete, elapsed time： 00：00：03RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE ; What is true about the execution of these commands?

A、It throws an error because incremental level 1 backups require image copy backups as the Level 0 backup.

B、A Level 0 backup of the database is created instead of the Level 1

C、It throws an error because a Level o backup does not exist.

D、A backup is created which only contains blocks that have changed since BACKUP As BACKUPSET command.

查看答案

单选题 Examine this parameter setting：SHOW PARAMETER INMEMORY_SIZENAME TYPE VALUEInmemory_size big integer 1GNow examine this command ：ALTER TABLE hr.emp INMEMORY ;Table altered .Which is true about effects of this command and any subsequent processing on hr.emp?

A、Its data gets loaded into the IM Column Store in columnar format.

B、Its data gets loaded into the IM Column Store in row format.

C、The database instance uses the IM Column Store to process DMLs.

D、Its data cannot be loaded into the default database buffer cache.

查看答案

单选题 Examine these commands：SQL>SELECT open_mode FROM v$database ;OPEN_MODEREAD WRITESQL>ARCHIVE LOG LIST ;Database log modeNo Archive ModeAutomatic archival DisabledArchive destination USE_DB_RECOVERY_FILE_DESTNow examine these steps：

A、5,1,4,8,6

B、7,1,4,8,6

C、5,1,4,6

D、5,2,6,4

E、5,3,4,6

F、5,2,4,6

查看答案

单选题 What should you do to ensure that a job stores minimal job metadata and runtime data on disk,and uses only existing PL/SQL programs?

A、 specify the job as a member of a job class

B、 create a lightweight job

C、 create an event-based job

D、 use a job array

查看答案

单选题 In one of your databases, unified auditing is enabled and an SH.SALES table exists.You successfully execute these commands：SQL> CREATE AUDIT POLICY sales_pol ACTIONS select on sh.sales; SQL>AUDIT POLICY sales_pol;Which statement is true about SALES_POL?

A、Audit records are always stored in an external audit file.

B、It is only enabled for user SH .

C、Only successful queries of SH. SALES are written to the audit trail.

D、It is enabled for all users having SELECT privilege on SH.SALES.

查看答案

单选题 Your database is open and the listener LTSTENER is up. You issue the comand：LSNRCTL> RELOADWhat Is the effect of RELOAD on sessions that were originally established by LISTENER?

A、 Only sessions based on static listener registrations are disconnected.

B、 Existing connections are not disconnected; however, They cannot perform any operations until the listener completes the re-registration of the database instance and service handlers.

C、 The sessions are not affected and continue to function normally.

D、 All the sessions are terminated and active transactions are rolled back.

查看答案

单选题 Which naming method enables clients to connect to a database instance without any client side configuration in sqlnet.ora or tnsnames.ora?

A、the directory naming method

B、the external naming method

C、the easy connect method

D、the local naming method

查看答案

单选题 In your database, the SALES table exists in the SH schema and unified auditing is enabled.As the DBA, you successfully execute the comands：SQL> CREATE AUDIT POLICY sales_pol ACTIONS select on sh.sales; SQL> AUDIT POLICY sales_pol;Which statement is true about the SALES_POL audit policy?

A、 It is enabled for all users who have the SELECT privilege on the SH.SALES table.

B、 Only successful executions of the SELECT statements are written to the audit trail.

C、 The audit records are always stored in an audit file at the operating system level.

D、 It gets enabled only for the SH user.

查看答案