Oracle 1Z0-034 Online Practice Questions and Exam Preparation

Oracle 1Z0-034 Online Questions & Answers

• Question 111:

  You created a tablespace with the following statement:

  CREATE BIGFILE TABLESPACE adtbs

  DATAFILE '/probdb/data/adtbs.dbf' SIZE 10G;

  There is now a requirement to increase the size of the tablespace.

  Which two ALTER statements are correct in this scenario? (Choose two.)

  A. ALTER TABLESPACE adtbs RESIZE 20G;
  B. ALTER TABLESPACE adtbs ADD DATAFILE;
  C. ALTER TABLESPACE adtbs AUTOEXTEND ON;
  D. ALTER TABLESPACE adtbs ADD DATAFILE'/proddb/data/adtbs1.dbf' SIZE 10G;
  E. ALTER TABLESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf' AUTOEXTEND ON;
  A. ALTER TABLESPACE adtbs RESIZE 20G;
  C. ALTER TABLESPACE adtbs AUTOEXTEND ON;

• Question 112:

  Which two statements are true about the duplexing of the backups taken by RMAN? (Choose two.)

  A. It's only supported for the backups performed on the tape
  B. It is not supported for backup operations that produce image copies
  C. Duplex backups need a parallelism for the device to be equal to number of copies
  D. Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously
  B. It is not supported for backup operations that produce image copies
  D. Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously

• Question 113:

  The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log

  file:

  ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;

  Which action should you perform immediately after using this command?

  A. You should perform a log switch
  B. You should make a backup of the database
  C. You should switch the database to the NOARCHIVELOG mode
  D. You should shut down the database instance and perform a complete database recovery
  B. You should make a backup of the database

• Question 114:

  You work with a newly created database. Presently, there is no application load on the database instance. You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.

  What action must you take to achieve this?

  A. Run Segment Advisor.
  B. Run the SQL Tuning Advisor (STA).
  C. Run the Automatic Workload Repository (AWR) report.
  D. Run the SQL Access Advisor with a hypothetical workload.
  D. Run the SQL Access Advisor with a hypothetical workload.

• Question 115:

  You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue?

  A. Disable automatic checkpoint tuning.
  B. Check the size of the redo log file size and increase the size if it is small.
  C. Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.
  D. Decrease the number of redo log members if there are more than one redo log members available in each redo log group.
  B. Check the size of the redo log file size and increase the size if it is small.
  C. Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.

• Question 116:

  Your database is running in ARCHIVELOG mode. You have been taking backups of all the data files and control files regularly.

  You are informed that some important tables in the BILLING tablespace have been dropped on February 28, 2007 at 10.30 AM and must be recovered.

  You decide to perform an incomplete recovery using the following command:

  SQL> RECOVER DATABASE UNTIL TIME '2007-02-28:10:15:00';

  Identify the files that must be restored to recover the missing tables successfully.

  A. Restore the backup of all the data files.
  B. Restore the backup of all the data files and the control file.
  C. Restore the backup of only the data files that contain the dropped tables.
  D. Restore the backup of all the data files belonging to the tablespace containing the dropped tables.
  A. Restore the backup of all the data files.

• Question 117:

  You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.

  You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows: You then issue the following statement to recover the table:

  SQL> SELECT object_name, original_name, droptime FROM recyclebin;

  

  What would be the outcome of the precedent statement?

  A. It retrieves the latest version of the table from the recycle bin
  B. It retrieves the oldest version of the table from the recycle bin
  C. It retrieves the version of the table for which undo information is available
  D. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column
  A. It retrieves the latest version of the table from the recycle bin

• Question 118:

  Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIEVELOG mode? (Choose all that apply.) (Choose all that apply.)

  A. setting the FAST_START_MTTR_TARGET to set the mean time to recover
  B. setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs
  C. using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area
  D. using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area.
  C. using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area
  D. using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area.

• Question 119:

  SQL> SELECT blocks FROM user_segments WHERE segment_name=,ALTBT; BLOCKS ---------------SQL> ALTER TABLE altb SHRINK SPACE COMPACT;

  Table altered.

  SQL> SELECT blocks FROM user_segments WHERE segment_name=*ALTB*;

  BLOCKS

  View the Exhibit and examine the output and commands executed on the ALTB table.

  Why does the number of blocks for the table remain the same after the shrink operation?

  A. because the table did not contain migrated or chained rows
  B. because the row IDs remain the same for all rows during the shrink operation
  C. because the progress of the shrink operation is not saved in the bitmap blocks of the table
  D. because the high-water mark (HWM) did not move due to the compact option that is used in the shrink operation
  D. because the high-water mark (HWM) did not move due to the compact option that is used in the shrink operation

• Question 120:

  You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).

  Identify two scenarios in which you must have a recovery catalog.

  A. To store the backup information of multiple database
  B. To restrict the amount of space that is used by the backups
  C. To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
  D. To list the data files that were in a target database at a given time by using the AT option of REPORTSCHEMA command.
  A. To store the backup information of multiple database
  D. To list the data files that were in a target database at a given time by using the AT option of REPORTSCHEMA command.