单项选择题
Which is a valid CREATE TABLE statement?()
A. CREATE TABLE EMP9$# AS (empid number(2));
B. CREATE TABLE EMP*123 AS (empid number(2));
C. CREATE TABLE PACKAGE AS (packid number(2));
D. CREATE TABLE 1EMP_TEST AS (empid number(2));
相关考题
-
多项选择题
Which two are character manipulation functions?()
A. TRIM
B. REPLACE
C. TRUNC
D. TO_DATE
E. MOD
F. CASE -
多项选择题
Which three are true?()
A. A MERGE statement is used to merge the data of one table with data from another.
B. A MERGE statement replaces the data of one table with that of another.
C. A MERGE statement can be used to insert new rows into a table.
D. A MERGE statement can be used to update existing rows in a table. -
单项选择题
Evaluate this SQL statement: In the statement, which capabilities of a SELECT statement are performed?()
A. Selection, projection, join
B. Difference, projection, join
C. Selection, intersection, join
D. Intersection, projection, join
E. Difference, projection, product
