Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

examout.co

Which two items are key for maintaining data consistency in Oracle Database 12c?

A.

undo data

B.

isolation level

C.

lock mechanism

D.

serializability

Which three options correctly match environment variables with their specific functionality?

A.

ORACLE_SID specifies the instance name.

B.

ORACLE_SID specifies the global database name.

C.

ORACLE_BASE specifies the root of the Oracle Database directory tree in all platforms.

D.

ORACLE_BASE specifies the root of the Oracle Database directory tree only in UNIX and Linux platforms.

E.

ORACLE_HOME specifies the directory containing the Oracle software executables and network files.

F.

ORACLE_HOME specifies the directory containing only the Oracle software executables, but not the network files.

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?

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

Which command do you use to create a local role while you are connected as the local user?

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;

Your database is open and the listener is running. The DBA stops the listener by using the command:

LSNRCTL> STOP

What happens to the sessions that are currently connected to the database instance?

A.

They can perform only queries.

B.

They are not affected and continue to function normally.

C.

They are terminated and the active transactions are rolled back.

D.

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

You execute some DMLcommands, followed by a COMMIT Statement.

Which option correctly describes how the logwriter (LGWR) process takes part in the transaction commit?

A.

1. LGWR writes the commit record to disk.

2. LGWR writes all redo entries from Redo Log Buffer to disk.

B.

1. GWR writes only the transaction's redo entries from Redo Log Buffer to disk.

2. LGWR writes the commit record to disk.

C.

1. LGWR puts the commit record to Redo Log Buffer.

2. IGWR writes all redo entries from Redo Log Buffer to disk.

D.

1. LGWR puts the commit record to Redo Log Buffer.

2. If the activity is high, LGWR waits three seconds for other transactions to commit.

3. LGWR writes all redo log entries from Redo Log Buffer to disk.

E.

1. LGWR puts the commit record to Redo Log Buffer.

2. LGWR signals the database writer (DBW) process to write dirty blocks to disk.

3. LGWR writes all redo entries from Redo Log Buffer to disk.

Which two statements about ADDM are true?

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.

Which two statements are true about listeners?

A.

Listeners use only the TCP/IP protocol.

B.

Multiple listener processes can run simultaneously on a host.

C.

Multiple database instances can be registered with a single listener,

D.

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

E.

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

Your customer is looking for a solution to address these downtime needs:

- Online addition and removal of disks should automatically rebalance data across new storage configurations while storage, database, and applications remain online.

- Dynamically add or remove clustered nodes without disrupting the database or applications.

- Automate the sizing and distribution of shared memory.

- Add a column with a default value without disrupting the database or applications.

- Perform rolling patch upgrades.

Which four would you recommend to address those needs?

A.

Automatic Storage Management (ASM)

B.

Online Data and Application change

C.

Global Data Services (GDS)

D.

Real Application Clusters (RAC)

E.

Oracle Streams

F.

Online Table Redefinition

G.

Oracle Database Vault

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

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.