Oracle 1Z0-052 問題集

質問 1：
SQL> CREATE BIGFILE TABLESPACE MRKT
2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING
3 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT;
Database altered.
Which two statements are true regarding the MRKT tablespace? (Choose two.)
A. The tablespace can be dropped with the current setting with segments present in it.
B. Segment space is managed by free lists in the tablespace.
C. No more data files can be added to the tablespace.
D. A user created without being assigned a default tablespace uses this tablespace.
正解：C,D

質問 2：
The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command:

Which statement is true after HR issues the REVOKE command?
A. The command fails because SCOTT still has privileges.
B. The command fails because HR cannot revoke the privileges from JIM.
C. The command succeeds and privileges are revoked from JIM.
D. The command succeeds and only HR has the privilege to perform the SELECT, INSERT, and UPDATE operations on the EMP table.
正解：B

質問 3：
You have issued a SHUTDOWN ABORT command to bring down your database instance.
Consider the steps that will be performed later when you open the database:
1 . SGA is allocated.
2 . Control file is read.
3 . Redo log files are read.
4 . Instance recovery is started.
5 . Background processes are started.
6 . Data file headers are checked for consistency.
7 . Server parameter file or the initialization parameter file is read.
Which option has the correct order in which these steps occur?
A. 1, 7, 5, 4, 2, 3, 6
B. 1, 2, 3, 7, 5, 6, 4
C. 7, 1, 5, 2, 3, 6, 4
D. 7, 1, 4, 5, 2, 3, 6
正解：C

質問 4：
Which two statements are true about standard database auditing? (Choose two.)
A. Statements that refer to standalone procedure can be audited.
B. Operations by the users logged on as SYSDBA cannot be audited.
C. Only one audit record is ever created for a session per audited statement even though it is executed more than once.
D. DDL statements can be audited.
正解：A,D

質問 5：
View the Exhibit to examine the output for the CROSSCHECK BACKUP command.

Which statement is true about the output of the command?
A. The backup piece is expired because the retention period for the backup has expired
B. The backup piece is expired because the operating-system file was not found
C. The backup piece is expired as the new backup is available
D. The backup piece is expired because the backup set to which it belongs is not complete
正解：B
解説: (Topexam メンバーにのみ表示されます)