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

Oracle (3253)
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 the difference between is null & is not null?

1052

How to validate email addresses in mysql?

1187

How we can get distinct columns values in mysql?

1132

Write a query to display even rows in student table using mysql?

944

How to write optimized query in mysql?

1042

How to display odd rows in student table in mysql?

1084

What is the difference between myisam dynamic and myisam static in mysql?

1062

List some comparisons operators used in mysql?

1042

How do I import database through command line?

1078

What is the difference between the primary and unique key in mysql?

1047

What is the difference between having and where clause in mysql? Explain

1085

Explain the difference between primary key and candidate key in mysql?

1022

How to control the max size of a heap table?

1055

How to display top 10 rows in mysql?

1096

Is mysql case-sensitive?

957

Un-Answered Questions { Databases }

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1097

How subquery works in sql?

1137

You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?

641

Is sql a oracle?

1029

Explain temporary table vs table variable by using cursor alternative?

1059

How to create a simple table to test triggers in ms sql server?

1042

how will add additional conditions in sql?

1170

What is ntext?

1147

Is there any need to create database command in mongodb?

How do I rename a procedure?

929

How many triggers can be applied to a table?

1133

What is difference between standardization and normalization?

1171

Explain the wait events in statspack report 'db sequential real'?

699

What is variable and how many types of variable?

641

How to locate and take substrings with charindex() and substring() functions?

1083

For More Un-Answered { Databases } Questions Click Here