Introduction to SQL Which of the following group functions ignore NULL values? SUM All of these COUNT MAX SUM All of these COUNT MAX ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Select the right statement to insert values to the student table. INSERT VALUES ( INSERT INTO student VALUES ( INSERT VALUES INTO student ( INSERT student VALUES ( INSERT VALUES ( INSERT INTO student VALUES ( INSERT VALUES INTO student ( INSERT student VALUES ( 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 WHERE age<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 <80; SELECT name, course_name FROM student WHERE age>50 and WHERE age<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 <80; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ________ was adopted as a national standard by ANSI in 1992. Microsoft Access DBase SQL Oracle Microsoft Access DBase SQL Oracle ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. SINGLE DISTINCT ONLY UNIQUE SINGLE DISTINCT ONLY UNIQUE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of every SQL query is a table. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS