Introduction to SQL Which SQL statement is used to update data in a database? UPDATE SAVE AS SAVE MODIFY UPDATE SAVE AS SAVE MODIFY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To sort the results of a query use: None of these ORDER BY. GROUP BY. SORT BY. None of these ORDER BY. GROUP BY. SORT BY. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To define what columns should be displayed in an SQL SELECT statement: use SELECT to name the source table(s) and list the columns to be shown after USING. use USING to name the source table(s) and list the columns to be shown after WHER use USING to name the source table(s) and list the columns to be shown after SELECT. use FROM to name the source table(s) and list the columns to be shown after SELECT. use SELECT to name the source table(s) and list the columns to be shown after USING. use USING to name the source table(s) and list the columns to be shown after WHER use USING to name the source table(s) and list the columns to be shown after SELECT. use FROM to name the source table(s) and list the columns to be shown after SELECT. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is illegal? SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; SELECT SYSDATE - SYSDATE FROM DUAL; None of these SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; SELECT SYSDATE - SYSDATE FROM DUAL; None of these SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL COUNT(field_name) tallies only those rows that contain a value; it ignores all null values. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? LIKE operator BETWEEN operator None of these EXISTS operator LIKE operator BETWEEN operator None of these EXISTS operator ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS