多项选择题
Which two statements are true regarding the USING clause in table joins?()
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
相关考题
-
多项选择题
Which DBMS_SCHEDULER procedures can be used to enable a program?()
A. ENABLE启用
B. ENABLE_PROGRAM
C. VALIDATE_PROGRAM
D. SET_ATTRIBUTE设置属性
E. SET_ENABLED -
单项选择题
When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?()
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 -
多项选择题
YouissuedthefollowingcommandtodropthePRODUCTStable:SQL>DROPTABLEproducts;Whatistheimplicationofthiscommand?()
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
