Oracle Oracle Certifications 1Z0-062 Questions & Answers

• Question 111:

  Which three statements are true about Enterprise Manager Database Express? (Choose three.)

  A. It can be used to perform database backup operations.

  B. It can use the HTTP protocol.

  C. The same port number is used for multiple Database Express configurations on the same host.

  D. It can use the HTTPS protocol.

  E. It is available only when the database is open.

  Correct Answer: BDE

• Question 112:

  When does a database checkpoint occur?

  A. When there is an online redo log switch.

  B. When a user session terminates abnormally.

  C. When a server process terminates abnormally.

  D. When the SHUTDOWN ABORT command is issued.

  Correct Answer: A

• Question 113:

  What action must you take to ensure complete database recovery till the point of failure?

  A. Multiplex the control files

  B. Duplex the RMAN backup sets.

  C. Multiplex the online redo log files.

  D. Configure the database to run in ARCHIVELOG mode.

  Correct Answer: D

• Question 114:

  Examine the parameters:

  Your database instance is started with a PFILE.

  

  You want to increase the size of the buffer cache. Free memory is available to increase the size of the

  buffer cache.

  You execute the command:

  SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;

  Which is the outcome?

  A. Change is applied to the current instance, but does not persist after instance restart.

  B. The value is changed only in the PFILE and takes effect at the next instance startup.

  C. The value is changed for the current instance and in the PFILE.

  D. It fails because the SCOPE clause is missing.

  Correct Answer: A

• Question 115:

  In your database, the RESOURCE_LIMIT parameter is set to TRUE. You create the profile:

  

  Which two statements are true about users and their sessions that are subject to this profile? (Choose two.)

  A. The CPU_PER_CALL is ignored in the user sessions because of the unlimited value of CPU_PER_CALL

  B. These users can never reuse a password

  C. The PASSWORD_LIFE_TIME value is ignored because of the unlimited value of PASSWORD_REUSE_MAX.

  D. In each user session, the limit for LOGICAL_READS_PER_SESSION in the same as defined in the DEFAULT profile.

  Correct Answer: CD

• Question 116:

  Examine the command:

  SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE;

  Which two statements are true in this scenario? (Choose two.)

  A. All data definition language (DDL) commands are logged in to the alert log file.

  B. All DDL commands are logged in to a text file in Automatic Diagnostic Repository (ADR) home.

  C. A subset of executed DDL statements is written into an XML file in ADR home.

  D. A subset of executed DDL statements is written to the DDL log in ADR home.

  E. All DDL commands are logged in to a trace file in ADR home.

  Correct Answer: CD

• Question 117:

  What is the outcome of the SHUTDOWN ABORT command?

  A. Pending transactions are committed and the database is closed.

  B. Dirty buffers in the buffer cache and unwritten redo are not written to the data files and redo log files respectively.

  C. Uncommitted transactions are rolled back

  D. Instance recovery must be requested by the DBA at the next startup

  Correct Answer: B

• Question 118:

  Which statement is true about the loss of a data file belonging to the default undo tablespace?

  A. The database remains open in read-only mode.

  B. The database is put in MOUNT state and requires recovery to be opened.

  C. The database remains open for querying but no DML statements can be executed except by the users with SYSDBA privilege.

  D. All the noncommitted transactions are lost.

  E. The database instance aborts.

  Correct Answer: C

• Question 119:

  Examine the following steps:

  A DBA grants the CREATE TABLE system privilege with ADMIN OPTION to the user SIDNEY. SIDNEY grants the CREATE TABLE system privilege to the HR user.

  Which statement is true?

  A. SIDNEY can revoke the CREATE TABLE system privilege only from HR, to whom he granted it.

  B. HR can grant the CREATE TABLE system privilege to other users.

  C. Neither SIDNEY nor HR can create new tables if the DBA revokes the CREATE TABLE privilege from SIDNEY.

  D. HR still retains the CREATE TABLE system privilege if the DBA revokes the CREATE TABLE privilege from SIDNEY.

  Correct Answer: C

  References: http://www.dba-oracle.com/t_with_grant_admin_privileges.htm

• Question 120:

  What is a pre-requisite to alter a role?

  A. You should be granted the DBA role.

  B. You should set the OS_ROLES parameter to true.

  C. You should be granted the role with the GRANT OPTION.

  D. You should have the ALTER ANY ROLE system privilege.

  Correct Answer: D