Oracle Oracle Certifications 1Z0-497 Questions & Answers

• Question 121:

  A DBA informs you that an Oracle instance has started. What does this imply?

  A. Users can access the data in the database.

  B. Only SGA has been allocated for the database.

  C. Only background and user processes are running.

  D. Memory areas have been allocated and background processes have been started.

  Correct Answer: D

• Question 122:

  Real-Time ADDM detects a high-load performance issue within the database. Which condition triggered it?

  A. The average active sessions were more than three times the number of CPU cores.

  B. Active sessions were more than 10% of total load and CPU utilization was more than 50%.

  C. Memory allocations were more than 95% of physical memory.

  D. Hung sessions were more than 10% of total sessions.

  E. A deadlock was detected.

  F. The session limit was close to 100%.

  Correct Answer: A

  Reference: http://docs.oracle.com/cd/E16655_01/server.121/e15857/pfgrf_diag.htm#TGDBA95369 (table 7-1)

• Question 123:

  Which three operations can the PUBLIC user with the SYSOPER privilege perform?

  A. STARTUP

  B. SHUTDOWN

  C. CREATE DATABASE

  D. DROP DATABASE

  E. ALTER DATABASE RECOVER

  Correct Answer: ABE

  Reference: http://docs.oracle.com/cd/B28359_01/server.111/b28310/dba006.htm#ADMIN11049

• Question 124:

  To revoke unnecessary and unused privileges, you can use Privilege Analysis. Which sequence should

  you follow?

  1 -Start the analysis.

  2 - Set up the analysis policy type (database, role, context).

  3 - Generate the results.

  4 -View the results in DBA_USED_PRIVSand DBA_UNUSED_PRJVS.

  5 - Stop the analysis.

  A. 1, 2, 3, 4, 5

  B. 2, 1, 5, 3, 4

  C. 5, 1, 2, 3, 4

  D. 2, 3, I, 5, 4

  E. 1, 2, 4, 5, 2

  Correct Answer: A

• Question 125:

  Which command do you use to create a local role while you are connected as the local user?

  A. create local role l_hr;

  B. create role c##_hr container=current;

  C. create role l_hr container=current;

  D. create role l_hr container=all;

  Correct Answer: C

  You can include CONTAINER=CURRENT in the CREATE ROLE statement to specify the role as a local role.

  Reference: Oracle Database Security Guide , Creating a Local Role

• Question 126:

  YOU want to move all objects of the CONSULTANT user from the test database to theDB- USER schema of the production database. Which option of IMPDP would you use to accomplish this task?

  A. FULL

  B. SCHEMAS

  C. TRANSFORM

  D. REMAP_SCHEMA

  E. REMAP_TABLESPACE

  Correct Answer: D

• Question 127:

  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

  Correct Answer: E

  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.

• Question 128:

  Which three components are always part of System Global Area?

  A. Database Buffer Cache

  B. Undo Log Buffer

  C. Shared Pool

  D. Small Pool

  E. Java Pool

  F. Private SQL Area

  Correct Answer: ACE

  Reference: http://docs.oracle.com/cd/E11882_01/server.112/e40540/memory.htm#CNCPT802

• Question 129:

  Which two statements about Database Express are true?

  A. It uses internal infrastructure components, such as XDB and SQL*Net.

  B. It can perform actions outside the database.

  C. It has background tasks and processes that periodically collect information via FTP.

  D. It has two new features: Performance Hub and Composite Active Reports.

  E. It is not supported on Standard Edition (SE) and Express Edition (XE).

  Correct Answer: AD

  Reference: http://www.oracle.com/technetwork/database/manageability/emx-intro-1970113.html

• Question 130:

  Which is the default port number for Database Express?

  A. 7801

  B. 5500

  C. 2243

  D. 1521

  E. 22

  Correct Answer: D

  Reference: http://docs.oracle.com/cd/B25329_01/doc/install.102/b25143.pdf (page 4, first bulleted point)