Oracle Oracle Certifications 1Z0-062 Questions & Answers

• Question 221:

  Your database is configured in ARCHIVELOG mode.

  Examine the RMAN configuration parameters:

  

  Examine the command:

  RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

  What is the outcome?

  A. It fails because the DELETE INPUT option can be used only with the BACKUP AS BACKUPSET command.

  B. It executes successfully and creates a backup set of the database along with archived log files and then deletes the original archived log files.

  C. It executes successfully and creates an image copy of the database along with archive log files and then deletes the original archived log files.

  D. It fails because the DELETE INPUT option can be used only with the BACKUP AS COPY command.

  Correct Answer: B

  References: https://docs.oracle.com/cd/B13789_01/server.101/b10734/rcmbackp.htm

• Question 222:

  Your production database uses file system storage. You want to move storage to Oracle Automatic Storage Management (ASM).

  How would you achieve this?

  A. by using a transportable database

  B. by using the Database Upgrade Assistant (DBUA)

  C. by using Data Pump

  D. by using RMAN

  Correct Answer: D

  References: http://docs.oracle.com/cd/E11882_01/server.112/e18951.pdf (p.184)

• Question 223:

  The HR user executes the following query on the EMPLOYEES table but does not issue COMMIT, ROLLBACK, or any data definition language (DDL) command after that:

  

  HR then opens a second session.

  Which two operations wait when executed in HR's second session? (Choose two.)

  A. LOCK TABLE employees IN EXCLUSIVE MODE;

  B. INSERT INTO employees(empno,ename) VALUES (1289, `Dick');

  C. SELECT job FROM employees WHERE job='CLERK' FOR UPDATE OF empno;

  D. SELECT empno,ename FROM employees WHERE job='CLERK';

  E. INSERT INTO employees(empno,ename,job) VALUES (2001,'Harry','CLERK);

  Correct Answer: AC

• Question 224:

  In your Oracle 12c database, you plan to execute the command:

  SQL> CREATE TABLESPACE tbs1 DATAFILE `/u02/oracle/data/tbs01.dbf' SIZE 50M;

  The u02 file system has 1 GB of free space available.

  What is the outcome?

  A. It creates a locally managed tablespace with manual segment space management enabled.

  B. It raises an error because extent management is not specified.

  C. It creates a locally managed tablespace with automatic segment space management enabled.

  D. It creates a dictionary-managed tablespace with manual segment space management enabled.

  Correct Answer: C

  References: https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces002.htm#ADMIN11359

• Question 225:

  Examine the parameters for a database instance: Your database has three undo tablespaces and the default undo tablespace is not autoextensible. Resumable space allocation is not enabled for any sessions in the database instance.

  

  What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transactions?

  A. Transactions write their undo in the SYSTEM undo segment.

  B. Transactions fail.

  C. Transactions wait until space becomes available in UNDOTBS1.

  D. Transactions write their undo in a temporary tablespace.

  Correct Answer: B

  References: https://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm (undo retention)

• Question 226:

  The DEFERRED_SEGMENT_CREATION parameter is set to TRUE in your database instance. You execute the following command to create a table:

  

  Which two statements are true? (Choose two.)

  A. The table is created without a segment because the storage clause is missing.

  B. A segment is allocated when the first row is inserted in the table.

  C. A segment is allocated when an index is created for any column in the table.

  D. The table is created and extents are immediately allocated as per the default storage defined for its tablespace.

  E. A segment is allocated for the table if the ALTER TABLE... ALLOCATE EXTENT command is issued.

  Correct Answer: BE

• Question 227:

  Which three statements are true about automated maintenance tasks? (Choose three.)

  A. They run at predefined time intervals that are intended to occur during a period of low system load.

  B. An Oracle Scheduler job is created for each maintenance task that is scheduled to run in a maintenance window.

  C. A maintenance window is automatically extended until all the maintenance tasks defined are completed.

  D. A repository is maintained in the SYSTEM tablespace to store the history of execution of all tasks.

  E. Predefined maintenance tasks consist of automatic optimizer statistics collection, running Automatic Segment Advisor, and running Automatic SQL Tuning Advisor.

  Correct Answer: ABE

  References: https://docs.oracle.com/cd/E11882_01/server.112/e25494/tasks.htm#ADMIN12331

• Question 228:

  You want to reduce fragmentation and reclaim unused space for the SALES table but not its dependent objects. During this operation, you want to ensure the following:

  -Long-running queries are not affected.

  -No extra space is used.

  -Data manipulation language (DML) operations on the table succeed at all times throughout the process.

  -Unused space is reclaimed both above and below the high water mark.

  Which ALTER TABLE option would you recommend?

  A. DEALLOCATE UNUSED

  B. SHRINK SPACE CASCADE

  C. SHRINK SPACE COMPACT

  D. ROW STORE COMPRESS BASIC

  Correct Answer: C

  References: https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema003.htm

• Question 229:

  Examine the parameters for a database instance:

  

  Which two statements are true? (Choose two.)

  A. Undo records for temporary tables are stored in a temporary tablespace.

  B. Undo records for temporary tables are stored in the undo tablespace and logged in the redo.

  C. Undo records for temporary tables are stored in the undo tablespace and logged in the redo only for those sessions where temporary undo is enabled.

  D. No redo is generated for the undo records belonging to temporary tables.

  E. No redo and undo records are generated for temporary tables.

  Correct Answer: AE

• Question 230:

  What should you do to ensure that a job stores minimal job metadata and runtime data on disk, and uses only existing PL/SQL programs?

  A. Create an event-based job.

  B. Create a lightweight job.

  C. Specify the job as a member of a job class.

  D. Use a job array.

  Correct Answer: B

  References: https://docs.oracle.com/cd/B28359_01/server.111/b28310/schedover004.htm#BGBJGHBH