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 are the roles and user accounts created automatically with the database ?

1 3863

What are the database administrators utilities avaliable ?

2 3988

What are the minimum parameters should exist in the parameter file (init.ora) ?

1 4000

What is a trace file and how is it created ?

2 4078

What are roles ? How can we implement roles ?

2 5542

What are the steps to switch a database's archiving mode between NO ARCHIVELOG and ARCHIVELOG mode ?

1 5820

How can you enable automatic archiving ?

2 6077

How can we specify the Archived log file name format and destination ?

2 7398

What is the use of ANALYZE command ?

3 7262

How can we reduce the network traffic ?

Keane India Ltd,

3 6351

What is snapshots ?

2 6237

What are the various type of snapshots ?

3 5692

Differentiate simple and complex, snapshots ?

2 5213

What dynamic data replication ?

2 6662

How can you Enforce Refrencial Integrity in snapshots ?

1 4361

Un-Answered Questions { Databases }

What is crud diagram?

996

What is append query?

964

How to declare a cursor with "declare ... Cursor" in ms sql server?

1093

What is consistency?

1187

How do you maintain a database?

988

How can we force the database to use the user specified rollback segment?

1202

What is dbms architecture?

1144

What is normalization of database?

1184

What is difference between mongodb and mysql?

975

What does postgresql mean?

890

What will happen when you remove a document from database in mongodb? Does mongodb remove it from disk?

What is difference between rownum and rowid?

958

How to create Drill down report?

2187

What is difference between temp table and cte?

1074

What are 5 benefits to using access?

928

For More Un-Answered { Databases } Questions Click Here