Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL You can add a row using SQL in a database with which of the following? ADD MAKE INSERT CREATE ADD MAKE INSERT CREATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to remove rows from a table 'CUSTOMER' is: REMOVE FROM CUSTOMER ... UPDATE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... DROP FROM CUSTOMER ... REMOVE FROM CUSTOMER ... UPDATE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... DROP FROM CUSTOMER ... ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The rows of the result relation produced by a SELECT statement can be sorted, but only by one column. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Indexes may be created or dropped at any time. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Count function in SQL returns the number of groups. values. distinct values. columns. groups. values. distinct values. columns. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS