Oracle 1Z0-497 Online Practice Questions and Exam Preparation

Oracle 1Z0-497 Online Questions & Answers

• Question 21:

  Examine the error:

  GSM-45054: GSM error or NET-40006: unable to start GSH What is the cause of this error, and what troubleshooting steps should you perform?

  A. The GDS catalog database of its listener may be down. Verify that the GDS catalog database and its local listener are running.
  B. The GDS pool database may be down. Make sure that the GDS pool databases are up and the service is enabled and started.
  C. The GDS pool database's local listener may be down. Make sure that it is running.
  D. The global service may be down. Verify that the pool databases are up and the service is started.
  E. The global service may be disabled. Make sure that the pool databases are up and the service is enabled and started.
  E. The global service may be disabled. Make sure that the pool databases are up and the service is enabled and started.

• Question 22:

  Which statement is true about Enhanced Real-Time ADDM in Oracle Database 12c?

  A. The analyzed result is lost when the database instance is restarted.
  B. It runs every 1 hour automatically.
  C. It is shipped only with Oracle Enterprise Manager 12c.
  D. It analyzes high CPU trend and identifies problems before they can threaten application performance.
  D. It analyzes high CPU trend and identifies problems before they can threaten application performance.

• Question 23:

  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
  B. partial redaction

• Question 24:

  Which three statements represent the benefits of multitenant architecture for database consolidation?

  A. You can unplug a PDB from a development CDB and plug it into a production CDB, which allows for easier and more rapid movement of data and code.
  B. You can consolidate shared database memory by combining multiple PDBs in a single CDB.
  C. Patching individual PDBs requires the same amount of time as patching individual databases.
  D. Consolidating separate databases into a single CDB requires the same amount of storage allocation.
  E. In multitenant architecture, a PDB behaves the same as a non-CDB as seen from a client connecting with Oracle Net. No client modification is required.
  A. You can unplug a PDB from a development CDB and plug it into a production CDB, which allows for easier and more rapid movement of data and code.
  D. Consolidating separate databases into a single CDB requires the same amount of storage allocation.
  E. In multitenant architecture, a PDB behaves the same as a non-CDB as seen from a client connecting with Oracle Net. No client modification is required.

  ---

  A: By design, you can quickly plug a PDB into a CDB, unplug the PDB from the CDB, and then plug this PDB into a different CDB. The implementation technique for plugging and unplugging is similar to the transportable tablespace technique.

  D: The process of consolidating data from multiple databases into one database on one computer is known as database consolidation. Starting in Oracle Database 12c, the Oracle Multitenant option enables you to consolidate data and code without altering existing schemas or applications.

  By consolidating hardware and sharing database memory and files, you reduce costs for hardware, storage, availability, and labor. For example, 100 PDBs on a single server share one database instance and one set of database files, thereby requiring less hardware and fewer personnel.

  E: A PDB is a portable collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a non-CDB. All Oracle databases before Oracle Database 12c were non-CDBs. Reference: Benefits of the Multitenant Architecture for Database Consolidation URL: http://docs.oracle.com/cd/E16655_01/server.121/e17633/cdbovrvw.htm#CNCPT89239

• Question 25:

  Which statement about Storage Snapshot Optimization is correct?

  A. It enables you to use third-party technologies to take a storage snapshot of your database without putting the database in BACKUP mode. You can then use the snapshot to recover all or part of the database.
  B. It enables you to use RMAN to take a storage snapshot of your database. The database must be in BACKUP mode. You can then use the snapshot to recover all or part of the database.
  C. It enables you to use RMAN to take a storage snapshot of your database. The database doesn't have to be in BACKUP mode. You can then use the snapshot to recover all or part of the database.
  D. It enables you to use third-party technologies to take a storage snapshot of your database. The database must be in BACKUP mode. You can then use the snapshot to recover all or part of the database.
  A. It enables you to use third-party technologies to take a storage snapshot of your database without putting the database in BACKUP mode. You can then use the snapshot to recover all or part of the database.

  ---

  Reference:

  http://docs.oracle.com/cd/E16655_01/backup.121/e17630/release_changes.htm#BRADV276 (new features, third bullet)

• Question 26:

  Which three statements are true about System Global Area (SGA)?

  A. SGA contains shared memory structures for all Oracle processes running on a single server.
  B. Each server process has its own SGA.
  C. SGA is allocated automatically when a database is started.
  D. SGA is used to speed up queries by caching data blocks, program data, information about database objects, and query results
  E. SGA is allocated automatically when a database is mounted.
  F. SGA is read and written by server and background processes.
  C. SGA is allocated automatically when a database is started.
  D. SGA is used to speed up queries by caching data blocks, program data, information about database objects, and query results
  F. SGA is read and written by server and background processes.

• Question 27:

  After a ___________ statement is issued, a transaction ends. (select three)

  A. COMMIT
  B. ROLLBACK
  C. SAVEPOINT
  D. SELECT
  E. CREATE
  A. COMMIT
  B. ROLLBACK
  E. CREATE

  ---

  A transaction ends when any of the following actions occurs:

  *

  (AB) A user issues a COMMIT or ROLLBACK statement without a SAVEPOINT clause.

  *

  (E) A user runs a DDL command such as CREATE, DROP, RENAME, or ALTER.

  Etc.

  Reference: Oracle Database Concepts, 12c, End of a Transaction

• Question 28:

  Examine the commands:

  SQL> CONNECT sys@CDBl AS SYSDBA

  $QL>STARTUP MOUNT

  SQL> ALTER DATABASE cdbl MOUNT;

  Which four options represent what happens when these commands are executed?

  A. The instance is started.
  B. The CDB control files are opened for the instance.
  C. The root is mounted.
  D. The root is opened.
  E. The PDBs are mounted.
  F. The PDBs are mounted, and the seed is opened in READ ONLY mode.
  G. The PDBs are mounted, and opened in READ WRITE mode, while the seed is opened In READ ONLY mode.
  A. The instance is started.
  B. The CDB control files are opened for the instance.
  C. The root is mounted.
  F. The PDBs are mounted, and the seed is opened in READ ONLY mode.

• Question 29:

  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.
  D. They are not allowed to perform any operations till the listener is started.

  ---

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

  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.
  B. It uses the PREPROCESSOR feature, which allows users to preprocess input data before it is sent to the access drivers.

  ---

  *

  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.