Databases AllOther Interview Questions
Questions Answers Views Company eMail

What do you mean by cluster and non cluster index?

69

Explain entity ?

64

What are the advantages of views in a database?

71




Explain natural key?

66

Explain entity set?

61

List the properties of a transaction.

60

Explain buffer manager?

56

Explain the various types of normalization.

54




What is ole db provider for sql server?

19

What is ole db ado?

17

What is ole db in ssis?

22

What is ole db source in ssis?

18

What is ole db used for?

22

What is the role of driver manager?

26

What is database server and how it works?

20


Post New Databases AllOther Questions






Un-Answered Questions { Databases AllOther }

What is a Database?

77


What is a database string?

27


What is a driver in database?

15


What are different types of joins used in?

78


What is a sequence? Explain it with one example?

73






What is sharded database?

22


How do you pass parameter in stored procedure?

96


What is a database example?

19


What is ase database?

24


define primary key index, bitmap index, hash index,virtual indwx

2318


Differentiate between delete and truncate table?

71


How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?

996


What is the difference between database and server?

24


How concurrency problems effect the database?

87


Explain file manager?

62