1z0-497 Exam Dumps - Oracle Database 12c Essentials

Go to page:

Question # 9

You create a CDB with four containers: the loot, the seed, and two pluggable databases PDB1 and PDB2. Which four items can reside In PDB1, but not in the root?

shared UNDO and default database temporary tablespace

Oracle-supplied metadata

shared Oracle-supplied data

CDB views providing information across PDBs

application tablespaces

local temporary tablespaces

local users and local roles

Full Access

Question # 10

Which three statements represent the benefits of multitenant architecture for database consolidation?

You can unplug a PDB from a development CDB and plug it into a production CDB, which allows for easier and more rapid movement of data and code.

You can consolidate shared database memory by combining multiple PDBs in a single CDB.

Patching individual PDBs requires the same amount of time as patching individual databases.

Consolidating separate databases into a single CDB requires the same amount of storage allocation.

In multitenant architecture, a PDB behaves the same as a non-CDB as seen from a client connecting with Oracle Net. No client modification is required.

Full Access

Question # 11

Which three DBA operations can be performed by using Oracle SQL Developer?

database backup and recovery using RMAN

performance tuning operations such as generation of AWR, ADDM, and ASH reports

storage configuration for archive logs and control files

storage configuration for data files and redo log groups

database status view and Data Pump export and import jobs

Full Access

Question # 12

Which three events signal a database writer (DWR) to write buffers to disk?

The database advances a checkpoint.

A client process commits a transaction.

The redo log buffer becomes full.

A server process cannot find non-dirty blocks after scanning a threshold number of buffers.

A tablespace is changed to read-only status.

The database is shut down in immediate mode.

Full Access

Question # 13

Which statement is true about Enhanced Real-Time ADDM in Oracle Database 12c?

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

It runs every 1 hour automatically.

It is shipped only with Oracle Enterprise Manager 12c.

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

Full Access

Question # 14

Which tablespace contains the data dictionary, being automatically created at database creation?

USERS

TEMP

SYSAUX

SYSTEM

EXAMPLE

Full Access

Question # 15

The session of user SCOTT receives the following error after executing an UPDATE command on the EMP table:

ERROR at line 1:

ORA-00060: deadlock detected while waiting for resource

You find out that a session opened by user JIM has a transaction that caused the deadlock. Which two statements are true about SCOTT's session in this scenario?

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.

Full Access