Database Questions
 
  

 

 

 

Questions and Answers

Contributed by Swaropa

 

5. What is a Server Database Systems?

Server-based systems are database on a central computer, called as a server and is shared among multiple users.

6.What are the Advantages of Server Database System?

Each data item is stored in a central location where all users can work with it.

Business and security rules can be defined one time on the server and enforced equally among all users.

A relational database server optimizes network traffic by returning only the data an application needs.

Hardware costs can be minimized.

Maintenance tasks such as backing up and restoring data are simplified because they can focus on the central server.

 

7. Describe the three levels of data abstraction?

The are three levels of abstraction:

Physical level: The lowest level of abstraction describes how data are stored.

Logical level: The next higher level of abstraction, describes what data are stored in database and what relationship among those data.

View level: The highest level of abstraction describes only part of entire database.

8.What is ODBC?

9.What is OLEDB?

10.Sysobjects is used for?

Sysobjects are used to retrive the system objects details from the database.

 1 2 34