Oracle 1Z0-072 問題集

質問 1：
The ORCL database has DEFERRED_SEGMENT_CREATION set to TRUE.
UNDOTBS2 is the active undo tablespace.
Examine these commands:

USER1 executes DML, which generates more than 2 MB of UNDO.
What is the result and why?
A. It returns an error because UNDOTBS2 has RETENTION GUARANTEE.
B. It suspends the transaction, which can be resumed by increasing USER1's quota on UNDOTBS2.
C. It returns an error because UNDOTBS2 is fixed size and has RETENTION GUARANTEE.
D. It suspends the transaction, which can be resumed by setting UNDOTBS1 as the active undo tablespace.
E. It suspends the transaction, which can be resumed by increasing the size of UNDOTBS2.
F. It returns an error because UNDOTBS2 is fixed size.
正解：F

質問 2：
Which two statements are true about VSTABLESPACE and DBA_ TABLESPACE?
A. VSTABLESPACE and DBA_ TABLESPACES are view based on base tables in the data dictionary.
B. VSTABLESPACE metadata is lost at shutdown, but DBA_ TABLESPACE metadata persists across shutdowns.
C. VSTABLESPACE is a dynamic view that is populated with data from the DBA_ TABLESPACES data queried only when a database is open.
D. VSTABLESPACE is a dynamic view that is populated with data from th DBA_ TABLESPACE dictionary view.
E. VSTABLESPACE cab be queries by all users, but DBA_ TABLESPACEs cab be queries only by SYSDBA users.
正解：A,B

質問 3：
Examine the command:
CREATE USER user1
IDENTIFIED BY user123
DEFAULT TEMPORARY TABLESPACE temp
QUOTA 5M ON system
PROFILE hr_user
PASSWORD EXPIRE;
Which two are true? (Choose two.)
A. USER1 requires a quota to be able to store objects in the default permanent tablespace.
B. The PASSWORD EXPIRE clause is invalid because passwords are controlled by the HR_USER profile.
C. A quota on the temporary tablespace must be specified to enable USER1 to perform queries and transactions.
D. USER1's account is locked.
E. USER1 will be prompted for a new passport at first login.
正解：A,C

質問 4：
Which two types of files are opened by a database instance in the NOMOUNT state?
A. data files
B. control files
C. the initialization parameter file
D. online redo logs
E. the alert log
正解：A,C

質問 5：
Which statement is true about an undo tablespace created using the Database Configuration Assistant (DBCA)?
A. It is used for the FLASHBACK TABLE...TO BEFORE DROP operation.
B. It is a locally managed tablespace.
C. It can be recovered while the instance is open in READ WRITE mode.
D. It contains undo only for uncommitted transactions.
E. It must be a smallfile tablespace.
正解：D,E

質問 6：
Which is always true about privileges?
A. The owner of a schema is granted all object privileges within the schema by default.
B. Connections as SYSTEM can use only the SYSOPER privilege.
C. The SYSDBA privilege can be granted to a user or role.
D. Connections as SYS must be made using the SYSDBA privilege
E. System privileges can be granted only to users.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Examine this extract from the show parameters command:

How are SGA and PGA memory managed by an instance using these parameter settings?
A. SGA memory is managed by using Automatic Shared Memory Management (ASMM) and PGA memory is managed by using Automated SQL Execution Memory Management.
B. SGA and PGA memory are manually managed.
C. SGA memory is manually managed and PGA memory is managed by using Automated SQL Execution Memory Management.
D. SGA memory is managed by using Automatic Shared Memory Management (ASMM) and PGA memory is manually managed.
E. SGA and PGA memory are managed by using Automatic Memory Management (AMM).
正解：E

質問 8：
Which two are true about Oracle recovery and data protection solutions? (Choose two.)
A. Oracle Data Guard can prevent data loss caused by a site failure.
B. Data Recovery Advisor can be used to restore a single file from an RMAN backupset.
C. Data Recovery Advisor can be used to validate backup strategies.
D. RMAN can be used to roll back committed transactions.
E. RMAN can be used to FLASHBACK a database.
正解：A,E

質問 9：
TBS1 is a permanent user-defined tablespace created with Oracle Managed Files (OMF).
Examine this command:
DROP TABLESPACE tbs1;
Which is required to ensure that TBS1 is dropped and its datafiles are deleted from their file system?
A. TBS1 must be placed in READ ONLY state.
B. TBS1 must not contain any temp files.
C. Objects in TBS1 must not be in use when the command is executed.
D. The INCLUDING CONTENTS AND DATAFILES clause must be added to the command.
E. DB_CREATE_FILE_DEST must refer to an Oracle Automatic Storage Management (ASM)disk group.
正解：D