최신Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP - 1z1-034무료샘플문제
문제1
Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)
Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)
정답: B,C,D
문제2
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode. Which two statements are true in this scenario?
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode. Which two statements are true in this scenario?
정답: A,D
문제3
There was media failure and you decide to check the data files for block corruption. Which would you use to create a report on any corruptions found?
There was media failure and you decide to check the data files for block corruption. Which would you use to create a report on any corruptions found?
정답: D
문제4
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.
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.
정답: D
문제5
Which three tasks can be performed using a duplicate database? (Choose three.)
Which three tasks can be performed using a duplicate database? (Choose three.)
정답: A,B,C
문제6
View the following SQL statements: Transaction T1
SQL> INSERT INTO hr.regions 2 VALUES (5,'Pole'); 3 COMMIT;
Transaction T2
SQL> UPDATE hr.regions 2 SET region_name='Poles' 3 WHERE region_id = 5; 4 COMMIT;
Transaction T3
SQL> UPDATE hr.regions 2 SET region_name='North and South Poles' 3 WHERE region_id = 5;
You want to back out transaction T2. Which option would you use?
View the following SQL statements: Transaction T1
SQL> INSERT INTO hr.regions 2 VALUES (5,'Pole'); 3 COMMIT;
Transaction T2
SQL> UPDATE hr.regions 2 SET region_name='Poles' 3 WHERE region_id = 5; 4 COMMIT;
Transaction T3
SQL> UPDATE hr.regions 2 SET region_name='North and South Poles' 3 WHERE region_id = 5;
You want to back out transaction T2. Which option would you use?
정답: D
설명: (ITDumpsKR 회원만 볼 수 있음)
문제7
You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped. On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that.
So you decided to perform incomplete recovery until 11:00 AM. All the archive logs needed to perform recovery are intact. In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup. Then you mounted
the database. Identify the next set of commands that are required to accomplish the task?
You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped. On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that.
So you decided to perform incomplete recovery until 11:00 AM. All the archive logs needed to perform recovery are intact. In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup. Then you mounted
the database. Identify the next set of commands that are required to accomplish the task?
정답: A
문제8
UNDO__RETENTION is set to 1000 and retention is not guaranteed.
You configure the database with a fixed size undo tablespace.
Which is true about undo retention in this configuration?
UNDO__RETENTION is set to 1000 and retention is not guaranteed.
You configure the database with a fixed size undo tablespace.
Which is true about undo retention in this configuration?
정답: B
문제9
You observed the following output for a user session:
What do you infer from the preceding output?
You observed the following output for a user session:
What do you infer from the preceding output?
정답: C
문제10
You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in / etc. Which two statements are true regarding this oranfstab file? (Choose two.)
You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in / etc. Which two statements are true regarding this oranfstab file? (Choose two.)
정답: B,D