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