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 a transaction? Describe mysql transaction properties.

1172

Explain the difference between delete and truncate.

1041

How can an index be declared in mysql?

1001

How can you filter the duplicate data while retrieving records from the table?

958

What are the features of mysql?

1046

What is the function of mysqldump?

1131

What is view? How can you create and drop view in mysql?

1007

How can you import tables from a sql file into a database by using the mysql client?

1094

How you can create a trigger in mysql?

1060

What is the purpose of using timestamp data type?

978

What is the difference between mysql_fetch_array() and ysql_fetch_object() ?

1086

What are the functions of commit and rollback statements?

1109

What is a csv table?

1057

How can you count the total number of records of any table?

984

How can you retrieve a particular number of records from a table?

987

Un-Answered Questions { Databases }

Is sql procedural language?

1015

How many partitions a clustered index has by default in sql server 2012?

1142

Explain data independence & its types.

1098

How do I check mysql version?

1126

What is logs in mysql?

951

How to find out what oracle odbc drivers are installed?

1096

What is rename in sql?

1023

What are hotfixes and patches?

991

What are different sql data types?

1130

what are date and time functions in mysql? : Sql dba

1030

how to calculate the difference between two dates? : Sql dba

1121

What is exporting utility?

1091

How do I start mongodb on mac?

Why use cursor in sql server?

1138

What is the difference between couchdb and rdbms?

For More Un-Answered { Databases } Questions Click Here