Introduction to SQL Which of the following is valid SQL for an Index? ADD INDEX ID; CREATE INDEX ID; CHANGE INDEX ID; REMOVE INDEX ID; ADD INDEX ID; CREATE INDEX ID; CHANGE INDEX ID; REMOVE INDEX ID; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query is correct for using comparison operators in SQL? SELECT name, course_name FROM student WHERE age>50 and 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 WHERE age<80; SELECT name, course_name FROM student WHERE age>50 and 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 WHERE age<80; 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 Which SQL keyword is used to retrieve only unique values? DISTINCTIVE DISTINCT UNIQUE DIFFERENT DISTINCTIVE DISTINCT UNIQUE DIFFERENT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs TRUE Hi Nothing FLASE TRUE Hi Nothing FLASE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The keyword BETWEEN can be used in a WHERE clause to refer to a range of values. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS