Page 88 - DCAP508_DATABASE_ADMINISTRATION

Database Administration

Notes Functions: Functions are subroutines made up of one or more Transact-SQL statements that can
be used to encapsulate code for reuse.
Identifier Columns: These columns provide a mechanism to identify each item stored in the
table.
Primary Key Constraint: PRIMARY KEY constraints identify the column or set of columns that
have values that uniquely identify a row in a table.
Raw Data Columns: These columns store tangible pieces of information, such as names,
determined by a source external to the database.

Tables: Tables are database objects that contain all the data in a database.
Triggers: A trigger is a special type of stored procedure that automatically takes effect when the
data in a specified table is modified.

UNIQUE Constraints: A constraint that enforce the uniqueness of the values in a set of columns.
View: A view is a virtual table whose contents are defined by a query

5.13 Review Questions

1. Discuss the various types of system databases in SQL Server.

2. How can a user modify the system data in SQL server? Explain in detail.
3. Describe in detail the various steps involved in database planning.
4. Discuss the process of creating databases in SQL Server.
5. Comment: It is recommended that you specify a maximum size to which the file is
permitted to grow.
6. What are tables? Describe the procedure of creating and modifying a table in SQL server.
7. Analyze the statement: Using constraints is preferred to using DML Triggers, rules, and
defaults with suitable reasons.
8. Explain the benefits of using stored procedures in SQL Server rather than Transact-SQL
programs stored locally on client computers.
9. How can you create database diagrams in SQL Server?
10. Enlist the important guidelines before you create a view.
11. Describe the prerequisites for Creating Stored Procedure.
12. Explain briefly the procedure of creating following objects in SQL server:

(a) Functions
(b) Procedures
(c) Triggers

Answers: Self Assessment

1. Backup 2. Maximum size

3. Identifier columns 4. Owner
5. Transaction log 6. Views

82 LOVELY PROFESSIONAL UNIVERSITY