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 transaction control language (tcl)?

1139

What is union and union all keyword in sql and what are their differences?

1108

What is the difference between sql and mysql?

1118

When can we use the where clause and the having clause?

1020

What is an example of translating a date into julian format?

1124

What are the different types of constraints?

1187

What is data control language (dcl)?

1138

How can we implement rollback or commit statement in a trigger?

1039

Why is there a need for sqlcode and sqlerrm variables?

1049

What is auto increment feature in sql?

1124

What is the basic structure of an sql?

1099

What is data definition language?

1093

How can we solve sql error: ora-00904: invalid identifier?

1247

Name the different types of indexes in sql and define them.

1151

What is hibernate and its relation to sql?

1124

Un-Answered Questions { Databases }

How will you create a updatecascade, deletecascade relation in ms-access? Explain with example.

794

what is a stored procedure? : Sql dba

1133

What is system r?

967

Is it possible to execute a dynamic sql from forms?

1073

What is “namespace” in mongodb?

How to define a variable of a specific record type?

1078

difference between global n context sensitive segments?

2677

What is heap table?

1029

Which is faster innodb or myisam?

1052

What is a user account in oracle?

1121

How do I grant privileges to a user in mysql phpmyadmin?

954

what is an extent ? : Sql dba

1102

What are the other commands to know the structure of a table using mysql commands except explain command?

1037

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1037

definition of cluster and non-clustered index?

3035

For More Un-Answered { Databases } Questions Click Here