Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1411)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

What is cte (common table expression)?

1053

What do you mean by an execution plan? Why is it used?

1044

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

1020

Describe in brief system database.

1031

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1019

What is normalization of database? What are its benefits?

1045

What is difference between index seek vs. Index scan?

1168

Explain indexed views?

994

What are the properties of the relational tables?

896

What are the restrictions that views have to follow?

990

What are various aggregate functions that are available?

1004

What is indexed view?

998

What is a with(nolock)?

995

What are acid properties of transaction?

967

What is difference between clustered and non clustered index?

999

Un-Answered Questions { Databases }

What is difference between global temporary tables and local temporary tables?

1252

What is the difference between sum and count in sql?

998

What is a driver in programming?

1055

What are the various features present in ms access?

861

Call by value and call by reference in procedure and function, with NOCOPY.

1316

List some comparisons operators used in mysql?

999

Where do you find the default Index fill factor and how to change it?

1076

What is an Oracle Instance?

1138

Why rdbms is not suitable for big data?

1034

What are dml and ddl statements?

1003

Explain syntax for viewing, dropping and disabling triggers?

971

What are the events recorded in a transaction log?

1015

Explain what are the database objects? : sql server architect

937

Do you know what are different types of replication in sql server?

1114

What do you mean by asa in sybase?

1006

For More Un-Answered { Databases } Questions Click Here