Unit 2

Question 1

SQL requires the use of the INSERT command to enter data into a table.

Answer 1

Inserting rows

Question 2

command is used to list the contents of a table

Answer 2

Select statements

Question 3

is a set-oriented command

Answer 3

DELETE

Question 4

To add multiple rows to a table, using another table as the source of the data

Answer 4

INSERT

Question 5

standard SQL allows the use of special operators in conjunction with the WHERE clause

Answer 5

ANSI

Question 6

Used to check whether an attribute value is within a range

Answer 6

BETWEEN

Question 7

Used to check whether an attribute value is null

Answer 7

IS NULL

Question 8

Used to check whether an attribute value matches a given string pattern

Answer 8

LIKE

Question 9

Used to check whether an attribute value matches any value within a value list

Answer 9

IN

Question 10

Used to check whether a subquery returns any rows

Answer 10

EXISTS

Question 11

means any and all following or preceding characters are eligible

Answer 11

%

Question 12

means any single character may be substituted

Answer 12

_

Question 13

means any single character within a range or a set (sql server)

Answer 13

[]

Question 14

means any single character NOT within a range or a set. (sql server)

Answer 14

[^]

Question 15

means any single character within a range or a set (mysql)

Answer 15

REGEXP []

Question 16

means any single character NOT within a range or a set (mysql)

Answer 16

REGEXP [^]

Question 17

Many queries that would require the use of the logical OR can be more easily handled with the help of the special operator

Answer 17

IN

Question 18

special operator can be used whenever there is a requirement to execute a command based on the result of another query.

Answer 18

EXIST