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

597

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

606

List five most important parameter in 9i affecting performance?

604

What is the difference between rman and a traditional hotbackup?

1 1507

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

593

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

611

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

654

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

610

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

629

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

623

How do you install statspack?

718

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

585

How do you analyze table partition using oracle provided package?

555

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?)

823

What is oracle partial backup?

630

Un-Answered Questions { Databases }

How to get the definition of a view out of the sql server?

1028

What is oracle dba role?

618

How to write a query with an inner join in ms sql server?

1094

What is blob and text in mysql?

1216

What is BCP? When does it used in sql server 2012?

1108

Which programming language is used to write mongodb queries?

Do foreign keys improve performance?

1068

How to write sql script in postgresql?

921

Who is the owner of a schema in ms sql server?

1116

Does an update fsync to disk immediately?

List the merits of index covering.

920

How to drop an index?

1013

Is it possible to execute a dynamic sql from forms?

1118

What is the xml datatype?

1123

How is mongodb data stored?

For More Un-Answered { Databases } Questions Click Here