A. TRUE
B. FALSE
C. There is no default. It must be defined at creation time.
D.PENDING
E. NULL

A.Subqueries can contain GROUP BY and ORDER BY clauses 
B.Main query and subquery can get data from different tables 
C.Main query and subquery must get data from the same tables 
D.Subqueries can contain ORDER BY but not the GROUP BY clause 
E.Only one column or expression can be compared between the main query and subquery
F. Multiple columns or expressions can be compared between the main query and subquery

A. SET_ATTRIBUTE_NULL
B. ALTER_JOB
C. ALTER_JOB_PARAMETERS
D. ALTER
E. SET_ATTRIBUTE

A. DBA_SCHEDULER_JOB_RUN_DETAILS
B. DBA_SCHEDULER_RUNNING_JOBS DBA
C. DBA_SCHEDULER_CURRENT_JOBS
D. DBA_SCHEDULER_JOBS DBA
E. DBA_SCHEDULER_EXECUTING_JOBS

A.Synonyms can be created only for a table 
B.Synonyms are used to reference only those tables that are owned by another user 
C.A public synonym and a private synonym can exist with the same name for the same table 
D.The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid

A. FREQ
B. BYHOUR
C. RUNDATE
D. INTERVAL
E. BYMINUTE

A.It can be used to join a maximum of three tables 
B.It can be used to restrict the number of columns used in a NATURAL join 
C.It can be used to access data from tables through equijoins as well as nonequijoins 
D.It can be used to join tables that have columns with the same name and compatible data types

A. ENABLE启用
B. ENABLE_PROGRAM
C. VALIDATE_PROGRAM
D. SET_ATTRIBUTE设置属性
E. SET_ENABLED

A. SET_JOB_ARGUMENT_VALUE
B. SET_JOB_VALUE_ANYDATA
C. SET_JOB_ANYDATA_VALUE
D. SET_SPECIAL_JOB_VALUE
E. SET_JOB_ANYTYPE_VALUE

A.All data along with the table structure is deleted 
B.The pending transaction in the session is committed 
C.All indexes on the table will remain but they are invalidated 
D.All views and synonyms will remain but they are invalidated 
E.All data in the table are deleted but the table structure will remain