최신Oracle Database 11g: Administration II - 1Z0-053무료샘플문제
문제1
Which two initialization parameters would you set to enable Automatic Shared Memory Management? (Choose two.)
Which two initialization parameters would you set to enable Automatic Shared Memory Management? (Choose two.)
정답: B,C
문제2
Your database initialization parameter file has the following entry:
SEC_MAX_FAILED_LOGIN_ATTEMPTS=3
Which statement is true regarding this setting?
Your database initialization parameter file has the following entry:
SEC_MAX_FAILED_LOGIN_ATTEMPTS=3
Which statement is true regarding this setting?
정답: B
문제3
You set the following parameters in the parameter file and restarted the database:
MEMORY_MAX_TARGET=0
MEMORY_TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Which two statements are true regarding these parameters after the database instance is restarted? (Choose two.)
You set the following parameters in the parameter file and restarted the database:
MEMORY_MAX_TARGET=0
MEMORY_TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Which two statements are true regarding these parameters after the database instance is restarted? (Choose two.)
정답: B,C
문제4
When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics.
Which two statements describe the implications of this? (Choose two.)
When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics.
Which two statements describe the implications of this? (Choose two.)
정답: B,C
문제5
To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used? (Choose all that apply.)
To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used? (Choose all that apply.)
정답: B,C
설명: (ExamPassdump 회원만 볼 수 있음)
문제6
Which of the following describes how a distributed resumable transaction behaves?
Which of the following describes how a distributed resumable transaction behaves?
정답: B
문제7
A user named Arren is executing this query:
select table_name, operation, undo_sql
from flashback_transaction_query t, (select versions_xid as xid from employees versions between scn minvalue and maxvalue where employee_id = 123) e where t.xid = e.xid;
When the query runs, he receives an ORA-01031: insufficient privileges error. Since the user owns the employees table, you know that it is not the problem.
Which of the following SQL statements will correct this problem?
A user named Arren is executing this query:
select table_name, operation, undo_sql
from flashback_transaction_query t, (select versions_xid as xid from employees versions between scn minvalue and maxvalue where employee_id = 123) e where t.xid = e.xid;
When the query runs, he receives an ORA-01031: insufficient privileges error. Since the user owns the employees table, you know that it is not the problem.
Which of the following SQL statements will correct this problem?
정답: C
문제8
View the Exhibit and note the contents of V$DIAG_INFO.
Which statement is true about the ADR?
Exhibit:
View the Exhibit and note the contents of V$DIAG_INFO.
Which statement is true about the ADR?
Exhibit:
정답: B
설명: (ExamPassdump 회원만 볼 수 있음)
문제9
You can back up the RMAN recovery catalog with RMAN.
You can back up the RMAN recovery catalog with RMAN.
정답: A
설명: (ExamPassdump 회원만 볼 수 있음)
문제10
To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file? (Choose two.)
To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file? (Choose two.)
정답: B,C
문제11
Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query?
Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query?
정답: B