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

non-cumulative

multi-version

proactive

stabilizing

cumulative

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.

Database Buffer Cache

Undo Log Buffer

Shared Pool

Small Pool

Java Pool

Private SQL Area

addition or removal of nodes, memory, or disks

changing configuration parameters, upgrading, or patching Oracle software

file deletion

migrating to cluster architecture

dropped database object

table definition changes

runaway processes that consume system resources

when multiple databases are to be registered with the listener

when DBAs need to connect remotely to start up the database instance

when users need to connect the database instance by using the host naming method

when the database instance to be registered with the listener is configured in shared server mode

A CHECK constraint is created on the OID column.

A NOT NULL constraint is created on the OID column.

The ORDERS table is the only object created in the USERS tablespace.

The ORDERS table and a unique index are created in the USERS tablespace.

The ORDERS table is created in the USERS tablespace and a unique index is created on the OID column in the SYSTEM tablespace.

You should not install the Oracle Database software into an existing Oracle home from a different release.

A multitenant container database (CDB) can have several pluggable databases (PDBs) with different character sets.

Oracle recommends that you back up the root. sh script after you complete the installation.

Cloning an Oracle home is useful if you are performing multiple Oracle Database Installations.

You can stop existing Oracle processes, including the listener and the database running in the Oracle home, before the database software installation.

only from the server, if the database instance is not up

from either a client or server, even if the database instance is not up

from either a client or server, only if the database instance is up, and the command connects the session to the instance

from either a client or server, only if the database instance is up, but the command does not connect the session to the instance

Automatic Storage Management (ASM)

OS file system

logical volume (LVM)

clustered file system

RAW

It transparently encrypts data at rest in Oracle databases.

It securely manages encryption keys.

It protects against theft or loss of disks and backups.

It prevents OS users from inspecting tablespace files.

It limits the exposure of sensitive data in applications.

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

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

7801

5500

2243

1521

22

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

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

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

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

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

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

create local role l_hr;

create role c##_hr container=current;

create role l_hr container=current;

create role l_hr container=all;

Listeners use only the TCP/IP protocol.

Multiple listener processes can run simultaneously on a host.

Multiple database instances can be registered with a single listener,

Listener-related errors can be traced only at the administrative level.

Only one database instance can be registered with a single listener at any time.

It is ignored by the query optimizer.

It is not used while the index is being rebuilt.

The index cannot be rebuilt, and has to be re-created.

The index is automatically rebuilt when used the next time.

listener

user process

service name

server process

Oracle Data Guard

Oracle Streams

Oracle Real Application Clusters

Oracle GoldenGate

Nothing else happens.

The database is mounted but not opened.

The database is mounted and finally opened.

The database is opened and finally mounted.

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

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

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

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