多项选择题

Which three statements about subqueries are true? （）

A.Asinglerowsubquerycanretrieveonlyonecolumnandonerow.
B.Asinglerowsubquerycanretrieveonlyonerowbutmanycolumns.
C.Amultiplerowsubquerycanretrievemultiplerowsandmultiplecolumns.
D.Amultiplerowsubquerycanbecomparedusingthe"；>；"；operator.
E.AsinglerowsubquerycanusetheINoperator.
F.Amultiplerowsubquerycanusethe"；="；operator.

点击查看答案&解析

上一题目录下一题

相关考题

单项选择题

Which view should a user query to display the columns associated with the constraints on a table owned by the user?（）

A.USER_CONSTRAINTS
B.USER_OBJECTS
C.ALL_CONSTRAINTS
D.USER_CONS_COLUMNS
E.USER_COLUMNS

多项选择题

Evaluate the SQL statement
DROP TABLE DEPT;
Which four statements are true of the SQL statement? （）

A.You cannot roll back this statement.
B.All pending transactions are committed.
C.All views based on the DEPT table are deleted.
D.All indexes based on the DEPT table are dropped.
E.All data in the table is deleted, and the table structure is also deleted.
F.All data in the table is deleted, but the structure of the table is retained.
G.All synonyms based on the DEPT table are deleted.

单项选择题

Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）

A.SELECT ename, salary*12 'Annual Salary' FROM employees;
B.SELECT ename, salary*12 "Annual Salary" FROM employees;
C.SELECT ename, salary*12 AS Annual Salary FROM employees;
D.SELECT ename, salary*12 AS INITCAP("ANNUAL SALARY") FROM employees