单项选择题
Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed? （）
A. 46 and 45 B. 46 and 45.93 C. 50 and 45.93 D. 50 and 45.9 E. 45 and 45.93 F. 45.95 and 45.93
Which SQL statement accepts user input for the columns ...
单项选择题Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition? （）
A. SELECT &1, "&2" FROM &3 WHERE last_name = '&8'; B. SELECT &1, '&2' FROM &3 WHERE '& last_name = '&8'; C. SELECT &1, &2 FROM &3 WHERE last_name = '&8'; D. SELECT &1, '&2' FROM EMP WHERE last_name = '&8';
Which two statements are true about WHERE and HAVING cl...
多项选择题Which two statements are true about WHERE and HAVING clauses? （）
A. A WHERE clause can be used to restrict both rows and groups. B. A WHERE clause can be used to restrict rows only. C. A HAVING clause can be used to restrict both rows and groups. D. A HAVING clause can be used to restrict groups only. E. A WHERE clause CANNOT be used in a query of the query uses a HAVING clause. F. A HAVING clause CANNOT be used in subqueries.
Which two statements about creating constraints are tru...
多项选择题Which two statements about creating constraints are true?（）
A. Constraint names must start with SYS_C B. All constraints must be defines at the column level. C. Constraints can be created after the table is created. D. Constraints can be created at the same time the table is created. E. Information about constraints is found in the VIEW_CONSTRAINTS dictionary view.
