Database interview questions

Some of the common database interview questions are given below. You can find the basic questions here and it will be helpful for freshers. Basic Database interview questions are frequently asked in many companies. The question are based on the SQL Server versions this differ for different types of databases.

1.What is database

2.What is DBMS

3.What is Normalization

4.What is ddl commands

5.What is dml commands

6.what is Data Control Language commands? some variables in sql?

8.What difference between nvarchar and varchar?


10.What is sub-queries?

11.What are correlated queries?

12.Group by definition(not examples).

13.stored procedure definition.

14.Can we use virtual tables in triggers?

15.What are cursor disadvantages?

16.t-sql is for sqlserver,what is that for oracle?

17.what are the different types of joins?

18.what is the difference between function and stored procedure?

19.what is cursor? Why it is used in sql?

20.What is aggregate functions in sql?

21.What is Virtual triggers?

22.what is 1st normal form?

23.What is 2nd normal form?

24.What is 3rd normal form and boyce codd normal form?

25.What is primary key? Why it is used?

26.What is alternate and candidate key?

27.What is foreign key? Example

28.What is functional dependency?

29.What is data models?

30.What is Constraint? What are the types used?


Author: Gaurav Agrawal10 May 2012 Member Level: Gold   Points : 0

You can get much more regarding Database Management Interview Questions :

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: