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

Related Questions