Oracle Oracle Certifications 1Z0-497 Questions & Answers

• Question 61:

  Several tables are accidentally deleted from a PDB. Which database would you immediately connect to, and as which user, to recover these tables?

  A. the CDB as the ROOT user

  B. the CDB as the CDBADMIN user

  C. the PDB as the ROOT user

  D. the PDB as the PDB Admin user

  Correct Answer: A

• Question 62:

  Identify two solutions that Oracle provides for patch conflict.

  A. merge patch

  B. combine patch

  C. overlay patch

  D. dual patch

  E. super patch

  Correct Answer: AC

• Question 63:

  Which two statements are true when you execute an invoker's rights procedure?

  A. The owner must have the INHERIT PRIVILEGES object privilege on the invoking user, or the INHERIT ANY PRIVILEGES privilege.

  B. Invoking users can control who can access their privileges when they run an invoker's rights procedure.

  C. The calling user must be granted the INHERIT PRIVILEGES object privilege on the user owner of the procedure.

  D. The calling user must grant the INHERIT PRIVILEGES object privilege on the user owner of the procedure.

  Correct Answer: AB

  Reference: http://docs.oracle.com/cd/E16655_01/network.121/e17607/dr_ir.htm#DBSEG661

• Question 64:

  You create a CDB with four containers: the loot, the seed, and two pluggable databases PDB1 and PDB2.

  Which four items can reside In PDB1, but not in the root?

  A. shared UNDO and default database temporary tablespace

  B. Oracle-supplied metadata

  C. shared Oracle-supplied data

  D. CDB views providing information across PDBs

  E. application tablespaces

  F. local temporary tablespaces

  G. local users and local roles

  H. non-shared local metadata

  Correct Answer: EFGH

• Question 65:

  Identify two types of solutions in which you would need to use Active Data Guard and Golden Gate together.

  A. a solution that provides zero-data-loss protection at any distance without impacting database performance

  B. a solution for disaster protection and database rolling upgrades for a mission-critical OLTP database, where you also want to extract data from a data guard primary database for ETL update o' an enterprise data warehouse

  C. a solution requiring minimal planned downtime and risk, using standby first patching, database rolling upgrades, and select platform migrations

  D. a solution that helps with integrated automatic database and client failover between source and target, where you also need to establish advanced replication (such as multi master and bidirectional replication and data transformations)

  Correct Answer: BC

  Reference: http://www.oracle.com/technetwork/database/availability/active-data-guard-wp-12c1896127.pdf (page 16, last two bulleted points)

• Question 66:

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  E. Option E

  Correct Answer: BCD

• Question 67:

  Which statement about a server parameter file (SPFILE) is false?

  A. An SPFILE is a binary file that cannot be edited by using a text editor.

  B. You can create an SPFILE from an existing text initialization parameter file or from memory.

  C. You can use the SHOW PARAMETERS command to display the values of initialization parameters in an SPFILE.

  D. The instance first searches for an SPFILE named spfileoRACLE_SID.ora and, if this is not found. It searches for spfile.ora.

  Correct Answer: D

  Not A, not B: SPFILE is a text file that can be created from a file or from scratch.

  Not C: This shows database was started by spfile

  SQL> show parameter spfile;

  NAME TYPE VALUE

  ---- ---- ---------------------------------------------------------- spfile string /root/apps/oracle/10g/dbs/

  spfile.ora No values returned means its started by pfile.

• Question 68:

  Which statement about the Queryable Patch inventory feature is false?

  A. It is used to retrieve installed patch information from a SQL prompt.

  B. It uses the PREPROCESSOR feature, which allows users to preprocess input data before it is sent to the access drivers.

  C. DBMS_QOPATCH provides a PL/SQL or SQL interface to view the database patches installed.

  D. It works in an Oracle database instance that is mounted. Therefore, it works in ASM instances and DG instances.

  Correct Answer: B

  *

  New in Oracle 12c is queryable Opatch. Oracle offers a set of tables and a PL/SQL packages to query

  the Oracle Inventory.Prior to Oracle 12c, it was not easy to List Oracle patches. Now from Oracle 12c and

  beyond, you can use the DBMS_QOPATCH package to list all patches.

  *

  Using DBMS_QOPATCH feature, users can do:

  Query what patches are installed from SQL*Plus.

  Write wrapper programs to create reports and do validation checks across multiple environments. Check

  patches installed on Oracle RAC nodes from a single location instead of having to log onto each one in

  turn.

• Question 69:

  Which two statements about switchover and failover are true?

  A. A snapshot standby can be the target of a switchover or fast-start failover operation.

  B. Neither a switchover nor a failover is possible to a far sync instance.

  C. For fast-start failover, you must preselect the target standby database that will be used.

  D. You can activate a standby database to test whether it is being updated correctly.

  Correct Answer: BC

  Reference: http://docs.oracle.com/cd/E16655_01/server.121/e17641/sofo.htm#DGBKR3404 http:// docs.oracle.com/cd/E11882_01/server.112/e17023/sofo.htm#DGBKR3310

• Question 70:

  Identify three types of important statistics collection that you can disable in Oracle Database 12c by setting the STATISTIS_LEVEL parameter to BASIC.

  A. Oracle Database alert.log file

  B. object-level statistics

  C. Automatic SGA Memory Management

  D. Oracle Database Trace files

  E. all server-generated alerts

  Correct Answer: BCE