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 What operator tests column for the absence of data? IS NULL operator None of these NOT operator EXISTS operator IS NULL operator None of these NOT operator EXISTS operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a valid SQL type? FLOAT NUMERIC CHARACTER All of these FLOAT NUMERIC CHARACTER All of these 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? 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; 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; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to remove rows from a table 'CUSTOMER' is: REMOVE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... UPDATE FROM CUSTOMER ... DROP FROM CUSTOMER ... REMOVE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... UPDATE FROM CUSTOMER ... DROP FROM CUSTOMER ... ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The benefits of a standard relational language include which of the following? All of these Increased dependence on a single vendor Reduced training costs Applications are not needed All of these Increased dependence on a single vendor Reduced training costs Applications are not needed ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS