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 does the automatic recovery do?

1 2556

What is the difference between writing data to mirrored drives versus raid5 drives

949

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

1043

Give an example of why you would want to denormalize a database

995

How many full-text indexes can a table have?

989

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

1051

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

1163

What is the importance of concurrency control?

1248

How you can get the list of largest tables in a database?

1031

When you should use a low fill factor?

1005

Define cursor locking

1020

What is database replication? What are the different types of replication you can set up in sql server?

975

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1022

Explain the dbcc pintable command when would you use it?

933

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1072

Un-Answered Questions { Databases }

Explain concurrency transparency.

1067

How do I open a .db file?

1055

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

1023

How to check if postgres is running?

918

Describe a subquery.

1058

Which are the most powerful features in mongodb?

What is the maximum size of a database that can be opened in Microsoft Access?

903

What is raw datatype in oracle?

1159

List out the different types of locks available in sql server?

995

How to insert stored procedure result into temporary table?

1031

How to load a csv file into a table

1046

Is it possible that with Neo4j you can query it over the internet?

Explain partial key?

1107

Can we call procedure inside function in oracle?

1113

Explain about the hierarchical model of the database?

1132

For More Un-Answered { Databases } Questions Click Here