Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Oracle 1z0-497 - Oracle Database 12c Essentials

Oracle 1z0-497 Premium Access     Download Demo    
Page: 5 / 5
Total 150 questions

Which parameter can be changed by explicitly re-creating the control file or by using the DBNEWID utility?

A.

db_name

B.

maxdatafiles

C.

control_files

D.

instance_name

Which two are client-side components of Oracle Data Guard Broker?

A.

Oracle Enterprise Manager Cloud Control

B.

Oracle Data Guard monitor

C.

Oracle Data Guard command-line interface (DGMGRL)

D.

Oracle Data Guard Broker Manager

You are in the middle of transaction, updating a table. The machine on which the database is running reboots because of a power outage. This causes a database instance failure.

Which statement is true in this situation?

A.

The online redo log files and archived redo log files are required to accomplish a recovery.

B.

The uncommitted transaction is committed at the next startup of the database instance.

C.

The uncommitted transaction is rolled back automatically at the next opening of the database.

D.

The DBA has to perform a recovery on the database to recover the uncommitted transaction.

Which statement about CDB architecture is true?

A.

Oracle-supplied metadata resides only in the root container.

B.

A seed PDB can sometimes be opened for particular operations.

C.

Multiple PDBs with the same name can reside in the same CDB.

D.

A CDB can have an infinite number of PDBs.

E.

You can create common users in PDBs.

You have two database servers EMP and EXP. A user of the database from the EXP server wants to extract some information from the database in the EMP server for cross-verification. Which schema object enables the user to access the information from the remote database?

A.

cluster

B.

database link

C.

mapping table

D.

materialized view