Oracle 1Z0-053 問題集

質問 1：
Which two initialization parameters would you set to enable Automatic Shared Memory Management? (Choose two.)
A. set DB_CACHE_SIZE to a non-zero value
B. set SGA_TARGET to a non-zero value
C. set SHARED_POOL_SIZE to zero
D. set STATISTICS_LEVEL to TYPICAL or ALL
E. set STATISTICS_LEVEL to BASIC
正解：B,C

質問 2：
If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode, what will be the result when you issue the command alter database archivelog?
A. The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG mode.
B. There is no alter database archivelog command. The correct command is alter database alterlogging.
C. The alter database archivelog command will fail.
D. The alter database archivelog command will succeed.
E. The alter database archivelog command will ask if you want to make the database consistent first.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?
A. It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.
B. It returns space usage of only BasicFile LOB chunks.
C. It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.
D. It returns space usage of only SecureFile LOB chunks.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance.
Which statement is true while performing a tape backup in an RMAN session?
A. The tape buffer is allocated from the Program Global Area (PGA)
B. Oracle I/O uses an interrupt mechanism to determine when each I/O completes
C. The tape I/O performed is asynchronous
D. The tape buffer is allocated from the System Global Area (SGA)
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 5：
True or false: RMAN offers the equivalent of the SQL command alter database backup controlfile to trace.
A. False
B. True
正解：A

質問 6：
Which DBMS_SCHEDULER procedures can be used to enable a program? (Choose all that apply.)
A. VALIDATE_PROGRAM
B. ENABLE
C. ENABLE_PROGRAM
D. SET_ENABLED
E. SET_ATTRIBUTE
正解：B,E
解説: (Topexam メンバーにのみ表示されます)

質問 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. GRANT SELECT_ANY_TRANSACTION TO ARREN;
B. GRANT FLASHBACK TO ARREN;
C. GRANT SELECT ANY TRANSACTION TO ARREN;
D. GRANT SELECT ANY VIEW TO ARREN;
E. GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARREN;
正解：C

質問 8：
What is the purpose of the until change option of the restore command?
A. It allows you to select the timestamp you want to restore to.
B. It allows you to manually stop the restore at any time as online redo logs are applied.
C. It allows you to select the SCN that you want to restore to.
D. None of the above.
E. It allows you to select the log sequence number you want to restore to.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 9：
Which of these formats represents the correct hierarchy for the ADR?
A. <diagnostic_dest>/diag/rdbms/<dbname>/<instname>
B. <diagnostic_dest>/diag/rdbms/<instname>/<dbname>
C. <diagnostic_dest>/rdbms/diag/<dbname>/<instname>
D. None of the above
正解：A
解説: (Topexam メンバーにのみ表示されます)