Introduction to SQL Which of the following SQL commands can be used to add data to a database table? APPEND INSERT UPDATE ADD APPEND INSERT UPDATE ADD ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. ONLY UNIQUE SINGLE DISTINCT ONLY UNIQUE SINGLE DISTINCT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The HAVING clause does which of the following? Acts EXACTLY like a WHERE clause. Acts like a WHERE clause but is used for groups rather than rows. Acts like a WHERE clause but is used for rows rather than columns. Acts like a WHERE clause but is used for columns rather than groups. Acts EXACTLY like a WHERE clause. Acts like a WHERE clause but is used for groups rather than rows. Acts like a WHERE clause but is used for rows rather than columns. Acts like a WHERE clause but is used for columns rather than groups. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Select the right statement to insert values to the student table. INSERT student VALUES ( INSERT INTO student VALUES ( INSERT VALUES INTO student ( INSERT VALUES ( INSERT student VALUES ( INSERT INTO student VALUES ( INSERT VALUES INTO student ( INSERT VALUES ( ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS