多項選擇題

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

單項選擇題

Which clause should you use to exclude group results?（）

A.WHERE
B.HAVING
C.RESTRICT
D.GROUP BY
E.ORDER BY

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

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

你可能感興趣的試題

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

Which clause should you use to exclude group results?（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

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