A.The user account, oracle, and group, oinstall, can be used for all Oracle software installations.

B.oracle must be the owner of every Oracle Database installation.

C.oracle will be granted the SYSASM privilege when installing the Oracle Database software.

D.oracle can own an Oracle Database installation but not an Oracle Grid Infrastructure installation.

E.oracle will be an owner of the Oracle Inventory.

A.Recovery reads redo until the end of the redo thread, and then opens the database, smon then rolls back any dead transactions.

B.Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.

C.Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (ckpt).

D.Recovery begins from the start of any active redo log group or the start of the current log group if no other group is active.

E.Recovery reads redo until the end of the redo thread, smon rolls back any dead transactions, and then the database is opened.

F.Recovery begins from the beginning of the current redo log group.

A.Single-byte character sets provide better performance than multibyte character sets.

B.Unicode enables information from any language to be stored using a single character set.

C.Unicode is the only supported character set for Oracle databases created using Database Configuration Assistant (DBCA).

D.Single-byte character sets always use 7-bit encoding schemes.

E.Multibyte character sets allow more efficient space utilization than single byte character sets.

F.Single-byte character sets always use 8-bit encoding schemes.

A.A PDB snapshot can be a full copy of a source PDB.

B.A PDB snapshot can be a sparse copy of a source PDB.

C.A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.

D.A PDB snapshot depends on an existing storage snapshot of the source PDB.

E.A snapshot copy PDB can be a full copy of a source PDB.

F.A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.

G.A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.

A.The number of table rows is considered when evaluating the cost of accessing a table using an index.

B.Index balanced B*Tree height is considered when evaluating the cost of using an index.

C.The Statistics Advisor can help recommend the best way to gather statistics.

D.Statistics collected using DBMS_STATS always yield the best optimizer result.

E.The Statistics Advisor generates actions for all recommendations.