You are installing OracleDatabase 12c on a machine. When you run the installer; Oracle Universal installer

(OUI) shows a message that says one of the product-specific prerequisite checks has failed:

Checking available swap space requirements...

Expected result: 1512MB

Actual Result: 1018MB

Check complete. The overall result of this check is: failed «« Problem: The system does not have the

required swap space.

What happens to the installation in this situation?

A. It can be continued.

B. It resizes the swap space automatically when you proceed further.

C. It can be continued, but the instance cannot be started without increasing swap space.

D. It shows a message saying one or more prerequisite checks have failed and the installation aborts.

Which statement about Online Move Data file is true?

A. Moving a data file online prevents DML operations on segments stored in the data file.

B. Flashing back a database to a point in time before a data file had been renamed online retains the new name.

C. Moving a data file online can be performed if the data file is in OFFLINE mode.

D. Moving a data file online cannot be performed if the data file is under BEGIN BACKUP.

Which statement regarding Oracle Active Data Guard 12c is false?

A. Any application compatible with a read-only database can run on an Oracle Active Data Guard standby.

B. It provides new support for DML to global temporary tables and the use of sequences in the standby database.

C. It repairs block corruptions detected in the primary or standby database.

D. It supports different software patch levels between a primary database and its physical standby database for the purpose of applying and validating Oracle patches in a rolling fashion.

E. It supports multi master and bidirectional replication architectures where there are multiple databases that all contain the same data, even if they are not synchronized.

Which three statements are true about System Global Area (SGA)?

A. SGA contains shared memory structures for all Oracle processes running on a single server.

B. Each server process has its own SGA.

C. SGA is allocated automatically when a database is started.

D. SGA is used to speed up queries by caching data blocks, program data, information about database objects, and query results

E. SGA is allocated automatically when a database is mounted.

F. SGA is read and written by server and background processes.

You connect to a database instance and execute a DML command that changes one data block. The block is read from the buffer cache, modified, and modified, and marked as dirty. You commit the transaction. What must take place before the block can be written to disk?

A. The buffer must be written to flash cache.

B. A log writer (LGWR) must write all redo entries that have been copied into the buffer since the last time it wrote.

C. The modified data block must be moved from the LRU list to the write queue.

D. The database must advance the checkpoint.