최신 Oracle Database 11g 11gocmu 무료샘플문제:

1. Which command creates an image copy?

A) copy back
B) copy as backup
C) backup copy
D) backup as copy

2. To enable resumable space allocation for the instance, which of the following initialization parameters should you set to a nonzero value?

A) RESUMABLE_TIME
B) RESUMABLE_TIMEOUT
C) RESUMABLE_SPACE
D) TIME_RESUMABLE
E) RESUMABLE_SPACE_TIME

3. Examine the following commands and their output:
SQL> SELECT ename, sal FROM emp WHERE ename='JAMES'; ENAME SAL JAMES 1050 SQL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename='JAMES';
1 row updated. SQL> SELECT ename, sal FROM emp WHERE ename='JAMES'; ENAME SAL JAMES 2310
View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.
What could be the possible cause for the query not displaying any row?
Exhibit:

A) The database is not configured in ARCHIVELOG mode.
B) Flashback logging is not enabled for the database.
C) Supplemental logging is not enabled for the database.
D) The changes made to the table are not committed.

4. As DBA for the Rebel Alliance you have decided that you need to facilitate some redundancy in your database. Using ASM, you want to create a disk group that will provide for the greatest amount of redundancy for your ASM data (you do not have advanced SAN mirroring technology available to you, unfortunately). Which of the following commands would create a disk group that would offer the maximum in data redundancy?

A) CREATE DISKGROUP dg_alliance1 NORMAL REDUNDANCY failgroup diskcontrol1
DISK 'c:\oracle\asm_disk\_file_disk3' NAME file_ diska1 failgroup diskcontrol2 DISK
'c:\oracle\asm_disk\_file_disk4' NAME file_
diskb1;
B) CREATE DISKGROUP dg_alliance1
HIGH REDUNDANCY
failgroup diskcontrol1 DISK 'c:\oracle\asm_disk\_file_disk1' NAME file_
disk1
failgroup diskcontrol2 DISK 'c:\oracle\asm_disk\_file_disk2' NAME file_
disk2
failgroup diskcontrol2 DISK 'c:\oracle\asm_disk\_file_disk3' NAME file_
disk3;
C) CREATE DISKGROUP dg_alliance1
MAXIMUM REDUNDANCY
failgroup diskcontrol1 DISK 'c:\oracle\asm_disk\_file_disk1' NAME file_
disk1
failgroup diskcontrol2 DISK 'c:\oracle\asm_disk\_file_disk2' NAME file_
disk2
failgroup diskcontrol2 DISK 'c:\oracle\asm_disk\_file_disk3' NAME file_
disk3
failgroup diskcontrol2 DISK 'c:\oracle\asm_disk\_file_disk4' NAME file_
disk4;
D) None of the above
E) CREATE DISKGROUP dg_alliance1 EXTERNAL REDUNDANCY
failgroup diskcontrol1 DISK 'c:\oracle\asm_disk\_file_disk3' NAME file_
diska1;

5. Which statements are true regarding table compression? (Choose all that apply.)

A) It incurs extra CPU overhead during DML but not direct loading operations.
B) It requires uncompress operation during I/O.
C) It saves disk space and reduces memory usage.
D) It incurs extra CPU overhead during DML as well as direct loading operations.
E) It saves disk space but has no effect on memory usage.

질문과 대답: