Oracle OCP 1z0-053 2018年9月最新考过的题库分享-2

3.One of your databases has resumable space allocation enabled.

Which two conditions will suspend a session performing DML in that database instance?

A) A deadlock is detected.

B) A transaction reaches a tablespace space quota.

C) The DML affects objects in a tablespace that is going offline.

D) A transaction cannot allocate extents in a temporary segment.

E) Total undo space for a session exceeds the amount available.

BE#

 

5.Which two are true about automatic PGA memory management?

□     A) PGA_AGGREGATE_TARGET cannot be configured if SGA_TARGET is configured.

□     B) The PGA is auto-tuned whether or not PGA_AGGREGATE^TAKGET is explicitly set.

□     C) PGA_AGGREGATE_TARGET cannot be configured if MEMORY_TARGET is configured.

□     D) Memory is allocated separately for FGA_AGGREGATE_TARGET and SGA_TARGET.

□     E) PGA_AGGREGATE_TARGET always defaults to zero.

BD

 

6 .Examine these RMAN commands:

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;

RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY;

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

 

Your database uses an SPFILE.

You issued this command:

RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

Which three actions will occur?

□     A) backup of the entire SPFILE

□     B) backup only of SPFILE content that has changed since the last backup

□     C) backup of online logs

□     D) backup of all used and unused blocks in all data files

□     E) backup of archived logs

□     H backup of all used blocks only, in all data files

ADE

 

7 .In which two situations must you open a database with RESETLOGS

□     A) after bringing a recovered user tablespace online

□     B)    after performing a database point-in-time recovery

□     C)   after recovering from the loss of a server parameter file

□     D)   after recovering from the loss of a CURRENT redo log group

□     E)    after recovering from the loss of an ACTIVE redo log group