You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.

The CDB has several pluggable databases (PDBs) open in the read/write mode.

There are ongoing transactions in both the CDB and PDBs.

What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?

A. The shutdown proceeds immediately. The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled hack.

B. The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.

C. The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.

D. The statement results in an error because there are open PDBs.

Which two actions does an incremental checkpoint perform? (Choose two.)

A. It signals CKPT to write the checkpoint position to the data file headers.

B. It writes the checkpoint position to the data file headers.

C. It advances the checkpoint position in the checkpoint queue.

D. It writes the checkpoint position to the control file.

Which two statements are true about resumable space allocation? (Choose two.)

A. A database-level LOGON trigger can be used to automatically configure resumable statement settings for individual sessions.

B. SELECT statements that run out of temporary space for sort areas are candidates for resumable execution.

C. A resumable statement can be suspended and resumed only once during a session.

D. Resumable space allocation does not apply when a database instance uses asynchronous commit.

E. Resumable space allocation does not apply when users exceed their assigned space quota in a tablespace.

F. Free space in a segment is automatically reclaimed when a resumable statement is suspended because of an out-of-space condition.

You install Oracle Grid Infrastructure standalone server and issue the following command:

crsctl start has

Which two existing components get automatically added to the Oracle Restart configuration? (Choose two.)

A. Oracle CSSD services

B. the database whose instance is running

C. Oracle Notification services

D. Oracle Healthcheck services

E. Oracle Net Listener

Examine these configuration details:

1.

A Fast Recovery Area (FRA) has been specified for a database.

2.

The database instance is in ARCHIVELOG mode

3.

The default location for archived redo log files is the FRA.

Which two types of files are removed automatically due to space pressure in the FRA? (Choose two.)

A. flashback logs

B. obsolete RMAN database backup sets

C. obsolete spfiles

D. expired RMAN image copies

E. expired RMAN database backup sets

F. Mirrored copies of online logs