多项选择题

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

多项选择题

You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）

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