30 MARCH 2021 CURRENT AFFAIRS QUIZ

5

0

10

9

False

True

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

SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');

SELECT NAME IN CUSTOMER WHERE STATE = 'V';

SELECT NAME IN CUSTOMER WHERE STATE = 'VA';

True

False

table

report

form

file

A view is a special stored procedure executed when certain event occurs.

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.

None of these

A view is a database diagram.

True

False

None of these

specify search condition

specify what table we are selecting or deleting data FROM

specify range for search condition

Non-Equijoin

None of these

Equijoin

Self-Join

SELECT * FROM weather WHERE temperature NOT IN (71 and 89);

SELECT * FROM weather WHERE temperature NOT IN (71 to 89);

SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;

SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89;