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

1116

Explain the difference between delete and truncate.

1001

How can an index be declared in mysql?

960

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

910

What are the features of mysql?

1004

What is the function of mysqldump?

1083

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

947

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

1046

How you can create a trigger in mysql?

1011

What is the purpose of using timestamp data type?

931

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

1041

What are the functions of commit and rollback statements?

1040

What is a csv table?

1017

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

934

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

950

Un-Answered Questions { Databases }

What is data modeling and Reterminal integrity?

1974

What is a join in sql?

1108

How to define a sub function?

1152

What is an expensive query?

944

Explain what is the function of sql server agent windows service?

1006

What is explicit cursors?

1089

What happens if the constraint name is left out of a constraint clause?

555

what are null values? : Sql dba

968

Can variables be used in sql statements?

1049

What is localdb mssqllocaldb?

1080

Is microsoft access in the cloud?

878

What is cost in sql execution plan?

997

What is compute?

1101

Explain how dts is used to extract, transform and consolidate data?

1012

While taking hot backup (begin end backup) what will happens back end?

567

For More Un-Answered { Databases } Questions Click Here