Oracle Oracle Database 1Z0-034 Questions & Answers

• Question 111:

  Your database is open and running in ARCHIVELOG mode.

  You take RMAN full backups every Sunday night.

  On Monday morning, while querying the user1.emoloyees table, you receive the following error message:

  01578: ORACLE data block corrupted (file # 5, block # 51) ORA-0lll0: data file 5:

  '/u01/app/oracle/oradata/orcl/exanple0l.dbf* You need to recover from this while ensuring that:

  1.

  The data file remains online.

  2.

  Mean Time To Recover (MTTR) is minimized as much as possible You have no backup control file, but all the archived logs are accessible. Which method will best satisfy the requirements?

  A. flash back the corrupted blocks

  B. use the DBMS_REPAIR package

  C. use RMAN tablespace point in time recovery

  D. use the RMAN BLCCKRECOVER command

  E. perform a table point in time recovery with datapump export and import

  Correct Answer: D

• Question 112:

  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.

  Correct Answer: A

• Question 113:

  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

  Correct Answer: A

• Question 114:

  In one of your online transaction processing (OLTP) applications, table keys are frequently updated and queries performed using many different operators.

  In addition, reports are generated using complex joins with non-equality operators. What table organization is the best for this workload?

  A. heap table

  B. object table

  C. external table

  D. sorted hash clustered table

  E. global temporary table

  F. hash clustered table

  Correct Answer: B

• Question 115:

  Examine the following scenario:

  Database is running in ARCHIVELOG mode.

  Complete consistent backup is taken every Sunday.

  On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted

  The disk having active online redo log files is also corrupted. The hardware is repaired and the paths for online redo log files and control files are still valid.

  Which option would you use to perform the recovery of database till the point of failure?

  A.

  Restore the latest whole backup, perform complete recovery, and open the database normally

  B.

  Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGSoption.

  C.

  Restore the latest backups control file, perform complete recovery, and open the database with theRESETLOGS option.

  D.

  Restore the latest backup control file, perform incomplete recovery using backup control file, and open thedatabase with the RESETLOG option.

  Correct Answer: D

• Question 116:

  What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?

  A. The number of DBWR processes increases

  B. The number of ASMB processes increases

  C. The number of DBWR_TO_SLAVES increases

  D. The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/ Ooverhead

  Correct Answer: D

• Question 117:

  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.

  Correct Answer: A

• Question 118:

  You observed the following output for a user session:

  

  What do you infer from the preceding output?

  A. Resumable set for session with sid 18

  B. The user session has entered into a deadlock

  C. The database instance is enabled to use asynchronous commit

  D. The threshold warning limit is exceeded for the tablespace that is used by the user session

  Correct Answer: A

• Question 119:

  Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the database use the default temporary tablespace. A user issues a query on the orders table and receives the following error:

  ERROR at line I: ORA-0I565: error in identifying file '/u01/app/oracle/oradata/TEST/temp01.tmp' ORA-27037: unable to obtain file status

  What would be the most efficient way to rectify this error?

  A. Add a new tempfile to the user's temporary tablespace and drop the tempfile that produced the error.

  B. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.

  C. Allow the database to continue running, drop the temp01.tmp temporary file, and then re- create it with new tempfiles.

  D. Take the temporary tablespace offline, recover the missing tempfile by applying redo logs, and then bring the temporary tablespace online.

  Correct Answer: A

• Question 120:

  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

  Correct Answer: C