CSC345 Week 3 Module 3 Quiz

Which of the following does NOT NULL indicate? a. Column must not be void. b. Column must have a value including void value. c. Column must have a value including blank. d. Column must have a value including zero.

a. Column must not be void.

Which of the following SQL statement is valid? a. INSERT INTO SALES_REP VALUES ('25', 'Donna', 'Sanchez'); b. DELETE SALES_REP; c. DROP TABLE SALES_REP; d. UPDATE SALES_REP LAST_NAME = 'Austin'; e. All of the above. f. None of the above.

a. INSERT INTO SALES_REP VALUES ('25', 'Donna', 'Sanchez');

Which of the following is not a valid SQL command? a. UPDATE b. SHOW c. SELECT d. INSERT e. All of the above f. None of the above

b. SHOW

Which command is used to work within a specific database in Oracle? a. SELECT DATABASE b. USE DATABASE c. DEFAULT DATABASE d. All of the above. e. None of the above.

b. USE DATABASE

Which of the following removes a table from a database? a. DELETE b. REMOVE c. DROP d. ERASE e. All of the above f. None of the above

c. DROP

Which of the following SQL statements is valid for MySQL, Oracle, and MS SQL Server? a. CREATE TABLE sales_rep (id NUMBER(2), name CHAR (30)); b. CREATE TABLE sales_rep (id CHAR(2), name VARCHAR(30)); c. CREATE TABLE sales_rep (id NUMBER, name VARCHAR2(30)); d. CREATE TABLE sales_rep (id CHAR(2), name CHAR(30)); e. All of the above. f. None of the above.

d. CREATE TABLE sales_rep (id CHAR(2), name CHAR(30));

Which of the following commands list columns of a table in MS SQL? a. DESCRIBE b. DESC c. EXEC SP_TABLE d. EXEC SP_COLUMNS e. All of the above. f. None of the above.

d. EXEC SP_COLUMNS

Which of the following SQL statements is valid? a. SELECT all FROM sales_rep; b. SELECT * FROM SALES_REP c. SELECT all FROM SALES_REP d. SELECT * FROM sales_rep; e. All of the above. f. None of the above.

d. SELECT * FROM sales_rep;

Which of the following commands list existing databases in Oracle? a. LIST DATABASES b. SHOW DATABASES c. DISPLAY DATABASES d. All of the above e. None of the above

e. None of the above

Which command is used to list all columns in MS SQL Server? a. DESCRIBE b. SELECT c. SHOW d. LIST e. All of the above f. None of the above

f. None of the above