A.  

Tablespace< Segment < Extent < Oracle Datablock

B.  

B) Segment < Extent < Oracle Datablock

C.  

Tablespace< Extent < Segment < Oracle Datablock

D.  

Data File

A.  

S sqlplus / as sysdba

SQL> restart;

B.  

S sqlplus / as sysdba

SQL> startup immediate;

C.  

S rman target /

RMAN> Startup

D.  

S sqlplus / as sysdba

SQL> startup open recover;

E.  

S srvctl start database -db SORACLE_SID

A.  

undo data

B.  

isolation level

C.  

lock mechanism

D.  

serializability

A.  

You have to copy the seed data files yourself,

B.  

You can use the new SEED FILE_NAME_CONVERTclause in the CREATE DATABASE statement.

C.  

The seed pluggable database is not required.

D.  

The seed pluggable database does not require data files.

E.  

The seed pluggable database is always kept in READ ONLY mode.

F.  

The seed pluggable database is not a container.

G.  

The seed pluggable database can be dropped.

A.  

Redo is not generated while performing conventional path loads.

B.  

Only PRIMARY KEY, UNIQUE KEY, and NOT NULL constraints are checked,

C.  

No exclusive locks are acquired when the conventional path loads are performed.

D.  

Instead of performing transactions, SQL*Loader directly writes data blocks to the data files.

E.  

INSERT triggers are disabled before the conventional path load and re-enabled at the end of the load.

A.  

select patch from vSoption where opatch_data=' 333333' ;

B.  

select xmltransform(dbms_qopatch.get_opatch_data(3333333), dbms_qopatch.GET_OPATCH_XSLT()) from dual

C.  

select opatch from vSpatchsets where opatch_number = '333333';

D.  

opatchlsinventory -xml

A.  

Automatic Storage Management (ASM)

B.  

OS file system

C.  

logical volume (LVM)

D.  

clustered file system

E.  

RAW

A.  

The database stops (shutdown abort).

B.  

B) The database Stops (shutdown immediate).

C.  

You activate Automatic Shared Memory Management.

D.  

You get an error message.

A.  

shared UNDO and default database temporary tablespace

B.  

Oracle-supplied metadata

C.  

shared Oracle-supplied data

D.  

CDB views providing information across PDBs

E.  

application tablespaces

F.  

local temporary tablespaces

G.  

local users and local roles

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.

A.  

It replaces the first four digits of the value from the SALARY column with the number 9.

B.  

It replaces the first digit of the value from the SALARY column with the number 4.

C.  

It replaces the first digit of the value from the COMMISSION_PCTcolumn with 9.

D.  

It replaces the first nine digits of the value from the COMMISSION_PCTcolumn with 1.

E.  

It uses the full data redaction method.

F.  

It uses the random redaction method.

A.  

Real-Time ADDM uses AWR snapshots of the last 10 minutes.

B.  

Real-Time ADDM uses ASH recent activity from SGA data.

C.  

Real-Time ADDM analyzes performance in a completely different fashion than regular ADDM.

D.  

Regular ADDM uses AWR snapshots that are not yet purged.

A.  

durability

B.  

consistency

C.  

concurrency

D.  

isolation

E.  

scalability

F.  

manageability

A.  

Multiple transactions can use the same undo segment.

B.  

A transaction is assigned an undo segment when it is started.

C.  

Multiple transactions cannot share the same extent in an undo tablespace.

D.  

If all the segments in an undo tablespace are used, transactions use system undo segments to store undo data.

A.  

It transparently encrypts data at rest in Oracle databases.

B.  

It securely manages encryption keys.

C.  

It protects against theft or loss of disks and backups.

D.  

It prevents OS users from inspecting tablespace files.

E.  

It limits the exposure of sensitive data in applications.

F.  

It alters data in caches, buffers, and persistent storage.

G.  

It impacts operational activities such as backup & restore, upgrade & patch, and replication.

A.  

3, 4, and 5

B.  

1, 2, 5, and 6

C.  

1, 2, 3, and 4

D.  

2, 3, 5, and 6

E.  

2, 3, 4, 5, and 6

F.  

1, 2, 3, 4, 5, and 6

A.  

A common user cannot have the same name as any local user across all PDBs.

B.  

A common user can be created only in the root container.

C.  

A local user with the proper privileges can also create a common user.

D.  

If a PDB is closed, the common and local users of the PDB are not visible.

E.  

A common user with the proper privileges can create a common user by using the CONTAINER=CURRENT clause.

F.  

A common user is one that has the same username and authentication credentials across multiple PDBs.

A.  

The analyzed result is lost when the database instance is restarted.

B.  

It runs every 1 hour automatically.

C.  

It is shipped only with Oracle Enterprise Manager 12c.

D.  

It analyzes high CPU trend and identifies problems before they can threaten application performance.

A.  

It requires the database to be open.

B.  

It analyzes the performance of specified objects.

C.  

It implements all recommendations automatically.

D.  

It recommends solutions and quantifies expected benefits.

E.  

It retains snapshots in the SYSAUX tablespace until the database is restarted.

F.  

It analyzes the snapshots stored in the Automatic Workload Repository (AWR).

A.  

create local role l_hr;

B.  

create role c##_hr container=current;

C.  

create role l_hr container=current;

D.  

create role l_hr container=all;

A.  

multitenant< schema consolidation< dedicated database< VMs

B.  

schema consolidation< VMs< dedicated databases< multitenant

C.  

dedicated databases< VMs< schema consolidation< multitenant

D.  

VMs< dedicated databases< schema consolidation< multitenant

A.  

They are required to support Flashback features.

B.  

They are not required if Flashback features are enabled.

C.  

They are retained until the session making the changes ends.

D.  

Undo records contain copies of data as it appears after a change is made.

E.  

Undo records contain copies of data as it appears before a change is made.