Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 31:

  Which task would you recommend before using the Database Upgrade Assistant (DBUA) to upgrade a single-instance Oracle 11g R2 database to Oracle Database 12c?

  A. shutting down the database instance that is being upgraded
  B. executing the catctl.pl script to run the upgrade processes in parallel
  C. running the Pre-Upgrade Information Tool
  D. copying the listener.ora file to the new ORACLE_HOME
  C. running the Pre-Upgrade Information Tool

  ---

  References: http://docs.oracle.com/cd/E11882_01/server.112/e23633/upgrade.htm#UPGRD12395

• Question 32:

  Which two tasks can be performed on an external table? (Choose two.)

  A. partitioning the table
  B. creating an invisible index
  C. updating the table by using an update statement
  D. creating a public synonym
  E. creating a view
  D. creating a public synonym
  E. creating a view

  ---

  You can, for example select, join, or sort external table data. You can also create views and synonyms for external tables. However, no DML operations (UPDATE, INSERT, or DELETE) are possible, and no indexes can be created, on external tables.

  http://docs.oracle.com/cd/B28359_01/server.111/b28310/tables013.htm#ADMIN01507

• Question 33:

  Which two are true about the SMON background process? (Choose two.)

  A. It performs instance recovery, if required, at instance startup.
  B. It monitors sessions for idle time out.
  C. It performs process recovery for user process failures.
  D. It deletes orphaned temporary segments in permanent tablespaces.
  E. It monitors the status of dispatchers and server processes.
  B. It monitors sessions for idle time out.
  E. It monitors the status of dispatchers and server processes.

• Question 34:

  You create a locally managed tablespace ORDERS_TBS with automatic segment management. You then create the table DAILY_ORDS_LST in the ORDERS_TBS tablespace using the command.

  CREATE TABLE daily_ords_1st(ordno NUMBER, ord_date DATE) PCTFREE 20;

  How does the PCTFREE storage parameter influence data storage for this table?

  A. It allows only 80% of space to be occupied in all data blocks of this table.
  B. It minimizes row chaining during row insertion.
  C. It minimizes row migration during existing row data updation.
  D. It automatically coalesces free space of a data block when it reaches 20% of available space.
  A. It allows only 80% of space to be occupied in all data blocks of this table.

• Question 35:

  Your database is configured in ARCHIVELOG mode, and daily full database backups are taken. RMAN is configured to perform control file autobackups.

  Which statement is true about the loss of a duplexed control file?

  A. The database remains open but transactions are not permitted.
  B. The database instance aborts, and media recovery is required after restoration of the control file to open the database.
  C. The database instance remains open and the control file can be restored without shutting down the database.
  D. The database instance aborts and a control file restore operation does not require media recovery.
  C. The database instance remains open and the control file can be restored without shutting down the database.

• Question 36:

  Which three statements are true about checkpointing? (Choose three.)

  A. It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the online redo log files.
  B. It ensures that all dirty buffers are written to data files during consistent shutdown.
  C. It reduces the time required for recovery in case of an instance failure.
  D. Frequent thread checkpoints can degrade database performance.
  E. It prompts the Database Writer (DBWn) process to write checkpoint information into data file headers and the control file.
  B. It ensures that all dirty buffers are written to data files during consistent shutdown.
  C. It reduces the time required for recovery in case of an instance failure.
  D. Frequent thread checkpoints can degrade database performance.

• Question 37:

  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
  D. by using RMAN

  ---

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

• Question 38:

  Which two must be installed or configured either manually or by DBCA in order to use Enterprise Manager Database Express (EM Express)? (Choose two.)

  A. A port number for Oracle HTTP Server must be configured
  B. The APEX_PUBLIC_USER role must be granted to SYSMAN
  C. A SYSMAN user with SYSDBA privilege must be created
  D. At least one TCP/IP dispatcher must be configured
  E. The Oracle HTTP Server must be installed
  B. The APEX_PUBLIC_USER role must be granted to SYSMAN
  D. At least one TCP/IP dispatcher must be configured

• Question 39:

  The HR schema exists in databases, BOSTON and DENVER, with the same password, HR.

  You have CREATE DATABASE LINK and CREATE SESSION privileges in both databases.

  DENVER is defined as a service name in the tnsnames.ora of both databases.

  You plan to use this command:

  CREATE DATABASE LNK hr_link CONNECT TO hr IDENTIFIED BY hr USING `DENVER';

  What must be done to ensure that all users in BOSTON can access the HR schema in DENVER?

  A. Change the command to create a public database link in BOSTON.
  B. Change the command to create a public database link in DENVER.
  C. Execute the command as SYS in DENVER.
  D. Execute the command as SYS in BOSTON.
  E. Execute the command as HR in BOSTON and SYS in DENVER.
  F. Execute the command as SYS in both databases.
  E. Execute the command as HR in BOSTON and SYS in DENVER.

• Question 40:

  Which three are true about the default database buffer cache? (Choose three.)

  A. Buffers containing block images may be selected for reuse based only on a Least Recently Used (LRU) algorithm.
  B. It is in the fixed area of the SGA.
  C. Its buffers can contain data block images for blocks that have a corresponding image in a data file.
  D. Buffers containing block images may be selected for reuse based only on a touch count algorithm.
  E. It can contain block images only for database blocks whose block size is equal to the buffer size.
  F. The keep and recycle cache memory is sub-allocated from memory allocated to the default buffer cache.
  G. Its buffers can contain data block images for blocks that have no corresponding image in a data file.
  B. It is in the fixed area of the SGA.
  F. The keep and recycle cache memory is sub-allocated from memory allocated to the default buffer cache.
  G. Its buffers can contain data block images for blocks that have no corresponding image in a data file.