Oracle Oracle Partner Network 1Z0-497 Questions & Answers

• Question 141:

  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.

  Correct Answer: CD

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

  Which two statements about the Process Monitor (PMON) process are true?

  A. PMON performs process recovery when a client process fails.

  B. During instance startup, PMON takes care of instance recovery.

  C. PMON performs listener registration.

  D. PMON restarts background and dispatcher processes when they fail.

  E. PMON resolves failures of distributed transactions.

  Correct Answer: AC

• Question 143:

  Which statement is true about loading data by using the conventional path of SQL*Loader?

  A. Redo is not generated while performing conventional path loads.

  B. Only PRIMARY KEY, UNIQUE KEY, and NOT NULL constraints are checked,

  C. No exclusive locks are acquired when the conventional path loads are performed.

  D. Instead of performing transactions, SQL*Loader directly writes data blocks to the data files.

  E. INSERT triggers are disabled before the conventional path load and re-enabled at the end of the load.

  Correct Answer: B

  Reference: http://docs.oracle.com/cd/A57673_01/DOC/server/doc/SUT73/ch8.htm#data %20paths (see direct loads, integrity constraints, and triggers)

• Question 144:

  Identify three key properties of a transaction in Oracle Database 12c.

  A. durability

  B. consistency

  C. concurrency

  D. isolation

  E. scalability

  F. manageability

  Correct Answer: ABD

  Reference: http://docs.oracle.com/cd/E16655_01/server.121/e17633/transact.htm#CNCPT016

• Question 145:

  Which two statements are true regarding SQL*Plus?

  A. It has commands for performing database administration operations.

  B. It can be used in interactive but not batch mode for SQL commands.

  C. It has to be installed separately after the Oracle Database 12c installation.

  D. Operating system commands can be executed from the SQL*Plus command prompt.

  Correct Answer: AC

  C: how to start SQL*Plus:

  1- Make sure that SQL*Plus has been installed on your computer.

  2.

  Log on to the operating system (if required).

  3.

  Enter the command, SQLPLUS, and press Return.

  Etc.

  Not B: In SQL*Plus command-line, the use of an external editor in combination with the @, @@ or START commands is an effective method of creating and executing generic scripts. You can write scripts which contain SQL*Plus, SQL and PL/SQL commands, which you can retrieve and edit. This is especially useful for storing complex commands or frequently used reports.

  Reference: http://docs.oracle.com/cd/B14117_01/server.101/b12170/qstart.htm

• Question 146:

  Which targets can be managed by using Enterprise Manager Cloud Control?

  A. Hosts and databases

  B. Hosts, databases, and application servers

  C. Application servers and web applications

  D. Databases, Oracle Management Server (OMS), and Oracle Management Repository (OMR)

  E. Databases, application servers, and web applications

  F. Hosts, databases, application servers, web applications, OMS, and OMR

  Correct Answer: A

  Reference: http://www.oracle.com/technetwork/oem/framework-infra/wp-em12c-security-best- practicesv21493383.pdf (page 3, second bulleted point, last couple of sentences)

• Question 147:

  Which two statements are true about shared server sessions?

  A. No Program Global Area (PGA) is allocated for shared server processes.

  B. User Global Area is stored in System Global Area (SGA).

  C. Shared SQL Area is allocated from Program Global Area (PGA).

  D. Private SQL Area is allocated from Library Cache.

  E. Large Pool is used for SQL work areas.

  Correct Answer: AD

  A: The PGA is memory specific to an operating process or thread that is not shared by other processes or threads on the system. Because the PGA is process-specific, it is never allocated in the SGA.

  The PGA is a memory heap that contains session-dependent variables required by a dedicated or shared server process. The server process allocates memory structures that it requires in the PGA.

  D: The library cache is a shared pool memory structure that stores executable SQL and PL/SQL code. This cache contains the shared SQL and PL/SQL areas and control structures such as locks and library cache handles. In a shared server architecture, the library cache also contains private SQL areas.

  Incorrect:

  Not B: The SGA is a read/write memory area that, along with the Oracle background processes, form a

  database instance. All server processes that execute on behalf of users can read information in the instance SGA. Several processes write to the SGA during database operation. not C: A private SQL area (PGA) holds information about a parsed SQL statement and other session-specific information for processing. When a server process executes SQL or PL/SQL code, the process uses the private SQL area to store bind variable values, query execution state information, and query execution work areas.

  Reference: Oracle Database Concepts, 12c, Memory Architecture

• Question 148:

  Exhibit below:

  

  Which three statements are true about terminating a session?

  A. Without any error, you can terminate the active session by executing: SQL> ALTER SYSTEM KILL SESSION '7, 15';

  B. You can terminate the active session by executing: SQL> ALTER SYSTEM KILL SESSION "7, 15'; But you also get the error message: ORA-00028: your session has been killed C. You cannot terminate the active session. You have to wait until that session becomes inactive.

  D. Without any error, you can terminate the inactive session by executing: SQL> ALTER SYSTEM KILL SESSION '12, 63';

  E. When an inactive session is killed, the status of that session remains visible in VSSESSION with status KILLED. The rowf the terminated session is removed from VSSESSION after the user attempts to use the session again.

  F. You cannot terminate the inactive session. You have to wait until that session becomes active again.

  Correct Answer: BDE

  B (not A, Not C):

  * You terminate a current session using the SQL statement ALTER SYSTEM KILL SESSION. The following statement terminates the session whose system identifier is 7 and serial number is

  15:

  * Terminating an Active Session If a user session is processing a transaction (ACTIVE status) when you terminate the session, the transaction is rolled back and the user immediately receives the following message:

  ORA-00028: your session has been killed

  ALTER SYSTEM KILL SESSION '7,15';

  E (not F): Terminating an Inactive Session

  If the session is not making a SQL call to Oracle Database (is INACTIVE) when it is terminated, the ORA00028 message is not returned immediately. The message is not returned until the user subsequently attempts to use the terminated session.

  When an inactive session has been terminated, the STATUS of the session in the V$SESSION view is KILLED. The row for the terminated session is removed from V$SESSION after the user attempts to use the session again and receives the ORA-00028 message.

  Reference: Oracle Database Administrator's Guide, Terminating Sessions URL: http://docs.oracle.com/cd/ B28359_01/server.111/b28310/manproc008.htm#ADMIN11192

• Question 149:

  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.

  Correct Answer: A

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

• Question 150:

  As part of your Oracle Database 12c post-installation tasks, you run these commands:

  Cd $ORACLE_HOME/bin srvctl stop database -d myDb chopt enable dm srvctl start database -d myDb

  What does this do?

  A. It enables the Oracle Data Mining option in your Oracle binary files.

  B. It creates the Fast Recovery Area disk group.

  C. It generates Client Static Library.

  D. It configures one of the Oracle user accounts.

  E. It configures Oracle Net Services.

  F. It configures Oracle Messaging Gateway.

  Correct Answer: A

  Reference: http://docs.oracle.com/cd/E16655_01/install.121/e17889/postinst.htm#RILIN1049 (see 4.4)