Page 60 - DCAP508_DATABASE_ADMINISTRATION

Database Administration

Notes 4.7 Review Questions

1. What do you understand by the term: Resource Database?
2. Describe the database physical structure.

3. Explain database files.
4. Discuss the use of transaction log in SQL server.
5. Describe the characteristics of the SQL Server Database Engine transaction log.
6. Differentiate between a Page and a Extent.
7. Briefly describe the various types of page sin SQL server.

8. Explain the various types of file types in SQL Databases.
9. Write a short note on: Logical and Physical File Names in SQL Server.

Answers: Self Assessment

1. False 2. True
3. True 4. False

5. False 6. True
7. File groups 8. logical_file_name
9. os_file_name 10. transaction log

4.8 Further Readings

Books C.J. Date, Introduction to Database Systems, Pearson Education.
Elmasri Navrate, Fundamentals of Database Systems, Pearson Education.

Peter Rob & Carlos Coronel, Database Systems Design, Implementation and
Management, 7th Edition.
Raghurama Krishnan, Johannes Gehrke, Database Management Systems, Tata
McGraw Hill, 3rd Edition.
Silberschatz, Korth, Database System Concepts, McGraw Hill, 5th Edition.

Online links www.sql-tutorial.net/
www.w3schools.com/sql/
www.sqlservertutorials.com/

54 LOVELY PROFESSIONAL UNIVERSITY