Introduction to SQL Which of the following must be enclosed in double quotes? All of these Dates Strings Column Alias All of these Dates Strings Column Alias ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Count function in SQL returns the number of groups. distinct values. columns. values. groups. distinct values. columns. values. 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 columns rather than groups. Acts like a WHERE clause but is used for rows rather than columns. 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 columns rather than groups. Acts like a WHERE clause but is used for rows rather than columns. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs FLASE TRUE Hi Nothing FLASE TRUE Hi Nothing ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query is correct for using comparison operators in SQL? None of these SELECT name, course_name FROM student WHERE age>50 and age <80; SELECT name, course_name FROM student WHERE age>50 and WHERE age<80; SELECT name, course_name FROM student WHERE age>50 and <80; None of these SELECT name, course_name FROM student WHERE age>50 and age <80; SELECT name, course_name FROM student WHERE age>50 and WHERE age<80; SELECT name, course_name FROM student WHERE age>50 and <80; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL data definition commands make up a(n) ________ . DDL HTML DML XML DDL HTML DML XML ANSWER DOWNLOAD EXAMIANS APP