Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 341:

  Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database? (Choose two.)

  A. It loads data faster than conventional SQL*Loader
  B. No data file needs to be specified
  C. It can load data in parallel
  D. It loads data more efficiently than conventional SQL*Loader
  E. It requires Enterprise Manager Express to be configured
  A. It loads data faster than conventional SQL*Loader
  C. It can load data in parallel

  ---

  Reference: https://www.oracle.com/technetwork/database/enterprise-edition/learnmore/sqlldr-express-mode-wp-1991038.pdf

• Question 342:

  You want to load data from a large file into your database without causing an overhead on the SGA.

  Which tool would you use.

  A. external table
  B. Oracle data Pump
  C. SQL*Loader with a direct data path
  D. SQL*Loader with a conventional data path
  E. Enterprise Manager Database Express
  C. SQL*Loader with a direct data path

  ---

  References https://docs.oracle.com/cd/B19306_01/server.102/b14215/ldr_modes.htm#i1007501

• Question 343:

  What happens if a maintenance window closes before a job that collects optimizer statistics completes?

  A. The job is terminated and the gathered statistics are not saved.
  B. The job is terminated but the gathered statistics are not published.
  C. The job continues to run until all statistics are gathered.
  D. The job is terminated and statistics for the remaining objects are collected the next time the maintenance window opens.
  D. The job is terminated and statistics for the remaining objects are collected the next time the maintenance window opens.

  ---

  The stop_on_window_close attribute controls whether the GATHER_STATS_JOB continues when the maintenance window closes. The default setting for the stop_on_window_close attribute is TRUE, causing Scheduler to terminate GATHER_STATS_JOB when the maintenance window closes. The remaining objects are then processed in the next maintenance window.

  References: https://docs.oracle.com/cd/B19306_01/server.102/b14211/stats.htm#g49431

• Question 344:

  You execute the commands:

  

  Which two statements are true? (Choose two.)

  A. The create user command fails if any role with the name SIDNEY exists in the database.
  B. The user Sidney can connect to the database instance but cannot perform sort operations because no space quota is specified for the temp tablespace.
  C. The user Sidney is created but cannot connect to the database instance because no profile is assigned to the user.
  D. The user Sidney can connect to the database instance but requires relevant privileges to create objects in the users tablespace.
  E. The user Sidney is created and authenticated by the operating system.
  A. The create user command fails if any role with the name SIDNEY exists in the database.
  D. The user Sidney can connect to the database instance but requires relevant privileges to create objects in the users tablespace.

• Question 345:

  Which two tasks must you perform before you begin the upgrade process to Oracle Database 12c? (Choose two.)

  A. Put all readonly tablespaces in read write mode
  B. Recompile all invalid objects
  C. Set the compatible parameter to 12.1.0.1
  D. Gather dictionary statistics
  E. Empty all user recycle bins
  B. Recompile all invalid objects
  E. Empty all user recycle bins

• Question 346:

  In which three situations can you use threshold server-generated alerts to help diagnose and fix problems? (Choose three.)

  A. when free space in a locally managed tablespace falls below a specified percentage
  B. when the number of logons per second exceeds a specific value
  C. when a resumable statement is suspended
  D. when the total number of locked user account exceeds a specific value
  E. when the total number of logons exceeds a specific value
  F. when free space in a dictionary managed tablespace falls below a specified percentage
  A. when free space in a locally managed tablespace falls below a specified percentage
  B. when the number of logons per second exceeds a specific value
  C. when a resumable statement is suspended

  ---

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

• Question 347:

  You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.

  Which two are possible if table updates are performed which affect the invisible index columns? (Choose two.)

  A. The index remains invisible.
  B. The index is not updated by the DML statements on the indexed table.
  C. The index automatically becomes visible in order to have it updated by DML on the table.
  D. The index becomes unusable but the table is updated by the DML.
  E. The index is updated by the DML on the table.
  A. The index remains invisible.
  E. The index is updated by the DML on the table.

  ---

  Unlike unusable indexes, an invisible index is maintained during DML statements. Note:

  * Oracle 11g allows indexes to be marked as invisible. Invisible indexes are maintained like any other index, but they are ignored by the optimizer unless the OPTIMIZER_USE_INVISIBLE_INDEXES parameter is set to TRUE at the instance or session level. Indexes can be created as invisible by using the INVISIBLE keyword, and their visibility can be toggled using the ALTER INDEX command.

• Question 348:

  Your database is in NOARCHIVELOG mode. You want to enable archiving for the database.

  Examine the steps:

  1.

  Execute the ALTER DATABASE ARCHIVELOG command.

  2.

  Execute SHUTDOWN IMMEDIATE.

  3.

  Execute STARTUP MOUNT.

  4.

  Set the DB_RECOVERY_FILE_DEST parameter to $ORACLE_HOME/dbs/.

  5.

  Execute STARTUP NOMOUNT.

  6.

  Open the database.

  7.

  Execute SHUTDOWN TRANSACTIONAL.

  Identify the required steps in the correct sequence.

  A. 4, 2, 5, 1, 6
  B. 1, 2, 3, 4, 6
  C. 2, 3, 1, 6
  D. 2, 5, 1, 6
  C. 2, 3, 1, 6

• Question 349:

  You want to create a test database as a replica of your production database with minimum intervention from a DBA.

  Which method would you use?

  A. Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump.
  B. Use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure.
  C. Create the database by using the CREATE DATABASE. . . command and manually import data by using Data Pump.
  D. Use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the database in the new location.
  A. Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump.

• Question 350:

  Your database is running in NOARCHIVLOG mode.

  Examine the following parameters:

  

  You execute the following command after performing a STARTUP MOUNT:

  SQL> ALTER DATABASE ARCHIVELOG;

  Which statement is true about the execution of the command?

  A. It executes successfully and sets the Fast Recovery Area as the local archive destination.
  B. It executes successfully and issues a warning to set LOG_ARCHIVE_DEST while opening the database.
  C. It fails and returns an error about LOG_ARCHIVE_DEST not being set.
  D. It executes successfully and sets $ORACLE_HOME/dbs as the default archive destination.
  A. It executes successfully and sets the Fast Recovery Area as the local archive destination.