1. A create view statement creates a new table with its on data using the view select query.

True

False

2. An alter table statement:

a. will delete table values when a column is removed

b. can be used to set a default value

c. allows the creation of a new column in a table

d. all of these are true

3. A view is updateable if the defining query has:

a. a FROM clause that specifies more than one table

b. has a GROUP BY or HAVING clause

c. a FROM clause that specifies a single table

d. a where clause with a sub query that references a table from the FROM clause

4. If a table's primary key contains multiple columns, it must be defined in the create table statement using a table constraint.

True or false

5. If two tables A and B need to have mutual foreign key references, each foreign key constraint can be defined in the create table statements for A and B.

True or False

6. If an alter statement drops a table column, the DBMS will stop the drop in the table column has data values.

True or false

7. By default, the DBMS will prevent drop table statement execution if the table to be dropped is referred to by another table's foreign key.

True or false

8. A create view statement

a. can create a primary key

b. can contain an insert into query

c. can refer to multiple tables

d. can create a foreign key

9. A column constraint:

a. can only be a check constraint

b. refers to only a single column

c. cannot be used to define a foreign key constraint

d. refers to any number of columns

10. Privileges to other users to a table can be controlled by the

a. grant statement

b. revoke statement

c. both 1 and 2

d. neither 1 nor 2

Answer rating: 100% (QA)

1 True 2 d all of these are true a is true ALTER TABLE Customers DROP COLUMN Email b is true ALTER TABLE Persons ALTER City SET DEFAULT Sandnes c is true ALTER TABLE tablename ADD columnname datatype ... View the full answer