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 no logging option do? Why would we use it?

551

What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?

564

List five most important parameter in 9i affecting performance?

565

What is the difference between rman and a traditional hotbackup?

1 1442

How can you tell if an index on particular table is used or not used in 9i?

564

You see a wait on lms process in statspack, what does that mean?

574

What does the no logging option do? Why would we be careful of using it?

601

Tell me about standby database? What are some of the configurations of it?

568

When using oracle export/import what character set concerns might come up? How do you handle them?

595

Which date function is used to find the difference between two dates?

578

How do you install statspack?

685

Tell me about standby database? What are some of the configurations of it? What should we watch out for?

549

How do you analyze table partition using oracle provided package?

520

Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)

765

What is oracle partial backup?

585

Un-Answered Questions { Databases }

Can mongodb store binary data?

What are the different types of collation sensitivity?

1123

How do I run a trace in sql server?

983

What is an anonymous block?

1249

What is group function in sql?

1023

What is view? Can we update view

1439

Why do we need view in sql?

986

What is bind reference and how can it be created?

1020

How to resolve name conflicts between variables and columns?

1031

How to list or view all databases from the mysql server.

921

Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba

1024

Whis is not false in primary key?

1455

Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

4671

What language does mongodb use?

What happens if the update subquery returns multiple rows?

1116

For More Un-Answered { Databases } Questions Click Here