Question

Answer the following and explain so I can double check my answers

If you use the Management Studio to create a database, the Studio will automatically create a database file plus a ______________________ file.

10 points   

QUESTION 2

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

10 points   

QUESTION 3

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

10 points   

QUESTION 4

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 ________________________.

10 points   

QUESTION 5

When you use the Management Studio to create a table, all of the constraints are at the _________________________ level so they can refer to any of the columns in the table.

10 points   

QUESTION 6

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

10 points   

QUESTION 7

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

a.

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

b.

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

c.

Review the tables that a specific table depends on

d.

Review the tables that depend on a specific table

10 points   

QUESTION 8

Some database designers write their own SQL statements for creating a database, its tables, and its indexes, instead of using the Management Studio. They do that for all but one of the reasons that follow. Which one is it?

a.

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

b.

They’re less likely to make syntax errors as they implement the database.

c.

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

d.

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.

Answer 1

1 ) Ans:  

LOG FILE

If you use the Management Studio to create a database, the Studio will automatically create a database file plus a LOG file.

The management studio creates a log file to make it possible to recover from failure , and they make it possible to synchronize primary and secondary databases.Log file keeps records of Database changes. To restore database to a particular point, log files are used to roll the data forward to the point of failure.

2)

UPDATE

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

3rd Answer: SQL(Structured Query Language)

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

It generates and runs the SQL statements because Database can understand only SQL statements/Commands.

4) Ans:

REFERENTIAL INTEGRITY

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 REFERENTIAL INTEGRITY.

Referential Integrity refers to the accuracy and consistency of data within a relationship.In relationships, data is lined between two or more tables.

5) Ans:

TABLE

When you use the Management Studio to create a table, all of the constraints are at the TABLE level so they can refer to any of the columns in the table.

It checks all of the constraints are at table level because a table level constraint can see every column in a table.

6) Ans:

SCRIPT

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

If you save the script that you have used to create, alter , or delete database objects, so that you can use the script in future again if you need.

7) Ans:   

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

Stored procedures are used because we can create/write our own syntax for creating a database. If the database is created by someone, it becomes difficult to keep track of all the dependencies.So we use stored procedures to create our own database and dependencies.

8) Ans:

They’re less likely to make syntax errors as they implement the database.

because they knows where they have mad a mistake and they can correct it on their own,but if they don't use their own SQL statements to create a table/database,it becomes difficult for them to identify syntax errors.