Oracle 1Z0-034 Online Practice Questions and Exam Preparation

Oracle 1Z0-034 Online Questions & Answers

• Question 1:

  Which option must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?

  A. New channels for restore and recovery tasks
  B. New name for the data files of the tablespace
  C. Auxiliary name for the data files of the tablespace
  D. Auxiliary destinations for an auxiliary set of data files
  D. Auxiliary destinations for an auxiliary set of data files

• Question 2:

  The Automatic Workload Repository (AWR) snapshot interval is set to 1 hour. A user of your database notifies you that the system was slow between 10:00 PM and 10:10 PM, but the Automatic Database Diagnostic Management (ADDM) analysis for the time period between

  10:00

  PM and 11:00 PM does not show this performance problem. What would you suggest to analyze this performance problem for the user?

  A. SQL Tuning Advisor
  B. SQL Performance Analyzer
  C. Active Session History report
  D. AWR Compare Periods report
  C. Active Session History report

• Question 3:

  Note the following parameter settings: Which setting is NOT allowed?

  

  A. ALTER SYSTEM SET DB_CACHE_SIZE=50M;
  B. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;
  C. ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M;
  D. ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;
  B. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;

• Question 4:

  View the Exhibit and examine the RMAN commands.

  

  Which statement describes the effect of a backup retention policy on the backup of a backup set?

  A. Either all the copies of a backup set are obsolete or none of them are as per the retention policy.
  B. The copies of the backup will be reported as obsolete under a redundancy-based backup retention policy.
  C. The copies of the backup will be reported as obsolete under a recovery window-based backup retentionpolicy.
  D. All the copies of the backup set are counted as one instance of a backup and will deleted in backup setexceeds the redundancy-based backup retention policy.
  A. Either all the copies of a backup set are obsolete or none of them are as per the retention policy.

• Question 5:

  While designing a database, you created the EMPLOYEES table as an index-organized table (IOT). You must create a bitmap index on the EMPLOYEES .JOB_ID column.

  Which must you do to enable the creation of the bitmap index?

  A. A primary key must have been created.
  B. A mapping table must have been created.
  C. An overflow tablespace must have been specified.
  D. The PCTTHRESHOLD option must have been specified.
  B. A mapping table must have been created.

• Question 6:

  Your database initialization parameter file has the following entry:

  SEC_MAX_FAILZD_LOGIN_ATTEMPTS=3

  Which statement is true regarding this setting?

  A. It drops the connection after the specified number of login attempts fail for any user.
  B. It is enforced only if the password profile is enabled for the user.
  C. It locks the user account after the specified number of attempts.
  D. It drops the connection after the specified number of login attempts fail only for users who have the SYSDBAprivilege.
  A. It drops the connection after the specified number of login attempts fail for any user.

• Question 7:

  While exporting data with Data Pump, you find that the export takes longer than expected. You decide to stop the job and restart it during off-peak hours. Which view would you query to determine the name and status of the stopped job?

  A. DBA_JOBS
  B. V$SESSION
  C. V$SESSION_LONGOPS
  D. DBA_DATAPUMP_JOBS
  E. DBA_DATAPUMP_SESSIONS
  D. DBA_DATAPUMP_JOBS

• Question 8:

  ENCRYPT_TS is an encrypted tablespace that contains tables with data.

  Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

  A. The data is decrypted during SORT and JOIN operations.
  B. The data remains encrypted when it is read into memory.
  C. The data remains encrypted when it is stored in the redo logs.
  D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.
  C. The data remains encrypted when it is stored in the redo logs.

• Question 9:

  The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery?

  A. Inactive and current redo log files are required to accomplish recovery
  B. Online and archived redo files are required to accomplish instance recovery
  C. All redo log entries after the last checkpoint are applied from redo log files to data files
  D. All redo log entries recorded in the current log file until the checkpoint position are applied to data files
  C. All redo log entries after the last checkpoint are applied from redo log files to data files

• Question 10:

  Evaluate the following block of code:

  

  What is the outcome of the above code?

  A. It produces an error because a fully qualified host name needs to be specified.
  B. It produces an error because the range of ports associated with the hosts has not been specified.
  C. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges.
  D. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.
  C. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges.