Oracle Oracle Certifications 1Z0-062 Questions & Answers

• Question 211:

  Your database instance is started by using a server parameter file (SPFILE). You execute the following command to change the value of the LOG_BUFFER initialization parameter:

  ALTER SYSTEM SET LOG_BUFFER=32 M;

  What is the outcome of this command?

  A. The parameter value is changed and it comes into effect as soon as space becomes available in the SGA.

  B. It returns an error because the value of this parameter cannot be changed dynamically.

  C. The parameter value is changed and it comes into effect at the next instance startup.

  D. It returns an error because SCOPE should be set to MEMORY.

  Correct Answer: B

• Question 212:

  You want to create a database and you have the following:

  -

  Oracle Grid Infrastructure is installed and configured.

  -

  Oracle Database Vault is installed in ORACLE_HOME to be used for this database.

  -

  Oracle Enterprise Manager Cloud Control is available and an agent is deployed on the database server.

  Examine the requirements:

  1.

  configuring the database instance to support shared server mode

  2.

  using Automatic Storage Management (ASM) for storing database files.

  3.

  configuring a naming method to help a remote user connect to a database instance

  4.

  configuring the Fast Recovery Area

  5.

  configuring Database Vault

  6.

  configuring Enterprise Manager (EM) Database Express

  7.

  registering with EM Cloud Control

  8.

  configuring remote log archive destinations

  9.

  enabling daily incremental backups

  10.

  configuring a nondefault block size for nondefault block size tablespaces

  Which of these requirements can be met while creating a database by using the Database Configuration Assistant (DBCA)?

  A. 1, 2, 4, 5, 7, 8, 9 and 10

  B. 1, 2, 4, 5, 6 and 7

  C. 1, 2, 3, 8, 9 and 10

  D. 1, 2, 3, 4, 6, 8, 9 and 10

  E. 1, 2, 4, 5, 6, 7 and 8

  Correct Answer: D

• Question 213:

  You want execution of large database operations to suspend, and then resume, in the event of space allocation failures.

  You set the value of the initialization parameter RESUMABLE_TIMEOUT to 3600.

  Which two statements are true? (Choose two.)

  A. Before a statement executes in resumable mode, the ALTER SESSION ENABLE RESUMABLE statement must be issued in its session.

  B. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.

  C. A resumable statement can be suspended and resumed only once during execution.

  D. A suspended statement will report an error if no corrective action has taken place during a timeout period.

  E. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.

  Correct Answer: AD

• Question 214:

  In your database, USERS is the default permanent tablespace. Examine the commands and their outcome:

  

  You plan to execute the commands:

  

  Which two statements are true? (Choose two.)

  A. The MYTAB table is created in the SYSTEM tablespace but no rows can be inserted into the table by USER02.

  B. The MYTAB table is created in the SYSTEM tablespace and rows can be inserted into the table by USER02.

  C. The MYTAB table is created in the USERS tablespace but no rows can be inserted into the table by USER02.

  D. The CREATE TABLE statement generates an error because the SYSDBA privilege does not provide any space quota on the SYSTEM tablespace by default.

  E. The MYTAB table is owned by the SYS user.

  Correct Answer: BE

• Question 215:

  You use multiple temporary tables frequently in your database. Which two are benefits of configuring temporary undo? (Choose two.)

  A. Performance improves because less redo is written to the redo log.

  B. Temporary undo reduces the amount of undo stored in undo tablespaces.

  C. Performance improves because data manipulation language (DML) operations performed on temporary tables do not use the buffer cache.

  D. Performance improves because no redo and undo are generated for the temporary tables.

  Correct Answer: AB

• Question 216:

  Which three statements are true about the Pre-Upgrade Information Tool? (Choose three.)

  A. It generates a script to recompile invalid objects post-upgrade.

  B. The preupgrade_fixups.sql script is created to list and describe issues in the source database.

  C. A log file, preupgrade.log, is created that contains the output of the Pre-Upgrade Information tool.

  D. It checks for required tablespaces and if they are not available, creates them automatically.

  E. The preupgrade_fixups.sql script is executed automatically to fix issues in the source database.

  F. The postupgrade_fixups.sql script is created to address issues that can be fixed after a database has been upgraded.

  Correct Answer: ACE

  References: https://docs.oracle.com/database/122/UPGRD/using-preupgrade-information-tool-for-oracledatabase.htm#UPGRD-GUID-C0219AF1-AD43-4097-B358-E53E48958647

• Question 217:

  Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?

  A. execution of SQL statements by users connected with the SYSDBA privilege

  B. creation of a fine-grained audit policy

  C. configuration of unified auditing mode

  D. usage of the AUDIT statement

  Correct Answer: A

  References: https://docs.oracle.com/cd/B28359_01/network.111/b28531/auditing.htm#DBSEG0622

• Question 218:

  You want to create a role that:

  -is protected from unauthorized usage

  -does not use a password embedded in the application source code or stored in a table

  -is enabled for a user based on security policies defined in a PL/SQL package

  How would you create this role?

  A. as a secure application role

  B. with definer's rights

  C. with global authentication

  D. with external authentication

  Correct Answer: A

  References: https://docs.oracle.com/cd/B28359_01/network.111/b28531/authorization.htm#DBSEG97973

• Question 219:

  You set the following parameters in the parameter file and restart the database instance: Which two statements are true? (Choose two.)

  

  A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.

  B. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.

  C. The value of the MEMORY_MAX_TARGET parameter remains zero for the database instance.

  D. The lower limits of the PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB respectively.

  E. The instance does not start up because Automatic Memory Management (AMM) is enabled but PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to nonzero values.

  Correct Answer: AD

• Question 220:

  Which three statements are true about the purpose of checkpoints? (Choose three.)

  A. They ensure that uncommitted transactions are rolled back in case of an instance failure.

  B. They ensure that all the dirty buffers are written to disk during a normal shutdown.

  C. They ensure that instance recovery starts in the event of an instance failure.

  D. They ensure that dirty buffers in the buffer cache are written to disk regularly.

  E. They reduce the time required for recovery in case of an instance failure.

  Correct Answer: BDE

  References: http://docs.oracle.com/cd/E36909_01/server.1111/e25789/startup.htm#BABGDACG