Oracle 1Z0-034 Online Practice Questions and Exam Preparation

Oracle 1Z0-034 Online Questions & Answers

• Question 21:

  Which two statements are true regarding hot patching? (Choose two.)

  A. It requires relinking of the Oracle binary.
  B. It does not require database instance shutdown.
  C. It can detect conflicts between two online patches.
  D. It is available for installing all patches on all platforms.
  E. It works only in a single database instance environment.
  B. It does not require database instance shutdown.
  C. It can detect conflicts between two online patches.

• Question 22:

  You issued the following commands to configure settings in RMAN:

  RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;

  RMAN> CONFIGURE DEFAULT DEVICE TYPE TO Sbt;

  RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE

  TYPE DISK TO 2;

  Then you issued the following command to take the backup:

  RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

  Which statement is true about the execution of the above command?

  A. The backup will terminate because the FORMAT clause was not configured for the channel
  B. It backs up two copies of data files to tape and disk, and two copies of archived log file on tape
  C. It backs up the data files and archived log files to disk, making two copies of each data file and archived logfile
  D. It backs up the data files and archived log files to tape, making two copies of each data file and archived logfile
  D. It backs up the data files and archived log files to tape, making two copies of each data file and archived logfile

• Question 23:

  The database is configured in ARCHIEVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option?

  A. Control files
  B. Password file
  C. Inactive online redo log file
  D. Archived log files required to perform recovery
  E. Newly created tablespace which is not backed up
  A. Control files
  D. Archived log files required to perform recovery

• Question 24:

  You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package. Which statement is true regarding the ACL created?

  A. It is a list of remote database links stored in the XML file that are available to the users of the database.
  B. It is a list of users and network privileges stored in the XML file according to which a group of users canconnect to one or more hosts.
  C. It is a list of users and network privileges stored in the data dictionary according to which a group of userscan connect to one or more hosts.
  D. It is the list of the host names or the IP addresses stored in the data dictionary that can connect to yourdatabase through PL/SQL network utility packages such as UTL_TCP.
  B. It is a list of users and network privileges stored in the XML file according to which a group of users canconnect to one or more hosts.

• Question 25:

  Your production database is functional on the SHOST1 host. You are backing up the production database by using Recovery Manager (RMAN) with the recovery catalog. You want to replicate the production database to anther host, SHOST2, for testing new applications. After you ensured that the backups of the target database are accessible on the new host, what must you do to restore and recover the backup for the test environment?

  A. Restoring the control file from the backup by using the NOCATALOG option to restore, and recovering the data files
  B. Restoring the data files by using the NOCATALOG option and using the SET NEWNAME command to change the location
  C. Restoring the server parameter file from the backup by using the recovery catalog to restore,
  D. Restoring the data files from the backup by using the recovery catalog to recover the files, and using the SWITCH command to change the location.
  A. Restoring the control file from the backup by using the NOCATALOG option to restore, and recovering the data files

• Question 26:

  View the Exhibit to examine the replay settings for replay parameters.

  What is the implication for setting the values for replay parameters? (Choose all that apply.)

  Exhibit:

  

  A. The COMMIT order in the captured workload is preserved during replay.
  B. The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls.
  C. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured.
  D. The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying.
  E. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins.
  A. The COMMIT order in the captured workload is preserved during replay.
  C. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured.
  D. The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying.

• Question 27:

  Which two statements are true about setting the FAST_ START_ MTTR_ TARGET initialization parameter to a nonzero value?

  A. The MTTR advisor will be disabled.
  B. Automatic checkpoint tuning will be enabled.
  C. The value for the LOG_CHECKPIONT_INTERVAL initialization parameter will be override the value for FAST_START_MTTR_TARGET.
  D. The time taken to recover the instance after the crash is always exactly the same as the value given for the FAST_START_MTTR_TARGET initialization parameter.
  B. Automatic checkpoint tuning will be enabled.
  C. The value for the LOG_CHECKPIONT_INTERVAL initialization parameter will be override the value for FAST_START_MTTR_TARGET.

• Question 28:

  The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?

  A. The tape I/O performed is asynchronous
  B. The tape buffer is allocated from the System Global Area (SGA)
  C. The tape buffer is allocated from the Program Global Area (PGA)
  D. Oracle I/O uses an interrupt mechanism to determine when each I/O completes
  C. The tape buffer is allocated from the Program Global Area (PGA)

• Question 29:

  Examine the following command to create an external table from EMPLOYEES and DEPARTMENTS database tables.

  1.

  CREATE TABLE employee_ext

  2.

  (employee_id, first_name, department_name)

  3.

  ORGANIZATION EXTERNAL

  4.

  (

  5.

  TYPE ORACLE_LOADER

  6.

  DEFAULT DIRECTORY ext_dir

  7.

  LOCATION ('emp1.dmp')

  8.

  )

  9.

  PARALLEL

  10.

  AS

  11.

  SELECT e.emplyee_id, e.first_name, e.last_name, d.department_name

  12.

  FROM employees e, departments d; Which line of the command would cause an error?

  A. line 2, because the column names have been specified
  B. line 7, because file name must have a .dat extension
  C. line 3, because ORGANIZATION EXTERNAL has been specified
  D. line 9, because the PARALLEL option cannot be specified with one file name
  E. line 12, because there is no join defined between EMPLOYEES and DEPARTMENTS table
  F. line 5, because ORACLE_LOADER is not a valid structure for external table creation with the SELECT statement
  F. line 5, because ORACLE_LOADER is not a valid structure for external table creation with the SELECT statement

• Question 30:

  You executed the following commands:

  SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false; SQL> EXECUTE DBMS_STATS. SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH', 'false'); SQL> EXECUTE DBMS_STATS. GATHER_TABLE_STATS

  ('SH' , 'CUSTOMERS');

  Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?

  A. The statistics are stored in the pending statistics table in the data dictionary.
  B. The statistics are treated as the current statistics by the optimizer for all sessions.
  C. The statistics are treated as the current statistics by the optimizer for the current sessions only.
  D. The statistics are temporary and used by the optimizer for all sessions until this session terminates.
  A. The statistics are stored in the pending statistics table in the data dictionary.