Introduction to SQL The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column. 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
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. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM Employee WHERE SALARY > ANY (SELECT SALARY FROM EMPLOYEE);prints 5 9 10 0 5 9 10 0 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What operator tests column for the absence of data? None of these NOT operator IS NULL operator EXISTS operator None of these NOT operator IS NULL operator EXISTS operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a SQL aggregate function? LEFT JOIN AVG LEN LEFT JOIN AVG LEN ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS