Unit2

Question 1

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

Answer 1

Insert

Question 2

Thus far, you have entered rows in which all of the attribute values are specified. But what do you do if a column does not have any available data? In those cases, you would want to leave the column with a valuer of null.

Answer 2

Inserting Rows with Null Attributes

Question 3

There might be occasions when more than one attribute is optional. Rather than declaring each attribute as NULL in the INSERT command, you can indicate just the attributes that have required values. You do that by listing the attribute names inside parentheses after the table name.

Answer 3

Inserting Rows with Optional Attributes

Question 4

The ______ command is used to list the contents of a table.

Answer 4

Select statements

Question 5

list all attributes. A wildcard character is a symbol that can be used as a general substitute for other characters or commands.

Answer 5

*

Question 6

Use the _____ command to modify data in a table.

Answer 6

Update statements

Question 7

It is easy to delete a table row using the _____;

Answer 7

Delete statements

Question 8

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

Answer 8

Inserting Rows from another table

Question 9

Selecting Rows with Conditional Restrictions

Answer 9

Select Queries

Question 10

SQL accepts any valid expressions (or formulas) in the computed columns. Such formulas can contain any valid mathematical operators and functions that are applied to attributes in any of the tables specified in the FROM clause of the SELECT statement.

Answer 10

Computed Columns

Question 11

An alias is an alternative name given to a column or table in any SQL statement

Answer 11

Aliases

Question 12

is a function that returns the current system date in sql server

Answer 12

getdate()

Question 13

is a TSQL function that add a particular date interval from a given column or value. Its accepts the following parameters

Answer 13

dateadd()

Question 14

is a function that returns the current system date in mysql

Answer 14

curdate()

Question 15

is a MySQL function that subtracts a particular date interval from a given column or value. Its accepts the following parameters

Answer 15

date_sub

Question 16

if both conditions are true

Answer 16

AND

Question 17

if at least one of the condition is true

Answer 17

OR

Question 18

if we want to negate the result of a conditional expression.

Answer 18

NOT

Question 19

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

Answer 19

ANSI

Question 20

Used to check whether an attribute value is within a range

Answer 20

BETWEEN

Question 21

Used to check whether an attribute value is null

Answer 21

IS NULL

Question 22

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

Answer 22

LIKE

Question 23

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

Answer 23

IN

Question 24

Used to check whether a subquery returns any rows

Answer 24

EXISTS

Question 25

________ may be used to check whether an attribute value is within a range of values

Answer 25

BETWEEN

Question 26

——- to check for a null attribute value

Answer 26

IS NULL

Question 27

The _____ special operator is used in conjunction with wildcards to find patterns within string attributes.

Answer 27

LIKE

Question 28

means any and all following or preceding characters are eligible

Answer 28

%

Question 29

means any single character may be substituted for the underscore.

Answer 29

_

Question 30

means any single character within a range or a set.

Answer 30

[]

Question 31

means any single character NOT within a range or a set.

Answer 31

[^]

Question 32

means any single character within a range or a set.

Answer 32

REGEXP []

Question 33

means any single character NOT within a range or a set

Answer 33

REGEXP [^]

Question 34

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

Answer 34

IN

Question 35

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

Answer 35

EXISTS