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?

7.name some variables in sql?

8.What difference between nvarchar and varchar?

9.What are SYSTEM VARIABLES?

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?

Post Comment:

Notify me by email when others post comments to this article.

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:	Sign In to fill automatically.
Email:	(Will not be published, but required to validate comment)
	Type the numbers and letters shown on the left.

Online Members

Database interview questions

Post Comment:

Email subscription