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.

1174

Explain the difference between delete and truncate.

1043

How can an index be declared in mysql?

1006

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

960

What are the features of mysql?

1048

What is the function of mysqldump?

1136

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

1011

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

1097

How you can create a trigger in mysql?

1062

What is the purpose of using timestamp data type?

980

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

1092

What are the functions of commit and rollback statements?

1114

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?

991

Un-Answered Questions { Databases }

How sql server enhances scalability of the database system?

1333

Which dba certification is best?

618

What do you mean by catalog?

915

What is stack builder?

891

What is a mixed extent?

1085

how to create a table index in mysql? : Sql dba

1136

Which are the different languages supported by mongodb?

what is transaction state, buffer management, shadow paging

3519

Define a relation schema and a relation.

1175

What is the use of sequences?

We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

5387

Can I call a procedure inside a function?

1084

What is an active database?

1077

What is BCNF? How is it better than 2NF & 3NF?

1075

Which database is best to store images?

1104

For More Un-Answered { Databases } Questions Click Here