Question 1 Check constraints you create using DDL can be defined at the table le

Question

Question 1

Check constraints you create using DDL can be defined at the

table level

both a and b

none of the above

column level

2 points

Question 2

Some database designers write their own SQL statements for creating a database, its tables, and its indexes instead of using the Management Studio. Why?

It’s easier to modify your own script if you want to use it to create the same database for another database management system later on.

All of the above

The scripts generated by the Management Studio are harder to understand.

They want to have complete control over how the database is created.

1 points

Question 3

When you create a table using the Management Studio, the table is automatically stored in the default schema. If you want to transfer the table to a different schema, you can use the which statement?

COPY SCHEMA

ALTER SCHEMA

SET SCHEMA

CREATE SCHEMA

1 points

Question 4

When you use the Check Constraints dialog box, all of the constraints are at the which level so they can refer to any of the columns in the table?

value

column

database

table

1 points

Question 5

When you use the Management Studio to create a check constraint, you can specify whether you want the constraint enforced for insert or ________________ operations.

invoice

log

update

delete

1 points

Question 6

When you use the Management Studio to create a database, including its tables and indexes, the Management Studio actually generates and runs the ____________ statements that are necessary to create the database.

none of the above

DML

both a and b

DDL

1 points

Question 7

When you use the Management Studio to create a foreign key constraint, you specify the relationship between two tables as well as the rules for enforcing what?

table design

column properties

column values

referential integrity

1 points

Question 8

Whenever you use the Management Studio to create, alter, or delete database objects, you can save the ________________ that it used for doing that.

log file

date

script

schema

1 points

Question 9

You can use the Object Dependencies dialog box of the Management Studio to do all but one of the following. Which one is it?

Review the stored procedures and views that depend on a specific table

Review the tables that a specific table depends on

Review the stored procedures and views that a specific table depends on

Review the tables that depend on a specific table

table level

both a and b

none of the above

column level

Explanation / Answer

1. Check constraints you create using DDL can be defined at the
   This can be done at both table level, and column level.
   So, the answer is: both a and b.
2. Some database designers write their own SQL statements for creating a database, its
   tables, and its indexes instead of using the Management Studio. Why?  
   a. It’s easier to modify your own script if you want to use it to create the same database
       for another database management system later on.
   c. The scripts generated by the Management Studio are harder to understand.
   d. They want to have complete control over how the database is created.
   So, the answer is: All the above.
3. When you create a table using the Management Studio, the table is automatically stored
   in the default schema. If you want to transfer the table to a different schema,
   you can use the which statement?      
   b. ALTER SCHEMA will move the schema from one table to another table.
4. When you use the Check Constraints dialog box, all of the constraints are at the which
   level so they can refer to any of the columns in the table?  
   d. table level, so they can refer to any of the columns in the table.
5. When you use the Management Studio to create a check constraint, you can specify whether
   you want the constraint enforced for insert or ________________ operations.  
   c. update
6. When you use the Management Studio to create a database, including its tables and
   indexes, the Management Studio actually generates and runs the ____________ statements
   that are necessary to create the database.  
   d. DDL statements are used to create the database.
7. When you use the Management Studio to create a foreign key constraint, you specify the
   relationship between two tables as well as the rules for enforcing what?  
   d. referential integrity
8. Whenever you use the Management Studio to create, alter, or delete database objects,
   you can save the ________________ that it used for doing that.  
   c. script
9. You can use the Object Dependencies dialog box of the Management Studio to do all but
   one of the following. Which one is it?  
   c. Review the stored procedures and views that a specific table depends on

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.