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 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;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
NULL is

the same as blank for character
not a value
the same as 0 for integer
the same as 0 for integer and blank for character

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';

SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');
SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
SELECT NAME IN CUSTOMER WHERE STATE = 'V';
SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
What is a view?

None of these
A view is a database diagram.
A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are.
A view is a special stored procedure executed when certain event occurs.

ANSWER DOWNLOAD EXAMIANS APP