Oracle 1Z0-072 問題集

質問 1：
What three are true about Oracle Flashback technology? (Choose three.)
A. FLASHBACK TRANSACTION can be used to undo the changes made by a committed transaction.
B. FLASHBACK DATABASE can be used to rewind a database back and forth in time.
C. FLASHBACK QUERY can be used to view committed data at any given point in time.
D. FLASHBACK TABLE can be used to undo dropping a column from a table.
E. FLASHBACK TABLE can be used to rewind a table back in time.
正解：A,B,D

質問 2：
Which two are true about RETENTION GUARANTEE? (Choose two.)
A. It prevents FLASHBACK DATABASE operation failure.
B. It prevents "Snapshot too old" errors.
C. It prevents out-of-space errors.
D. It is a tablespace attribute.
E. It is a static parameter.
正解：A,D

質問 3：
EMP_IDX is an index on the EMP.ENO column.
EMP and EMP_IDX reside in the TBS1 tablespace.
During an INSERT into EMP, you get this error:
ERROR at line 1:
ORA-01654: unable to extend index USERS.EMP_IDX BY 8 in tablespace TBS1 Which two actions would you take to correct the space problem in TBS1 without affecting uncommitted transactions on EMP? (Choose two.)
A. Shrink EMP.
B. Drop and re-create EMP_IDX.
C. Coalesce EMP_IDX.
D. Rebuild EMP_IDX online in a tablespace with sufficient space.
E. Shrink TBS1.
正解：B,C

質問 4：
Which three types of files are created by expdp operations? (Choose three.)
A. control files
B. SQL files
C. reject files
D. log files
E. dump files
F. bad files
G. input data files
正解：B,D,E

質問 5：
Examine this command and its partial output:

Why does the DB01.abc.com service show unknown status?
A. The service is dynamically registered.
B. The LOCAL_LISTENER parameter list does not contain LISTENER_1.
C. The service is statically registered.
D. The listener does not listen on the default port 1521.
E. The SID_LIST_LISTENER section is missing in the LISTENER.ORA file.
正解：E

質問 6：
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

質問 7：
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

質問 8：
Your database is configured for shared server and the SGA_TARGET parameter is set to a non-zero value.
Which three actions could help in handling a large number of concurrent users?
A. increasing the size of the PGA
B. setting the LARGE_POOL_SIZE parameter to a non-zero value
C. increasing the number of dispatchers
D. using Automatic SGA Memory Management (ASMM)
E. setting the SHARED_POOL_SIZE parameter to a non-zero value
正解：A,B,E

質問 9：
Which two are true about roles? (Choose two.)
A. The SET ROLE statement can be used once per session.
B. The SET ROLE statement enables as well as disables roles in a session.
C. All privileges and roles granted to a user are enabled by default when the user logs in.
D. A role must be disabled before it can be revoked from a user.
E. The ALTER USER statement must be used to set specific default roles for a user.
正解：B,C