Oracle Oracle Certifications 1Z0-062 Questions & Answers

• Question 101:

  What must you use to read data from a table in your database and write it to an external table?

  A. Use SQL* LOADER conventional path load.

  B. Use SQL* LOADER direct path load.

  C. Use CREATE TABLE. . ORGANIZATION EXTERNAL command with ORACLE_LOADER access driver.

  D. Use CREATE TABLE. . ORGANIZATION EXTERNAL command with ORACLE_DATAPUMP access driver.

  Correct Answer: D

• Question 102:

  Which three statements are true about user account administration? (Choose three.)

  A. A user's current session is not affected when the user's profile is changed.

  B. Only users with the SYSDBA privilege can change the tablespace quota for other users.

  C. A new user account can be created only by SYS or SYSTEM users.

  D. A user's quota can be set for any permanent tablespace but not for the default temporary tablespace.

  E. A user requires only the CREATE SESSION privilege to change his or her own password.

  Correct Answer: ADE

• Question 103:

  Which two statements are true about initialization parameter files? (Choose two.)

  A. A lost or damaged SPFILE can be re-created by using the parameter values listed in the alert log.

  B. A PFILE must exist for an SPFILE to be created.

  C. The ALTER SYSTEM command cannot be used to change the value of any parameter if a database instance has started using a PFILE.

  D. Both the SPFILE and PFILE must always reside on a file system accessible from the database host server.

  E. On startup, by default a database instance always first searches for an SPFILE, and if it does not find any, searches for a PFILE.

  Correct Answer: BE

• Question 104:

  You want to create a table, DAILY_ORDERS, for an OLTP application, where data should be compressed during both direct-path INSERT and conventional DML. The table will also be used for queries.

  Which compression option should be used?

  A. ROW STORE COMPRESS

  B. COLUMN STORE COMPRESS FOR QUERY

  C. COLUMN STORE COMPRESS FOR ARCHIVE LOW

  D. ROW STORE COMPRESS ADVANCED

  Correct Answer: D

• Question 105:

  An application repeatedly accesses small lookup tables, causing a lot of physical I/O operations.

  What do you recommend to minimize this?

  A. Configure the nonstandard buffer cache with a buffer size greater than the size of the default buffer cache.

  B. Increase the size of the shared pool

  C. Configure the KEEP buffer cache and alter the tables to use the KEEP cache.

  D. Configure the RECYCLE buffer cache and alter the tables to use the RECYCLE cache.

  Correct Answer: C

• Question 106:

  Examine the command:

  

  Which statement is true?

  A. The data file, TEST01.DBF, can be auto extended to a maximum size of 5M.

  B. The tablespace, TEST1, can contain a maximum of one data file.

  C. Allocated and free extents are tracked using bitmaps.

  D. Segment free space is tracked in the data dictionary.

  Correct Answer: C

• Question 107:

  Your database is open in read/write mode and multiple users are connected to the database instance.

  You execute the following command:

  SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;

  What would be the effect on current sessions?

  A. They are not terminated but may only issue queries.

  B. They are not affected.

  C. They are terminated immediately.

  D. They are terminated after completing the transaction.

  Correct Answer: B

• Question 108:

  You want to distribute a set of structured data to your customers who can integrate this data into their existing databases irrespective of the platform.

  Which method provides the fastest way of achieving this?

  A. using the DBVERIFY utility

  B. using direct-path INSERT SQL statements

  C. using SQL*Loader

  D. using RMAN transportable tablespace operation

  Correct Answer: D

• Question 109:

  Which component resides in the System Global Area (SGA) of a database instance only in shared server connections?

  A. User Global Area

  B. Program Global Area

  C. SQL Query Result Cache

  D. PL/SQL Function Result Cache

  Correct Answer: A

• Question 110:

  Identify three situations in which messages are written to the alert log file. (Choose three.)

  A. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an error "ORA-01578: ORACLE data block corrupted (file # 14, block # 50)"

  B. Creating a table returns "ORA-00955: name is already in used by an existing object"

  C. Inserting a value into a table returns "ORA-01722: invalid number"

  D. Updating a record in a table returns "ORA-00060: deadlock detected while waiting for resource"

  E. Inserting a value into a table returns "ORA-00001: unique constraint (SYS.PK_XXXX) violated"

  F. Running a query on a table returns "ORA-01578: ORACLE data block corrupted (file # 4, block # 131)"

  Correct Answer: ADF