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 Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);prints 5 9 0 10 5 9 0 10 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The benefits of a standard relational language include which of the following? All of these Increased dependence on a single vendor Applications are not needed Reduced training costs All of these Increased dependence on a single vendor Applications are not needed Reduced training costs 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 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; SELECT name, course_name FROM student WHERE age>50 and age <80; SELECT name, course_name FROM student WHERE age>50 and <80; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a ________ . file table report form file table report form ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Indexes can usually be created for both primary and secondary keys. True False True False ANSWER DOWNLOAD EXAMIANS APP