SQL

Question 1

The command to eliminate a table from a database is:

Answer 1

Correct Answer: DROP TABLE CUSTOMER;

Question 2

The SQL keyword(s) ________ is used with wildcards.

Answer 2

Correct Answer: LIKE only

Question 3

A view is ……….?

Answer 3

A virtual table that can be accessed via SQL commands

Question 4

The wildcard in a WHERE clause is useful when?

Answer 4

An exact match is not possible in a SELECT statement.

Question 5

Name five built-in functions provided by SQL?

Answer 5

COUNT, SUM, AVG, MAX, MIN

Question 6

A subquery in an SQL SELECT statement is enclosed in:

Answer 6

parenthesis – (…) .

Question 7

The result of a SQL SELECT statement is a(n) form/table/row/array

Answer 7

table

Question 8

Which of the following is NOT a SQL keyword or SQL clause?

insert/update/invert/limit

Answer 8

invert

Question 9

Which SQL function is used to count the number of rows in a SQL query?

Answer 9

COUNT()

Question 10

Which of the following is valid SQL for an Index?

Add index/Create index/let index

Answer 10

CREATE INDEX ID;

Question 11

When three or more AND and OR conditions are combined, it is

easier to use the SQL keyword(s):

Answer 11

Both IN and NOT IN.

Question 12

A subquery in an SQL SELECT statement:

a) has a table having query
b) has a distinct form that cannot be duplicated by a join.
c) has a view

Answer 12

has a distinct form that cannot be duplicated by a join.

Question 13

SQL query and modification commands make up a(n) ________ .

Answer 13

DML

Question 14

The HAVING clause does which of the following?

Answer 14

Acts like a WHERE clause but is used for groups rather than rows.

Question 15

When the SQL keyword BETWEEN is used?

Answer 15

for ranges.

Question 16

SELECT 12 * 2 + 24;

Answer 16

48

Question 17

Do the following statements return the same or different output?
SELECT * FROM EMPLOYEES;
Select * from employees;
select * FROM employees;

Answer 17

Same output

Question 18

Which of the following is not a SQL transaction statement?

insert/rollback/commit

Answer 18

insert

Question 19

Question: 8 Which of the following is a valid way to add comments to a SQL statement?

a) – this is comment
b) //this is comment
c) –> this is comment

Answer 19

a)– this is comment

Question 20

What does the ALTER TABLE statement do?

Answer 20

Use to change the structure of an existing table.