Oracle 1Z0-497 Quiz 1 Topic 8 Questions 1-5

Question: 1

After a ___________ statement is issued, a transaction ends. (select three)

ACOMMIT

BROLLBACK

CSAVEPOINT

DSELECT

ECREATE

Show Answer

Question: 2

Which three statements represent the difference between a container database (CDB)and a non-container database?

AA container database has exactly one seed PDB, and a non-container database has no seed PDB .

BIn a newly created non-CDB that does not yet contain user data, the data dictionary contains only system metadata. When application users create their own objects, this metadata is mixed with the system metadata. In a CDB, the data dictionary metadata is split between the root and the PDBs. The data dictionary in the PDB contains pointers to the data dictionary in the root.

CNew views are introduced. Next to DBA_views, AIL_-views, and USER_-views, there are CDB_-views. Both CDB and non-CDB databases can access this information.

DYou are allowed to create only a single HR user in a non-CDB database. This restriction is identical for a CDB database.

EEvery PDB in a CDB has its own control file. A non-CDB, which has no containers, needs only one control file.

Show Answer

Question: 3

Identify three key properties of a transaction in Oracle Database 12c.

Adurability

Bconsistency

Cconcurrency

Disolation

Escalability

Fmanageability

Show Answer

Question: 4

Which two statements are true regarding SQL*Plus?

AIt has commands for performing database administration operations.

BIt can be used in interactive but not batch mode for SQL commands.

CIt has to be installed separately after the Oracle Database 12c installation.

DOperating system commands can be executed from the SQL*Plus command prompt.

Show Answer

Question: 5

Which two statements about PDBs and CDBs are true?

AThere is only one SYSTEM tablespace per CDB .

BThere is only one instance per PDB.

CThere is a set of redo log files per PDB.

DThere is only one UNDO tablespace per CDB.

EThere is one SYSAUXtablespace per PDB.

Show Answer

Oracle 1Z0-497 Quiz:1 Topic:8 Questions:1-5