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

Can we check locks in database? If so, how can we do this lock check?

959

What is sub query and its properties?

994

What is the use of @@spid?

1014

What do mean by xml datatype?

1126

What is the difference between commit and rollback?

959

How exceptions can be handled in sql server programming?

1025

How global temporary tables are represented and its scope?

995

Which sql server table is used to hold the stored procedure scripts?

1075

Mention what is the basic syntax to use index in mongodb?

Mention the command syntax that is used to view mongo is using the link?

Explain what is the role of profiler in mongodb?

Explain what are indexes in mongodb?

How replication works in mongodb?

Explain what is a replica set?

To do safe backups what is the feature in mongodb that you can use?

Un-Answered Questions { Databases }

How to insert and update data into a table with "insert" and "update" statements?

995

What does fetching a cursor do?

1105

which table keeps the locking information? : Sql server administration

1111

What does seeding a database mean?

983

Is full outer join same as cross join?

987

How much does sqlite cost?

1052

How do you call a stored procedure from jdbc?

959

Can mongodb store files?

Can composite key be null?

841

What do you mean by query evaluation engine?

988

Describe the functionalities that views support.

1116

What is pg_catalog in postgres?

938

Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

628

Give the order of sql select?

1159

What is meant by referential integrity?

1024

For More Un-Answered { Databases } Questions Click Here