Introduction to SQL Which one of the following sorts rows in SQL? ALIGN BY GROUP BY ORDER BY SORT BY ALIGN BY GROUP BY ORDER BY SORT BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What operator tests column for the absence of data? None of these IS NULL operator EXISTS operator NOT operator None of these IS NULL operator EXISTS operator NOT operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands can be used to add data to a database table? UPDATE APPEND INSERT ADD UPDATE APPEND INSERT ADD 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 10 5 9 0 10 5 9 0 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following must be enclosed in double quotes? Dates All of these Column Alias Strings Dates All of these Column Alias Strings ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS