Click here for answers:
Answer - "1Z0-043 sample questions"
Question
1. What two values are required to identify a database incarnation within the recovery catalog?
A. DBID
B. DATABASE NAME
C. DB_KEY
D. DATABASE_VALUE
2. What is the correct command sequence for recovering a missing tempfile named temp?
A. STARTUP MOUNT, CREATE TEMPORARY TABLESPACE temp TEMPFILE
B. STARTUP NOMOUNT, DROP TABLESPACE temp, CREATE TEMPORARY TABLESPACE temp TEMPFILE
C. STARTUP MOUNT, DROP TABLESPACE temp, CREATE TEMPORARY TABLESPACE temp TEMPFILE
D. STARTUP, DROP TABLESPACE temp, CREATE TEMPORARY TABLESPACE temp TEMPFILE
3. You have a backup from two days ago. It is discovered that corruption was introduced today at 6:30 P.M. You perform an incomplete recovery of the database to 6:25 P.M. before the corruption. One day later you have a media failure, and you need to recover but you only have the same backup that was used to perform an incomplete recovery prior to the corruption. What will happen to the recovery attempt for the media failure? A. The media recovery will fail because you have performed a RESETLOGS to recover from the corruption and you have not taken another backup after the RESETLOGS operation.
B. The media recovery will be successful because you can perform a RESETLOGS torecover from an incomplete recovery to a new point-in-time greater than the RESETLOGS operation.
C. The media recovery will fail because you always must take a backup following an incomplete recovery with RESETLOGS to open the database.
D. The media recovery will only be successful if you recover the database back to the original time of 6:25 P.M. before the corruption.
4. A user accidentally deleted a customer identified by 46435 from the customers table on September 6, 2004 at 3:30 P.M. Which of the following recovery approaches will successfully recover CUSTOMER_ID 46435 with the least impact on database operations?
A. Perform the following RMAN incomplete recovery after restarting the database in MOUNT mode: run { set until time ‘06-SEP-2004 15:25:00’; restore database; recover database; }
B. Perform the following DML transaction utilizing Flashback Query: insert into customers select * from customers where customer_id = 46435 as of timestamp to_timestamp (’06-SEP-2004 15:25:00’) where customer_id = 46435;
C. Perform a user-managed recovery after restoring database files after starting the database in MOUNT mode: recover database until time ’06-SEP-2004 15:25:00’ alter database open resetlogs
D. None of the above.
5. You have created a new table. How long do you have to wait to be sure that Oracle has automatically gathered optimizer statistics for the table and loaded them into the AWR?
A. Not more than 30 minutes.
B. Up to seven days.
C. Until the next scheduled automated statistics collection job is run.
D. Optimizer statistics are not stored in the AWR. E. You must gather the statistics manually when a new table is created. Oracle will collect them automatically after that.
6. A new workstation has been added at your location in Spain. This machine will be used to run an application that connects to your database in the United States. A technician installs the Oracle client and the application. The user on the new machine notices that performance seems to be sluggish compared to the existing workstations. The technician swears that the application is configured identically on all machines, and has ruled out network issues. What is the most likely cause? (Choose the best answer.)
A. Defective hardware
B. Client character set
C. Client NLS_LANGUAGE setting
D. Server NLS_LANGUAGE setting E. Routing tables
7. You want to set up DRM to allocate CPU resources between seven resource consumer groups. The groups should be allocated only CPU unused by the SYS_GROUP group. Six of the groups will get 15 percent and the remaining group will receive 10 percent. Which of the following would achieve all of these objectives with the least amount of effort?
A. Create a simple plan.
B. Create a complex plan with one sub-plan.
C. Create a complex plan with more than one sub-plan.
D. Create a simple plan with one sub-plan.
E. Create a simple plan with more than one sub-plan.
8. You are concerned about ORA-00600 messages that have been appearing in the alert log, and you want to know if any new ones appear. Which Oracle feature might be of use? (Choose the best answer.)
A. AWR
B. Advisory framework
C. Server-generated alerts
D. Alert monitor
E. ADDM
9. Which new 10g feature allows Oracle RMAN to back up larger databases more efficiently?
A. The COMPRESSED BACKUPSET command
B. The Oracle Flashback Database
C. Block change tracking
D. Automated tablespace point-in-time recovery (TSPITR)
10. What method is used to improve backup performance when creating backup sets?
A. Multicopy
B. Multiplecopy
C. Multiplex
D. Multiply
11. Compressed backups work with which of the following commands?
A. COPY AS BACKUP
B. BACKUP AS COPY
C. BACKUP
D. COPY
12. What must be done to recover a missing redo log file member?
A. First perform a ALTER DATABASE DROP LOGFILE MEMBER filename and then ALTER DATABASE ADD LOGFILE MEMBER filename on the missing logfile member.
B. Perform ALTER DATABASE ADD LOGFILE MEMBER filename on the missing logfile.
C. Nothing is required if you have multiplexed redo logs.
13. Which credentials are needed to perform a recovery with EM? (Choose all that apply.) A. Database account with SYSDBA privilege B. Administrator account in Windows C. Oracle account in Unix 14. What view can be used to query diagnostic information about transactional changes in the database?
A. FLASHBACK_TRANSACTION_QUERY
B. DBA_TRANSACTION_QUERY
C. V$TRANSACTION_QUERY
D. V$FLASHBACK_TRANSACTION_QUERY
15. The DBVERIFY utility reports output about corruption in which manner?
A. The DBVERIFY utility identifies the amount of corrupt objects, not the amount of blocks in a table.
B. The DBVERIFY utility identifies the amount of corrupt blocks, not the amount of objects in a datafile.
C. The DBVERIFY utility identifies the amount of corrupt pages, not the amount of blocks in a datafile.
D. The DBVERIFY utility identifies the amount of corrupt pages, not the amount of blocks in the database.
==>
