Oracle 1Z0-497 Online Practice Questions and Exam Preparation

Oracle 1Z0-497 Online Questions & Answers

• Question 1:

  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.
  C. 1. LGWR puts the commit record to Redo Log Buffer. 2. IGWR writes all redo entries from Redo Log Buffer to disk.

• Question 2:

  Which two items are key for maintaining data consistency in Oracle Database 12c?

  A. undo data
  B. isolation level
  C. lock mechanism
  D. serializability
  C. lock mechanism

  ---

  Reference: http://docs.oracle.com/cd/E11882_01/server.112/e25789/consist.htm#CNCPT88969 (overview of the oracle database locking mechanism)

• Question 3:

  Identify three outcomes of using the Oracle Multitenant option in Oracle Database 12c.

  A. less instance overhead
  B. increased storage cost
  C. minor application changes
  D. fast and easy provisioning
  E. same time needed for patching and upgrade as in the previous release
  F. isolation
  A. less instance overhead
  D. fast and easy provisioning
  E. same time needed for patching and upgrade as in the previous release

• Question 4:

  Which three options best describe Patch Set Updates (PSUs) in Oracle Database 12c?

  A. non-cumulative
  B. multi-version
  C. proactive
  D. stabilizing
  E. cumulative
  C. proactive
  D. stabilizing
  E. cumulative

• Question 5:

  Which statement about the Oracle Advanced Security Data Redaction feature is true?

  A. It transparently encrypts data at rest in Oracle databases.
  B. It securely manages encryption keys.
  C. It protects against theft or loss of disks and backups.
  D. It prevents OS users from inspecting tablespace files.
  E. It limits the exposure of sensitive data in applications.
  F. It alters data in caches, buffers, and persistent storage.
  G. It impacts operational activities such as backup and restore, upgrade and patch, and replication.
  E. It limits the exposure of sensitive data in applications.

  ---

  Redacting Sensitive Data for Display Data Redaction provides selective, on-the-fly redaction of sensitive data in query results prior to display by applications so that unauthorized users cannot view the sensitive data. It enables consistent redaction of database columns across application modules accessing the same data. Data Redaction minimizes changes to applications because it does not alter actual data in internal database buffers, caches, or storage, and it preserves the original data type and formatting when transformed data is returned to the application. Data Redaction has no impact on database operational activities such as backup and restore, upgrade and patch, and high availability clusters.

  Reference: Oracle Advanced Security, 12c, Oracle Data Sheet

• Question 6:

  Your customer is looking for a solution to address these downtime needs:

  -

  Online addition and removal of disks should automatically rebalance data across new storage configurations while storage, database, and applications remain online.

  -

  Dynamically add or remove clustered nodes without disrupting the database or applications.

  -Automate the sizing and distribution of shared memory.

  - Add a column with a default value without disrupting the database or applications.

  -Perform rolling patch upgrades.

  Which four would you recommend to address those needs?

  A. Automatic Storage Management (ASM)
  B. Online Data and Application change
  C. Global Data Services (GDS)
  D. Real Application Clusters (RAC)
  E. Oracle Streams
  F. Online Table Redefinition
  G. Oracle Database Vault
  A. Automatic Storage Management (ASM)
  C. Global Data Services (GDS)
  D. Real Application Clusters (RAC)
  E. Oracle Streams

• Question 7:

  Which three statements are true about database storage structures?

  A. A data file can span across tablespaces.
  B. An extent contains one or more segments.
  C. Tablespaces contain one or more data files.
  D. Data objects are stored as segments in tablespaces.
  E. Segments can span across data files within a tablespace.
  C. Tablespaces contain one or more data files.
  D. Data objects are stored as segments in tablespaces.
  E. Segments can span across data files within a tablespace.

  ---

  Not B: Segments contain extents.

• Question 8:

  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';
  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;
  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';

  ---

  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 9:

  Examine the command: sqlplus /nolog

  In which scenario would this command execute successfully?

  A. only from the server, if the database instance is not up
  B. from either a client or server, even if the database instance is not up
  C. from either a client or server, only if the database instance is up, and the command connects the session to the instance
  D. from either a client or server, only if the database instance is up, but the command does not connect the session to the instance
  B. from either a client or server, even if the database instance is not up

• Question 10:

  For which database operation do you need the database to be in MOUNT state?

  A. renaming the control files
  B. re-creating the control files
  C. dropping a user in your database
  D. dropping a tablespace in your database
  E. configuring the database instance to operate in ARCHIVELOG or NOARCHIVELOG mode
  E. configuring the database instance to operate in ARCHIVELOG or NOARCHIVELOG mode

  ---

  To enable or disable archiving, the database must be mounted but not open.

  Note: See step 5 below.

  Changing the Database Archiving Mode

  To change the archiving mode of the database, use the ALTER DATABASE statement with the ARCHIVELOG or NOARCHIVELOG clause. To change the archiving mode, you must be connected to the database with administrator privileges

  (AS SYSDBA).

  The following steps switch the database archiving mode from NOARCHIVELOG to ARCHIVELOG:

  1.Shut down the database instance

  2.Back up the database.

  3.Edit the initialization parameter file to include the initialization parameters that specify the destinations for the archived redo log files

  4.Start a new instance and mount, but do not open, the database.

  STARTUP MOUNT

  To enable or disable archiving, the database must be mounted but not open.

  5.Change the database archiving mode. Then open the database for normal operations.

  ALTER DATABASE ARCHIVELOG;

  ALTER DATABASE OPEN;

  6.Shut down the database.

  SHUTDOWN IMMEDIATE

  7.Back up the database.