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.

Practice Sql Miscellaneous Multiple Choice Questions Quiz-4

Q.1

A command that lets you change one or more fields in a record is

Insert
Modify
Look-up
All of the above

Q.2

Which of the SQL statements is correct?

SELECT Username AND Password FROM Users
SELECT Username, Password FROM Users
SELECT Username, Password WHERE Username = 'user1'
None of these

Q.3

The FROM SQL clause is used to...

specify what table we are selecting or deleting data FROM
specify range for search condition
specify search condition
None of these

Q.4

Which command undo all the updates performed by the SQL in the transaction?

ROLLBACK
COMMIT
TRUNCATE
DELETE

Q.5

Find all the cities whose humidity is 89

SELECT city WHERE humidity = 89;
SELECT city FROM weather WHERE humidity = 89;
SELECT humidity = 89 FROM weather;
SELECT city FROM weather;

Q.6

Find the temperature in increasing order of all cities

SELECT city FROM weather ORDER BY temperature;
SELECT city, temperature FROM weather;
SELECT city, temperature FROM weather ORDER BY temperature;
SELECT city, temperature FROM weather ORDER BY city;

Q.7

Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.
The SQL statement
SELECT COUNT(*) FROM Employee WHERE SALARY > ANY (SELECT SALARY FROM EMPLOYEE);
prints

Q.8

The SQL statement
SELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;
prints

Q.9

What is the meaning of LIKE '%0%0%'

Feature begins with two 0's
Feature ends with two 0's
Feature has more than two 0's
Feature has two 0's in it, at any position

Q.10

Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy

SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy');
SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy');
SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy');
SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy');

Q.11

The SQL statement
SELECT ROUND(45.926, -1) FROM DUAL;

is illegal
prints garbage
prints 045.926
prints 50

Q.12

Which of the following must be enclosed in double quotes?

Dates
Column Alias
Strings
All of the above

Q.13

Which of the following command makes the updates performed by the transaction permanent in the database?

ROLLBACK
COMMIT
TRUNCATE
DELETE

Q.14

Which SQL keyword is used to retrieve only unique values?

DISTINCTIVE
UNIQUE
DISTINCT
DIFFERENT

Q.15

Which SQL keyword is used to retrieve a maximum value?

TOP
MOST
UPPER
MAX

Q.16

What is a view?

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.
A view is a database diagram.
None of these

Q.17

Which of the following SQL commands is used to retrieve data?

DELETE
INSERT
SELECT
JOIN

Q.18

Which of the following is a SQL aggregate function?

LEFT
AVG
JOIN
LEN