1Z0-497 Oracle Database 12c Essentials Practice Exam

Sample Questions:

When executing shutdown abort in a pluggable database (PDB), you ____________.

shut down abort the CDB

shut down abort the PDB

shut down immediate the PDB

shut down immediate the CDB

Which is the default isolation level in Oracle Database 12c?

serializable

read-only

read committed

read uncommitted

Your customer is planning for a maximum-availability architecture at their data center to address their planned downtime, unplanned downtime, and replication needs. Consider these options: – Instance, site recovery, and heterogeneous setup – Inter-region and intra-region load balancing across replicated databases – Fine-grained error investigation of incorrect results – Integrated client and application failover – Fastest and simplest database replication Which four options would you recommend?

Oracle GoldenGate Global Data Services

Oracle Data Guard Data Recovery Advisor

Oracle Flashback technology

Oracle Advanced Queuing

Which two statements are true about Oracle Data Pump?

EXPDP and IMPDP are the client components of Oracle Data Pump

DBMS_DATAPUMP PL/SQL packages can be used independently of Data Pump clients.

Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

Oracle Data Pump imports can be done from the export files generated in Original Export Release 9.x

EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.

Which two statements correctly distinguish between undo and redo data?

Undo reverses a change, whereas redo re-creates a change.

Redo reverses a change, whereas undo re-creates a change.

Undo protects against inconsistent reads, whereas redo protects against data loss.

Redo protects against inconsistent reads, whereas undo protects against data loss

After a ___________ statement is issued, a transaction ends. (select three)

COMMIT ROLLBACK

SAVEPOINT

SELECT

CREATE

Which statement about Storage Snapshot Optimization is correct?

It enables you to use third-party technologies to take a storage snapshot of your database without putting the database in BACKUP mode. You can then use the snapshot to recover all or part of the database. It enables you to use RMAN to take a storage snapshot of your database. The database must be in BACKUP mode. You can then use the snapshot to recover all or part of the database.

It enables you to use RMAN to take a storage snapshot of your database. The database doesn’t have to be in BACKUP mode. You can then use the snapshot to recover all or part of the database.

It enables you to use third-party technologies to take a storage snapshot of your database. The database must be in BACKUP mode. You can then use the snapshot to recover all or part of the database.

There are two listeners, LISTENER1 arid LISTENER2, and one service name ORCL available for your database. The database is running and currently, only LISIENER1 is started. You issue the command: lsnrctl start listener2 What would be the outcome?

It starts the second listener without affecting current sessions.

It starts the second listener and terminates all current sessions

It gives an error because multiple listeners cannot run simultaneously.

It gives an error because multiple listeners can run simultaneously only if there are multiple net service names.

You add the following code in the tnsnames.ora file on a client PC: sales= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP)(HOST=salesdata) (PORT=1521) ) (CONNECT_DATA= (SERVICE_NAME=sales.acme))) Which statement is true about the code with respect to creating a new connect identifier?

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.

Who this course is for:

• Those who want to get knowledge in Certifications & Check you skill Test while attend this Practice Test