Oracle Database 12c Essentials Practice Tests and PDFs

Your customer wants all email addresses from the database displayed as [hidden]@company.com. What method of data redaction must you use? E. no redaction http://docs.oracle.com/database/121/ASOAG/redaction_config.htm#ASOAG10563

What happens if you execute these SQL statements? SQL> show con_name CON_NAME -------------------------------- CDB$ROOT SQL> create user 1_freed identified by y container=current;

Consider 10 scenarios that result in database downtime. Which five of them are considered as planned downtime? E. dropped database object F. table definition changes G. runaway processes that consume system resources H. adding table partitioning I. operating system or storage device / driver failure J. database or application deadlocks http://docs.oracle.com/cd/E11882_01/server.112/e10803/schedule_outage.htm#HABPT5083

You went to create a new CDB foe your customer. Which two statements are true about the seed pluggable database that will reside in the new CDB? E. The seed pluggable database is always kept in READ ONLY mode. F. The seed pluggable database is not a container. G. The seed pluggable database can be dropped. http://docs.oracle.com/database/121/ADMIN/cdb_create.htm#BABHACEC

A standby database is in mounted state and you are required to perform a failover to the physical standby. Which solution is best suited forthis scenario? keyword statements Statements

Which two statements are true about transactions in Oracle Database 12c? store undo data.

You execute some DMLcommands, followed by a COMMIT Statement. Which option correctly describes how the logwriter (LGWR) process takes part in the transaction commit? E. 1. LGWR puts the commit record to Redo Log Buffer.

Which two statements about PDBs and CDBs are true? E. There is one SYSAUXtablespace per PDB.

Your customer is looking for a solution that meets these four needs: 1 - Replicate data from source to target for reporting purposes. 2 -Replicate data from one source to multiple targets. 3 - Replicate data between two databases for instant failover. 4 - Replicate data from multiple sources to a single target for a data warehouse. Which GoldenGate-supported topology would you recommended?

You want to clone PDB1 and PDB2 into the same CDB. Which statement is correct?