Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 391:

  In your database, archive logging and control file autobackup are enabled.

  The data files and redo log files are intact but control files are impacted due to media failure.

  In which two recovery scenarios must you use the RESETLOGS option? (Choose two.)

  A. One control file copy is intact so the spfile is changed to refer to only one copy.
  B. One control file copy is intact and damaged control file copies have to be restored to the default location.
  C. All copies of the control file are damaged and the CREATE CONTROLFILE statement is executed manually.
  D. All copies of the control file are damaged and the auto backed up control file is used for recovery.
  E. One control file copy is intact and damaged control file copies have to be restored to a non-default location.
  C. All copies of the control file are damaged and the CREATE CONTROLFILE statement is executed manually.
  D. All copies of the control file are damaged and the auto backed up control file is used for recovery.

• Question 392:

  Your single-instance Oracle 12c database home currently supports conventional auditing and uses Automatic Storage Management (ASM). You want to enable unified auditing by executing the command:

  $ make –fins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME

  Which two steps should you perform before executing this command? (Choose two.)

  A. Ensure that the initialization parameter AUDIT_TRAIL is set to DB.
  B. Drop any existing fine-grained audit (FGA) policies.
  C. Stop the listener.
  D. Shut down the database instance.
  E. Disable auditing by setting the initialization parameter AUDIT_TRAIL to NONE.
  C. Stop the listener.
  E. Disable auditing by setting the initialization parameter AUDIT_TRAIL to NONE.

  ---

  References: https://blogs.oracle.com/UPGRADE/entry/unified_auditing_is_it_on

• Question 393:

  You want to create a file watcher and an event-based job for detecting the arrival of files on the local server from various locations. To achieve this, you enable the raising of file arrival events from remote systems. Which two conditions must be satisfied to receive file arrival events from a remote system? (Choose two.)

  A. The remote system must have a running Oracle Database instance and a scheduler agent installed.
  B. The initialization parameter REMOTE_OS_AUTHENT must be set to TRUE on your database.
  C. The local database must be set up to run remote external jobs.
  D. The remote system's scheduler agent must be registered with your database.
  E. Database links to remote databases must be created.
  A. The remote system must have a running Oracle Database instance and a scheduler agent installed.
  C. The local database must be set up to run remote external jobs.

  ---

  References: https://docs.oracle.com/cd/E18283_01/server.112/e17120/scheduse005.htm

• Question 394:

  Which two categories of segments are analyzed by the Automatic Segment Advisor? (Choose two.)

  A. segments in tablespaces that have exceeded a critical or warning space threshold
  B. segments that have the highest growth rate in a database
  C. segments that are sparsely populated and have more than 10% of free space below the high water mark.
  D. segments that have unusable indexes
  E. segments for tables created using ADVANCED ROW COMPRESSION
  A. segments in tablespaces that have exceeded a critical or warning space threshold
  B. segments that have the highest growth rate in a database

  ---

  References: http://www.dba-oracle.com/t_segment_advisor_10g.htm

• Question 395:

  You want to upgrade an Oracle Database running Oracle Database 11g to Oracle Database 12c.

  Which three tasks should be performed before a manual upgrade? (Choose three.)

  A. running preupgrad.sql in Oracle Database 11g to generate fix-up scripts and a log file
  B. running utlu121s.sql from the new Oracle home to display information about the required initialization parameters
  C. copying the initialization parameter file to the new Oracle home
  D. copying the password file to the new Oracle home
  E. copying net configuration files to the new Oracle home
  A. running preupgrad.sql in Oracle Database 11g to generate fix-up scripts and a log file
  C. copying the initialization parameter file to the new Oracle home
  E. copying net configuration files to the new Oracle home

• Question 396:

  You want to schedule a job to rebuild a table's indexes after a bulk insert, which must be scheduled as soon as a file containing data arrives on the system.

  What would you do to accomplish this?

  A. Create a file watcher and an event-based job for bulk insert and then create another job to rebuild indexes on the table.
  B. Create a file watcher for the bulk inserts and then create a job to rebuild indexes.
  C. Create a job array and add a job for bulk insert and a job to rebuild indexes to the job array.
  D. Create an event-based job for the file arrival event, then create a job for bulk insert, and then create a job to rebuild indexes.
  A. Create a file watcher and an event-based job for bulk insert and then create another job to rebuild indexes on the table.

• Question 397:

  Which two statements are true about the (PMON) background process in Oracle Database 12c? (Choose two.)

  A. It records checkpoint information in the control file.
  B. It frees unused temporary segments.
  C. It kills sessions that exceed idle time.
  D. It registers database services with all local and remote listeners known to the database instance.
  E. It frees resources held by abnormally terminated processes.
  D. It registers database services with all local and remote listeners known to the database instance.
  E. It frees resources held by abnormally terminated processes.

  ---

  References: https://docs.oracle.com/database/122/CNCPT/process-architecture.htm#CNCPT9840

• Question 398:

  Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.

  You want to issue the following RMAN command:

  RMAN > BACKUP TABLESPACE hr_pdb:userdata;

  Which task should you perform before issuing the command?

  A. Place the root container in ARHCHIVELOG mode.
  B. Take the user data tablespace offline.
  C. Place the root container in the nomount stage.
  D. Ensure that HR_PDB is open.
  A. Place the root container in ARHCHIVELOG mode.

• Question 399:

  DEFERRED_SEGMENT_CREATION is TRUE in one of your databases. You execute this command:

  

  Which three statements are true immediately after this statement executes successfully?

  A. A database object is created.
  B. No database segment is created.
  C. The table and column definitions are stored in the data dictionary.
  D. No table definition is stored in the data dictionary.
  E. No column definitions are stored in the data dictionary.
  F. No object definition is stored in the data dictionary.
  A. A database object is created.
  B. No database segment is created.
  C. The table and column definitions are stored in the data dictionary.

• Question 400:

  The HR user owns the BONUSES table. HR grants privileges to the user TOM by using the command:

  SQL> GRANT SELECT ON bonuses TO tom WITH GRANT OPTION;

  TOM then executes this command to grant privileges to the user JIM:

  SQL> GRANT SELECT ON hr.bonuses TO jim;

  Which statement is true?

  A. TOM cannot revoke the SELECT ON HR.BONUSES privilege from JIM.
  B. HR can revoke the SELECT ON HR.BONUSES privilege from JIM.
  C. JIM can grant the SELECT ON HR.BONUSES privilege to other users, but cannot revoke the privilege from them.
  D. HR can revoke the SELECT ON HR.BONUSES privilege from TOM, which will automatically revoke the SELECT ON HR.BONUSES privilege from JIM.
  D. HR can revoke the SELECT ON HR.BONUSES privilege from TOM, which will automatically revoke the SELECT ON HR.BONUSES privilege from JIM.