The SQL ALTER statement can be used to:

Select one:

a. change the table structure.

b. change the table data.

c. add rows to the table.

d. delete rows from the table.

Clear my choice

Question 17

Not yet answered

Marked out of 1.00

Flag question

Question text

Data analysis begins with the statement of data design.

Select one:

True

False

Question 18

Not yet answered

Marked out of 1.00

Flag question

Question text

What type of join is needed when you wish to include rows that do not have matching values?

Select one:

a. Equi-join

b. Natural join

c. Outer Join

d. All of the above

Clear my choice

Question 19

Not yet answered

Marked out of 1.00

Flag question

Question text

Which of the following SQL data types should not be used to define the numeric data: 111.11?

Select one:

a. integer(3,2)

b. numeric(3,2)

c. numeric(4,2)

d. numeric(5,2)

Clear my choice

Question 20

Not yet answered

Marked out of 1.00

Flag question

Question text

Which of the following is wrong?

Select one:

a. If A BC, then A B and B C

b. If A B and B C, then A C

c. If A B and A C, then A BC

d. If A B and C is another attribute, then AC BC