OMIS 452- Quiz 2 (Module 3.0 SQL) Questions and Answers

OMIS 452- Quiz 2 (Module 3.0 SQL) Questions and
Answers
3
Save


Practice questions for this set


Learn 1 /7 Study with Learn




The statement DROP Employee; deletes the Employee table.



Choose an answer



1 TRUE 2 FALSE



Don't know?




Terms in this set (58)

, SQL commands can create TRUE
databases and tables.
True
False

A database designer and TRUE
database user both use SQL.
True
False

All database systems use FALSE
identical SQL statements.

The INSERT statement adds a 2
student to the Student table.
How many clauses are in the
INSERT statement?


INSERT INTO Student
VALUES (888, 'Smith', 'Jim', 3.0);

The SQL statement below is the literal "Smith" must be surrounded by single quotes or double
used to select students with the quotes
last name "Smith". What is wrong
with the statement?


SELECT FirstName
FROM Student
WHERE LastName = Smith;