Introduction to SQL The SQL statement that queries or reads data from a table is ________ . QUERY READ None of these SELECT QUERY READ None of these SELECT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The ADD command is used to enter one row of data or to add multiple rows as a result of a query. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL can be used to: query database data only. create database structures only. All of these modify database data only. query database data only. create database structures only. All of these modify database data only. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To sort the results of a query use: None of these SORT BY. ORDER BY. GROUP BY. None of these SORT BY. ORDER BY. GROUP BY. 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 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 SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following must be enclosed in double quotes? All of these Strings Column Alias Dates All of these Strings Column Alias Dates ANSWER DOWNLOAD EXAMIANS APP