최신Oracle Database 11g: Administration II - 1Z0-053무료샘플문제
문제1
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)? (Choose three.)
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)? (Choose three.)
정답: A,B,E
문제2
Which options must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?
Which options must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?
정답: C
문제3
Which of the following are included in a transportable tablespace set? (Choose all that apply.)
Which of the following are included in a transportable tablespace set? (Choose all that apply.)
정답: D,E
문제4
View the Exhibit and examine the RMAN commands.
Which statement describes the effect of a backup retention policy on the backup of a backup set?
View the Exhibit and examine the RMAN commands.
Which statement describes the effect of a backup retention policy on the backup of a backup set?
정답: D
문제5
You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?
You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?
정답: C
설명: (KoreaDumps 회원만 볼 수 있음)
문제6
You want to track and store all transactional changes to a table over its lifetime.
To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years.
After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years.
To accomplish this, you issued the following command:
ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;
What is the implication of this command?
You want to track and store all transactional changes to a table over its lifetime.
To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years.
After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years.
To accomplish this, you issued the following command:
ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;
What is the implication of this command?
정답: C
문제7
You want the Automatic SQL Tuning process to stop accepting and implementing the recommended SQL profiles automatically.
Which action would you perform to achieve this?
You want the Automatic SQL Tuning process to stop accepting and implementing the recommended SQL profiles automatically.
Which action would you perform to achieve this?
정답: C
문제8
Evaluate the following command:
SQL> CREATE TABLE design_data (id NUMBER,
doc CLOB)
LOB(doc) STORE AS SECUREFILE(DEDUPLICATE);
Which statement is true regarding the above command?
Evaluate the following command:
SQL> CREATE TABLE design_data (id NUMBER,
doc CLOB)
LOB(doc) STORE AS SECUREFILE(DEDUPLICATE);
Which statement is true regarding the above command?
정답: C
설명: (KoreaDumps 회원만 볼 수 있음)
문제9
Which are the correct steps, in order, to deal with the loss of an online redo log if the database has not yet crashed?
a: Issue a checkpoint.
b: Shut down the database.
c: Issue an alter database open command to open the database.
d: Startup mount the database.
e: Issue an alter database clear logfile command.
f:
Recover all database datafiles.
Which are the correct steps, in order, to deal with the loss of an online redo log if the database has not yet crashed?
a: Issue a checkpoint.
b: Shut down the database.
c: Issue an alter database open command to open the database.
d: Startup mount the database.
e: Issue an alter database clear logfile command.
f:
Recover all database datafiles.
정답: B
문제10
To enable resumable space allocation for the instance, which of the following initialization parameters should you set to a nonzero value?
To enable resumable space allocation for the instance, which of the following initialization parameters should you set to a nonzero value?
정답: D
문제11
Which of the following calendaring syntax expressions would evaluate to the last day of every month?
Which of the following calendaring syntax expressions would evaluate to the last day of every month?
정답: B
설명: (KoreaDumps 회원만 볼 수 있음)
문제12
Which DBMS_SCHEDULER procedures can be used to enable a program? (Choose all that apply.)
Which DBMS_SCHEDULER procedures can be used to enable a program? (Choose all that apply.)
정답: D,E
설명: (KoreaDumps 회원만 볼 수 있음)
문제13
What are the prerequisites for performing flashback transactions? (Choose all that apply)
What are the prerequisites for performing flashback transactions? (Choose all that apply)
정답: A,C,D