1z0-497 Oracle Database 12c Essentials Questions and Answers

3, 4, and 5

1, 2, 5, and 6

1, 2, 3, and 4

2, 3, 5, and 6

2, 3, 4, 5, and 6

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

The Oracle Streams information flow consists of three components: capture, redo transfer, arid consumption.

Oracle Streams is deprecated in Oracle Database 12c Release 1.

Oracle Database Advanced Replication is deprecated in Oracle Database 12c Release 1, including multimaster replication, updatable materialized views, multitier materialized views, and deployment templates.

Oracle Database Advanced Queuing is independent of Oracle Streams.

The Oracle GoldenGate software architecture is composed of three primary components: capture, propagate, and trail files.

They can perform only queries.

They are not affected and continue to function normally.

They are terminated and the active transactions are rolled back.

They are not allowed to perform any operations till the listener is started.

Process Monitor process (PMON)

Listener Registration process (LREG)

System Monitor process (SMON)

Database Writer process (DBW)

Log Writer process (LGWR)

Checkpoint process (CKPT)

b, c, a

d, a, e

a, e, d, b

d, b, c, a, e

c, b, d, a, e

Automatic Storage Management (ASM)

Online Data and Application change

Global Data Services (GDS)

Real Application Clusters (RAC)

Oracle Streams

Online Table Redefinition

Oracle Database Vault

durability

consistency

concurrency

isolation

scalability

manageability

Multiple PDBs on a single server need multiple database instances and multiple sets of database files.

Although consolidated into a single physical database, PDBs mimic the behavior of non-CDBs.

A PDB administrator can use Oracle Flashback or point-in-time recovery to retrieve lost data from a PDB, only by shutting down all the PDBs from the CDB.

It is easier to collect performance metrics for many databases in a CDB than individual non-CDB databases.

It takes more time to apply a patch to one CDB that holds hundreds of PDBs than to hundreds of non-CDB databases.

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

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

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

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

It uses the full data redaction method.

It uses the random redaction method.

undo data

isolation level

lock mechanism

serializability

You have to copy the seed data files yourself,

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

The seed pluggable database is not required.

The seed pluggable database does not require data files.

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

The seed pluggable database is not a container.

The seed pluggable database can be dropped.

It requires the database to be open.

It analyzes the performance of specified objects.

It implements all recommendations automatically.

It recommends solutions and quantifies expected benefits.

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

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

The session is terminated after receiving the error and JIM can continue with his transaction.

SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.

The session is rolled back after receiving the error and JIM can continue with his transaction.

SCOTT has to re-execute the last command in the transaction after he commits the transaction.

It uses internal infrastructure components, such as XDB and SQL*Net.

It can perform actions outside the database.

It has background tasks and processes that periodically collect information via FTP.

It has two new features: Performance Hub and Composite Active Reports.

It is not supported on Standard Edition (SE) and Express Edition (XE).

They are stored in the SYSTEM tablespace.

They are based on virtual tables.

They are owned by the SYS user.

They speed up query and data manipulation language (DML) operations.

The VSFIXED_TABLEview can be queried to list the names of these views.

The instance is started.

The CDB control files are opened for the instance.

The root is mounted.

The root is opened.

The PDBs are mounted.

The PDBs are mounted, and the seed is opened in READ ONLY mode.

The PDBs are mounted, and opened in READ WRITE mode, while the seed is opened In READ ONLY mode.

A data file can span across tablespaces.

An extent contains one or more segments.

Tablespaces contain one or more data files.

Data objects are stored as segments in tablespaces.

Segments can span across data files within a tablespace.

It is created for the SALES database in the network domain ACME on the SALESDATA server.

It is created for the SALESDATA database on the SALES server in the network domain called ACME.

It generates an error because the connect identifier name cannot be a part of SERVICE_NAME.

It generates an error because the server configuration mode (dedicated or shared) is not specified.

When a buffer is read from a buffer cache, it may be inconsistent and require undo data to make it consistent.

A buffer cache stores copies of data blocks from all files of the database.

Buffer access is kept efficient by maintaining a least recently used (LRU) list for dirty and clean buffers.

A buffer cache always resides completely in System Global Area (SGA).

A buffer cache contains exactly three pools: default, keep, and recycle pool.