Introduction to SQL 'AS' clause is used in SQL for Projection operation. Selection operation. Join operation. Rename operation. Projection operation. Selection operation. Join operation. Rename operation. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a SQL aggregate function? LEFT AVG JOIN LEN LEFT AVG JOIN LEN 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 <80; 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; None of these SELECT name, course_name FROM student WHERE age>50 and <80; SELECT name, course_name FROM student WHERE age>50 and age <80; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? LIKE operator None of these EXISTS operator BETWEEN operator LIKE operator None of these EXISTS operator BETWEEN operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which one of the following sorts rows in SQL? SORT BY ORDER BY ALIGN BY GROUP BY SORT BY ORDER BY ALIGN BY GROUP BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS