Oracle 1Z0-497 Online Practice Questions and Exam Preparation

Oracle 1Z0-497 Online Questions & Answers

• Question 81:

  Which two statements are true about transactions in Oracle Database 12c?

  A. Multiple transactions can use the same undo segment.
  B. A transaction is assigned an undo segment when it is started.
  C. Multiple transactions cannot share the same extent in an undo tablespace.
  D. If all the segments in an undo tablespace are used, transactions use system undo segments to store undo data.
  B. A transaction is assigned an undo segment when it is started.

• Question 82:

  Which statement about Oracle patches is false?

  A. Interim patches, also known as "one-off" patches, are created to provide a specific fix between the releases of patch sets.
  B. Security Patch Update (SPU) is the primary means of releasing security fixes for Oracle products. SPUs are cumulative with respect to prior SPUs and generally contain only security fixes.
  C. Patch Set Update (PSU) is a collection of proactive, stabilizing, cumulative patches for a particular product version (base release or patch set). PSUs are cumulative and include all the security fixes from CPU patches, plus additional fixes.
  D. Patch Set is the main way in which Oracle provides bug fixes in between releases. Oracle bundles a number of fixes, tests them thoroughly together, and packages, then together for easy download and installation.
  E. Terminal Patch Set is an unsupported patch set by Oracle Lifetime Support policies.
  B. Security Patch Update (SPU) is the primary means of releasing security fixes for Oracle products. SPUs are cumulative with respect to prior SPUs and generally contain only security fixes.

  ---

  Starting with Oracle Database version 12.1.0.1, Oracle only provides Patch Set Updates (PSU) to meet the Critical Patch Update (CPU) program requirements for security patching. Security Patch Updates (SPU) will no longer be available.

• Question 83:

  View the current parameter settings shown in the output below.

  NAMETYPEVALUE db_file_multiblock_read_count integer 107 ddl_lock_timeout integer 60 Distributed_lock_timeout integer 60 dml_locks integer 748 lock_sga boolean FALS E enab1e_dd1_1ogging boolean FALS E resumable_timeout integer 0

  A user logs in to the HRschema and issues the following commands:

  SQL> CREATE TABLE emp (empno NUMBER(3), enamo VARCHAR2(20), sal NUMBER (8, 2));

  SQL> INSERT INTO emp (empno, ename) VALUES(1, 'JAMES');

  At this moment, a second user also logs in to the HRschema and issues the following command:

  SQL> ALTER TABLE emp MODIFY salNUMBER(10, 2);

  What happens in this scenario?

  A. The second user's session immediately produces a "resource busy" error.
  B. The second user's command executes successfully.
  C. The second user's session waits for a time before producing a "resource busy" error.
  D. A deadlock is created.
  A. The second user's session immediately produces a "resource busy" error.

• Question 84:

  Which two statements about ADDM are true?

  A. Real-Time ADDM uses AWR snapshots of the last 10 minutes.
  B. Real-Time ADDM uses ASH recent activity from SGA data.
  C. Real-Time ADDM analyzes performance in a completely different fashion than regular ADDM.
  D. Regular ADDM uses AWR snapshots that are not yet purged.
  C. Real-Time ADDM analyzes performance in a completely different fashion than regular ADDM.
  D. Regular ADDM uses AWR snapshots that are not yet purged.

  ---

  C: Real-Time ADDM provides an innovative way to analyze problems in unresponsive or hung databases.

  Using a normal and a diagnostic mode connection Real-Time ADDM runs through a set of predefined criteria to analyze the current performance and helps the DBA to resolve deadlocks, hangs, shared pool contentions and many other

  exception situations that today forces the administrator to bounce their databases, causing significant loss of revenue. Real-Time ADDM is the only tool available in the market today that can log into a hung database, analyze the problem and

  recommend a resolution.

  Note: Real-Time ADDM is an innovative way to analyze problems in extremely slow or unresponsive databases, which would have traditionally required a database restart. Real-Time ADDM can help resolve issues such as deadlocks, hangs,

  and shared pool contentions, as well as many other exception situations, without resorting to a restart of the database.

  D: ADDM builds upon the data captured in AWR.

• Question 85:

  You want to drop a pluggable database from a multitenant container database that is used for development, which two statements are true?

  A. You can drop the PDB only if it is closed.
  B. You can drop the seed PDB, but you cannot create any other PDB within the CDB.
  C. You can drop the PDB and keep the data files to be reused by another PDB.
  D. When you drop the PDB, the data files and redo log files are automatically removed from the storage file system.
  A. You can drop the PDB only if it is closed.
  D. When you drop the PDB, the data files and redo log files are automatically removed from the storage file system.

• Question 86:

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

  ---

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

  Which two statements about multitenant architecture are true?

  A. It ensures full backward compatibility with non-CDBs.
  B. It fully operates with RAC.
  C. It is integrated with Enterprise Manager, but not with the Resource Manager.
  D. It allows central management and administration of single databases.
  C. It is integrated with Enterprise Manager, but not with the Resource Manager.
  D. It allows central management and administration of single databases.

• Question 88:

  Your customer is looking for zero-data-loss failover with maximum data protection and high availability for their primary database. Which two solutions would you recommend to the customer if the distance between the primary and the standby location is more than 300 miles?

  A. Asynchronous redo transport with Data Guard
  B. Synchronous redo transport with Data Guard
  C. Active Data Guard Far Sync
  D. Data Guard SQL Apply
  B. Synchronous redo transport with Data Guard
  C. Active Data Guard Far Sync

  ---

  B: The synchronous redo transport mode transmits redo data synchronously with respect to transaction commitment. A transaction cannot commit until all redo generated by that transaction has been successfully sent to every enabled redo transport destination that uses the synchronous redo transport mode.

  Note that although there is no limit on the distance between a primary database and a SYNC redo transport destination, transaction commit latency increases as network latency increases between a primary database and a SYNC redo transport destination.

  C: An Oracle Data Guard far sync instance is a remote Oracle Data Guard destination that accepts redo from the primary database and then ships that redo to other members of the Oracle Data Guard configuration. A far sync instance manages a control file, receives redo into standby redo logs (SRLs), and archives those SRLs to local archived redo logs, but that is where the similarity with standbys ends. A far sync instance does not have user data files, cannot be opened for access, cannot run redo apply, and can never function in the primary role or be converted to any type of standby database.

  Far sync instances are part of the Oracle Active Data Guard Far Sync feature, which requires an Oracle Active Data Guard license.

  Reference:

• Question 89:

  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
  A. performs data replication
  B. performs database failovers

• Question 90:

  In this SQL statement, what is the partitioning criteria?

  CREATE TABLE books_part

  PARTITION BY RANGE (cell_id) (

  PARTITION p0l VALUES LESS THAN (2),

  PARTITION p02 VALUES LESS THAN (3) ,

  . . .

  PARTITION pl4 VALUES LESS THAN (15),

  PARTITION pl5 VALUES LESS THAN (16),

  PARTITION pl6 VALUES LESS THAN (MAXVALUE)

  )

  AS SELECT * FROM books;

  A. books
  B. pxx
  C. MAXVALUE
  D. cell_id
  E. There is no partitioning criteria.
  D. cell_id