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?
You can get much more regarding Database Management Interview Questions : http://planetofcoders.com/category/database-management/