Oracle Oracle Certifications 1Z0-497 Questions & Answers

• Question 111:

  When you start up a CDB, which operations are performed automatically and in what order?

  a - The instance is started.

  b - Control files are opened.

  c - The root container is opened (redo logs and root data files).

  d - Seed pluggable database is in READ ONLY mode.

  e - Other PDBs are still in MOUNTED mode.

  f - Triggers may fire if they exist to open other PDBs.

  A. a, b, c, d, e, f

  B. b, c, a, d, e, f

  C. c, b, a, d, f, e

  D. a, b, c, d

  E. b, c, a, d

  Correct Answer: D

• Question 112:

  Which new process was introduced as of Oracle Database 12c?

  A. Result Cache Background process (RCBG)

  B. AQ Coordinator process (QMNC)

  C. Change Tracking Writer process (CTWR)

  D. Listener Registration process (LREG)

  Correct Answer: D

  Reference: http://musingdba.wordpress.com/2013/07/05/new-in-oracle-database-12c-a/

• Question 113:

  

  Which two statements are true about this common user?

  A. SQL> conn c##usr/pwd@pdb1 You are connected to PDB1 successfully.

  B. SQL> conn c##usr/pwd@pdb2 You are connected to PDB2 successfully.

  C. SQL> conn c##usr/pwd@pdb2 You are unable to create a connection. You first need to sync PDB2 by executing: SQL> conn / as sysdba SQL>exec DBMS_PDB.SYNC_PDB;

  D. SQL> conn c##usr/pwd@pdb2 You are unable to create a connection. You need to create the common user c# #usr explicitly in PDB2 by executing: SQL>conn system/pwd@pdb2 SQL> CREATE USER c##usrIDENTIFIED BYpwd CONTAINER=CURRENT; Now you are able to connect as common user c##usr to PDB2.

  Correct Answer: AD

• Question 114:

  Which option represents a function of Global Data Services (GDS)?

  A. performs data replication

  B. performs database failovers

  C. replaces the functionality of Oracle Clusterware and Oracle RAC

  D. coordinates site failovers

  E. works seamlessly with Oracle Site Guard

  Correct Answer: AB

• Question 115:

  Which two statements represent where Oracle Net must reside?

  A. Only on the client for traditional client/server applications

  B. Only on the database server for web-based applications

  C. On both the web server and database server for web-based applications

  D. On both the client and database server for traditional client/server applications.

  Correct Answer: BD

• Question 116:

  Which command do you use to check for block corruption by validating the database?

  A. RMAN> VALIDATE CHECK LOGICAL

  B. RMAN> VALIDATE BACKUP

  C. RMAN> VALIDATE CORRUPT BLOCKS

  D. RMAN> VALIDATE DATABASE

  Correct Answer: D

  since 11g the syntax got changed to

  RMAN> validate [check logical] database;

  Example:

  DGMGRL> validate database verbose d1

  output include:

  Block Corruptions found NO NO

• Question 117:

  Which tool is recommended for moving a PDB to a non-CDB?

  A. RMAN

  B. Cold Backup

  C. Traditional Export / Import

  D. Data Pump

  E. SQL*Plus

  Correct Answer: E

  Creating a PDB by Plugging an Unplugged PDB into a CDB

  An unplugged PDB consists of an XML file that describes the PDB and the PDB's files (such as the data files and wallet file). You can use the CREATE PLUGGABLE DATABASE statement to plug in an unplugged PDB. To do so, you must include a USING clause that specifies the XML file that describes the PDB.

  The source CDB is the CDB from which the PDB was unplugged. The target CDB is the CDB into which you are plugging the PDB. The source CDB and target CDB can be the same CDB or different CDBs.

• Question 118:

  Which two statements describe data dictionary views?

  A. They are stored in the SYSTEM tablespace.

  B. They are based on virtual tables.

  C. They are owned by the SYS user.

  D. They speed up query and data manipulation language (DML) operations.

  E. The VSFIXED_TABLEview can be queried to list the names of these views.

  Correct Answer: DE

• Question 119:

  

  Which two statements about this policy are true?

  A. It replaces the first four digits of the value from the SALARY column with the number 9.

  B. It replaces the first digit of the value from the SALARY column with the number 4.

  C. It replaces the first digit of the value from the COMMISSION_PCTcolumn with 9.

  D. It replaces the first nine digits of the value from the COMMISSION_PCTcolumn with 1.

  E. It uses the full data redaction method.

  F. It uses the random redaction method.

  Correct Answer: DF

• Question 120:

  Examine the table:

  Table name: PRODUCTS Schema: SCOTT Tablespace: USERS Organization: Standard (Heap Organized)

  This table contains 20 rows. In the data that has been entered, the PROD_ID column contains only single-digit values, PROD_NAME has a maximum of five characters, and PROD_RATE has four-digit values for all rows.

  Which two statements are true regarding the modifications that can be performed to the structure of the PRODUCTS table?

  A. PROD_NAME size can be increased from five to 10 characters.

  B. PROD_ID can be changed from CHAR to NUMBER data type.

  C. PROD_RATE size can be changed from NUMBER(4) to NUMBER(6, 2).

  D. New columns can be added only if they have a NOT NULL constraint.

  E. None of the existing columns can be dropped because they contain data.

  Correct Answer: AC