Introduction to SQL
The HAVING clause does which of the following?

Acts like a WHERE clause but is used for groups rather than rows.
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 columns rather than groups.

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 WHERE age<80;
None of these
SELECT name, course_name FROM student WHERE age>50 and <80;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
A view is which of the following?

A base table that cannot be accessed via SQL commands
A virtual table that can be accessed via SQL commands
A base table that can be accessed via SQL commands
A virtual table that cannot be accessed via SQL commands

ANSWER DOWNLOAD EXAMIANS APP