Oracle Oracle Certifications 1Z0-497 Questions & Answers

• Question 101:

  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.

  Correct Answer: D

  Note: Oracle Net Listener is a separate process that runs on the database server. It receives incoming client connection requests and manages the traffic of these requests to the database server.

• Question 102:

  Your customer wants all email addresses from the database displayed as [hidden]@company.com. What method of data redaction must you use?

  A. full redaction

  B. partial redaction

  C. regular expressions

  D. random redaction

  E. no redaction

  Correct Answer: B

• Question 103:

  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?

  A. Uni-directional for 1 Peer-to-peer for 2 Bi-directional for 3 Consolidation for 4

  B. Peer-to-peer for 1 Broadcast for 2 Bi-directional for 3

  Consolidation for 4

  C. Uni-directional for 1 Broadcast for 2 Bi-directional for 3 Consolidation for 4

  D. Peer-to-peer for 1 Consolidation for 2 Broadcast for 3 Cascading for 4

  Correct Answer: C

• Question 104:

  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.

  Correct Answer: C

• Question 105:

  Which two statements about PDBs and CDBs are true?

  A. There is only one SYSTEM tablespace per CDB.

  B. There is only one instance per PDB.

  C. There is a set of redo log files per PDB.

  D. There is only one UNDO tablespace per CDB.

  E. There is one SYSAUXtablespace per PDB.

  Correct Answer: DE

• Question 106:

  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?

  A. You have to copy the seed data files yourself,

  B. You can use the new SEED FILE_NAME_CONVERTclause in the CREATE DATABASE statement.

  C. The seed pluggable database is not required.

  D. The seed pluggable database does not require data files.

  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.

  Correct Answer: BG

• Question 107:

  Your database is down. You log in as the SYS user and issue this command: SQL> STARTUP

  What happens after the instance is started?

  A. Nothing else happens.

  B. The database is mounted but not opened.

  C. The database is mounted and finally opened.

  D. The database is opened and finally mounted.

  Correct Answer: C

  Reference: http://docs.oracle.com/cd/E17781_01/server.112/e18804/startup.htm

• Question 108:

  Which option represents the steps to add a multiplexed copy of the current control file or to rename a

  control file in Oracle Database 12c?

  a - Shut down the database.

  b - Restart the database.

  c - Copy an existing control file to a new location by using operating system commands. d - Edit the

  CONTROL_FILESparameter in the database initialization parameter file to add the new control file name,

  or to change the existingcontrol file name.

  A. b, c, d

  B. a, c, d, b

  C. a, d, b, c

  D. c, d, b

  Correct Answer: B

  Reference: http://docs.oracle.com/cd/E16655_01/server.121/e17636/control.htm#ADMIN11287

• Question 109:

  Your customer has two CDBs: one for Production and one for development. You are asked to create a new development PDB (salesdev) from an existing production PDB (salesprd). Which two options would accomplish this?

  A. You copy all the PDBSSEEDdata files from the production CDB into the development CDB and execute this on the development CDB; SQL> CREATE PLUGGABLE DATABASE salesdev ADMIN USER salesdm IDENTIFIED by password;

  B. You alter the salesprd source database to open in read-only mode, and start cloning the source database: SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY; SQL> CREATE PLUGGABLE DATABASE salesdev FROM salesprd;

  C. You alter the salesprd source database to open in read-only mode: SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY; In the development CDB, you create a databaselink "PRD" that connects to the root of the source CDB, and start cloning the source PDB: SQL> CREATE PLUGGABLE DATABASE salesdevFROM salesprd@prd;

  D. Connected as the salesprd local DBA, you create an XML using: SQL> ALTER PLUGGABLE DATABASE salespdb UNPLUG INTO ' /tmp/salesprd-xml' ; Copy the XML file and all salesprd-related files to the target CDB and start plugging the copy into the development CDB using: SQL> CREATE PLUGGABLE DATABASE salesdev USING' /tmp/salesprd.xml';

  Correct Answer: AD

  A: Creating a PDB Using the Seed

  You can use the CREATE PLUGGABLE DATABASE statement to create a PDB in a CDB using the files

  of the seed.

  D: Plugging In an Unplugged PDB

  To plug in an unplugged PDB, the following prerequisites must be met:

  *

  Complete the prerequisites described in "Preparing for PDBs".

  *

  The XML file that describes the PDB must exist in a location that is accessible to the CDB.

  The USING clause must specify the XML file.

  Etc

• Question 110:

  Which two statements are true regarding undo data records?

  A. They are required to support Flashback features.

  B. They are not required if Flashback features are enabled.

  C. They are retained until the session making the changes ends.

  D. Undo records contain copies of data as it appears after a change is made.

  E. Undo records contain copies of data as it appears before a change is made.

  Correct Answer: AE

  Reference: http://docs.oracle.com/cd/E11882_01/server.112/e25494/undo.htm#ADMIN11463