30.Which three are types of segments in an Oracle Database?
A.clusters
B.sequences
C.stored procedures
D.views
E.undo
F.tables
答案：AEF
31.Which two statements are true about the SET VERIPY ON command?
A.It displays values for variables prefixed with &&
B.It displays values for variables created by the DEFINE command
C.It can be used in SQL Developer and SQLPlus
D.It can be used only in SQLPlus
E.It displays values for variables used only in the WHERE clause of a query
答案：BC
32.Which are two of the account management capabilities that can be configured using Oracle profiles?
A.the number of days for which an account may be logged in to one or more sessions before it is locked
B.the number of days for which an account may be inactive before it is locked
C.the maximum number of sessions permitted for a user before the password must be changed D.the ability to prevent a password from ever being reused
E.the maximum amount of cpu time allowed for a users sessions before their account is locked
答案：BD
33.Which three statements are true regarding single row subqueries?
A.They must be placed on the left side of the comparison operator or condition
B.They must return a row to prevent errors in the SQL statement
C.They can be used in the HAVING clause.
D.A SQL statement may have multiple single row subquery blocks
E.They can be used in the WHERE clause
F.They must be placed on the right side of the comparison operator or condition
答案：CDE
34.You execute this command:
During the export operation, you detach from the job by using crtl+c and then execute this command
Export> STOP JOB =immediate
Are you sure you wish to stop the job ( [yes] /no): yes
Which two statements are true about the job?
A.You can reattach to it and monitor it
B.You can reattach to it but not monitor it
C.It terminates
D.It continues to run in the backaround
E.It is paused and can be resumed
答案： AE
35.Which three statements are true about the Automatic Diagnostic Repository (ADR)?
A.It is a file-based repository held outside any database
B.The ADR base is specified in the DIAGNOSTIC DEST database paramete
C.It is only used for Oracle Database diagnostic information
D.It is held inside an Oracle database schema
E.It can be used for problem diagnosis of a database when that database’s instance is down
答案： ABE
C不对，数据库、Oracle自动存储管理（Oracle ASM）、侦听器、Oracle Clusterware和其他Oracle产品或组件将所有诊断数据存储在ADR中
