Sql Server Database Interview Questions and Answers - 1

Question: 1

What is the use of flat-file database?

Flat –file database can be quite useful for certain single-user or small-group situations, especially for maintaining lists such as address lists or inventories.

Question: 2

How will you edit a data entered in a table?

To edit a data that has been entered in a table, just click on that field value and retype the new value.

Question: 3

How will you save the table after creating its structure?

• To save the table, either press Ctrl+S keys or go to the File menu and click on Save.
• Enter the name of the table in the dialog box which appears and click on Save.

Question: 4

How will you insert a Calc cell range into a text document?

• Type in the new data. The new data will simply overwrite the old contents of the cell.
• Click on the formula bar with the mouse, press the F2 function key or simply double-click on the cell.
• A vertical cursor appears on the formula bar. Move the cursor to the left using the left arrow key or the backspace key and edit the data.

Question: 5

On the basis of the conceptual structure how can the databases be classified?

Based on the conceptual structures, the data bases can be classified as follows:

• Flat-File database   
• Relational database
• Hierarchical database
• Network database 
• Object Oriented database