1. What are the following SQL Server Administration and Management Tools used for?(3 Marks)

SQL Server Configuration Manager
SQL Server Profiler
SQL Server Agent

 

1. What is the purpose of the Transaction Log file that is associated with each database?(1 Mark)
   
   
    
2. State two methods that can be used to move a database file to another location.(4 Marks)
   1. 
      
       
   2. 
      
       
3. Indicate the best data type that should be used for each of the following columns from an Airline Reservation Database (taking into consideration efficiency and storage space):(5 Marks)

Description	Data Type
Passport Number
Airline Code
Departure Date and Time
Aircraft Seat Capacity
Reservation Confirmed?

 

1. What are indexes used for?(1 Mark)
   
   
    
2. What is the difference between a clustered index and an unclustered index?(2 Marks)
   
   
   
    
3. When establishing relationships and enforcing referential integrity, what are the following options used for?(4 Marks)
   1. CASCADE
      
      
       

SET DEFAULT