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

merge patch

combine patch

overlay patch

dual patch

super patch

You should check the patch conflict with installed patches before applying the patch.

You should make sure that you have a good backup of the software, database, and configuration files.

You should install the latest O patch before applying the patch.

You should check the fifth digit of the release information to confirm that the Patch Set Update (PSU) is applied successfully.

You should stop all applications running from the software directory that is being patched.

These administrative privileges enable you to connect to the database only if the database is open.

After connecting with these privileges, you are connected under a predefined user whose name is the privilege name.

These administrative privileges allow a user to view DBA_xxx, GV$, VS, and SELECT on application tables.

Without being a member of OSBACKUP. OSDG, and OSKM OS groups, users cannot connect as administrative users by using OS authentication.

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.

STARTUP

SHUTDOWN

CREATE DATABASE

DROP DATABASE

ALTER DATABASE RECOVER

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

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.

Oracle Data Guard

Oracle Streams

Oracle Real Application Clusters

Oracle GoldenGate

PMON performs process recovery when a client process fails.

During instance startup, PMON takes care of instance recovery.

PMON performs listener registration.

PMON restarts background and dispatcher processes when they fail.

PMON resolves failures of distributed transactions.

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 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).

a, b, c, d, e, f

b, c, a, d, e, f

c, b, a, d, f, e

a, b, c, d

b, c, a, d

The DML operations re-create the bitmap index blocks.

The bitmap index is rebuilt automatically after a DML operation.

The smallest amount of a bitmap that can be locked is a bitmap segment.

Additional time is taken to remove NULL values from the bitmap index alter a DML operation.

The average active sessions were more than three times the number of CPU cores.

Active sessions were more than 10% of total load and CPU utilization was more than 50%.

Memory allocations were more than 95% of physical memory.

Hung sessions were more than 10% of total sessions.

A deadlock was detected.

The session limit was close to 100%.

It is used to retrieve installed patch information from a SQL prompt.

It uses the PREPROCESSOR feature, which allows users to preprocess input data before it is sent to the access drivers.

DBMS_QOPATCH provides a PL/SQL or SQL interface to view the database patches installed.

It works in an Oracle database instance that is mounted. Therefore, it works in ASM instances and DG instances.

non-cumulative

multi-version

proactive

stabilizing

cumulative

ADO policies can automatically compress data when it qualifies.

ADO policies can automatically move segments when necessary.

ADO is not dependent on Heat Map, and works even if Heat Map is disabled.

You cannot compress at block level, but you can compress at segment level.

You can compress at row level only for QUERY LOW.

cluster

database link

mapping table

materialized view

create local role l_hr;

create role c##_hr container=current;

create role l_hr container=current;

create role l_hr container=all;