Oracle 1Z0-497 Online Practice Questions and Exam Preparation

Oracle 1Z0-497 Online Questions & Answers

• Question 51:

  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)
  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

  ---

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

• Question 52:

  You are about to install Oracle Database 12c Enterprise Edition. Which statement is true?

  A. You should not install the Oracle Database software into an existing Oracle home from a different release.
  B. A multitenant container database (CDB) can have several pluggable databases (PDBs) with different character sets.
  C. Oracle recommends that you back up the root. sh script after you complete the installation.
  D. Cloning an Oracle home is useful if you are performing multiple Oracle Database Installations.
  E. You can stop existing Oracle processes, including the listener and the database running in the Oracle home, before the database software installation.
  B. A multitenant container database (CDB) can have several pluggable databases (PDBs) with different character sets.

• Question 53:

  Which four items exist in the root of a CDB, but not in the PDBs?

  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
  A. shared UNDO and default database temporary tablespace
  B. Oracle-supplied metadata
  C. shared Oracle-supplied data
  D. CDB views providing information across PDBs

• Question 54:

  You are about to apply a patch to a database. Which recommended action is incorrect?

  A. You should check the patch conflict with installed patches before applying the patch.
  B. You should make sure that you have a good backup of the software, database, and configuration files.
  C. You should install the latest O patch before applying the patch.
  D. You should check the fifth digit of the release information to confirm that the Patch Set Update (PSU) is applied successfully.
  E. You should stop all applications running from the software directory that is being patched.
  B. You should make sure that you have a good backup of the software, database, and configuration files.

• Question 55:

  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.
  A. They are required to support Flashback features.
  E. Undo records contain copies of data as it appears before a change is made.

  ---

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

• Question 56:

  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?

  A. Oracle GoldenGate
  B. Global Data Services
  C. Oracle Data Guard
  D. Data Recovery Advisor
  E. Oracle Flashback technology
  F. Oracle Advanced Queuing
  A. Oracle GoldenGate
  B. Global Data Services
  C. Oracle Data Guard
  E. Oracle Flashback technology

  ---

  Reference: http://docs.oracle.com/cd/E16655_01/server.121/e17601/unplanned.htm#HAOVW11824

• Question 57:

  You connect to a database instance and execute a DML command that changes one data block. The block is read from the buffer cache, modified, and modified, and marked as dirty. You commit the transaction.

  What must take place before the block can be written to disk?

  A. The buffer must be written to flash cache.
  B. A log writer (LGWR) must write all redo entries that have been copied into the buffer since the last time it wrote.
  C. The modified data block must be moved from the LRU list to the write queue.
  D. The database must advance the checkpoint.
  B. A log writer (LGWR) must write all redo entries that have been copied into the buffer since the last time it wrote.

• Question 58:

  You are in the middle of transaction, updating a table. The machine on which the database is running reboots because of a power outage. This causes a database instance failure.

  Which statement is true in this situation?

  A. The online redo log files and archived redo log files are required to accomplish a recovery.
  B. The uncommitted transaction is committed at the next startup of the database instance.
  C. The uncommitted transaction is rolled back automatically at the next opening of the database.
  D. The DBA has to perform a recovery on the database to recover the uncommitted transaction.
  C. The uncommitted transaction is rolled back automatically at the next opening of the database.

• Question 59:

  Which statement about CDB architecture is true?

  A. Oracle-supplied metadata resides only in the root container.
  B. A seed PDB can sometimes be opened for particular operations.
  C. Multiple PDBs with the same name can reside in the same CDB.
  D. A CDB can have an infinite number of PDBs.
  E. You can create common users in PDBs.
  A. Oracle-supplied metadata resides only in the root container.

  ---

  Reference: http://docs.oracle.com/cd/E16655_01/server.121/e17633/cdbovrvw.htm#CNCPT89235

• Question 60:

  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
  E. application tablespaces
  F. local temporary tablespaces
  G. local users and local roles
  H. non-shared local metadata