Introduction to SQL There is an equivalent join expression that can be substituted for all subquery expressions. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a ________ . file table report form file table report form ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Indexes may be created or dropped at any time. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? ROLLBACK DELETE COMMIT TRUNCATE ROLLBACK DELETE COMMIT TRUNCATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query finds the names of the sailors who have reserved at least one boat? SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid; None of These SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid; None of These ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS