首页  /  试题详情

多选题 Your databases all run in ARCHIVELOG mode.A newly created database has no RMAN backups.Examine these commands ：CONfIGURE RETENTION POLICY To REDUNDANCY 2 ;RMAN>BACKUP TABLESPACE SYSTEM;Backup set complete,elapsed time ：RMAN>BACKUP TABLESPACE SYSTEM,SYSAUX ；Backup set complete, elapsed time： 00： 00： 04RMAN>BACKUP DATABASE ;Backup set complete, elapsed time： 00：00：07Which two are true about the execution of the third backup command?

A、 A backup is not performed for the SYSAUX tablespace.
B、 The first backup of the SYSTEM tablespace becomes expired.
C、 The first backup of the SYSTEM tablespace becomes obsolete.
D、 The first backup of the SYSTEM tablespace is deleted.
E、 A backup is performed for the SYSAUX tablespace.
查看答案
下载APP答题
由4l***dl提供 分享 举报 纠错
相关题库推荐
062
2020-12-17
共157道
062-3
2020-11-29
共51道

相关试题

单选题 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

单选题 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.

单选题 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

单选题 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.

单选题 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.

单选题 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

单选题 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.

单选题 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.