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 column differentiates the V$ views to the GV$ views and how?

3 10568

How would you go about generating an EXPLAIN plan?

2 8099

How would you go about increasing the buffer cache hit ratio?

2 7164

Explain an ORA-01555

2 6832

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 18752

How would you determine the time zone under which a database was operating?

2 10847

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 9046

What command would you use to encrypt a PL/SQL application?

1 4655

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2354

Explain the use of table functions.

1 5574

Name three advisory statistics you can collect.

1 5619

Where in the Oracle directory tree structure are audit traces placed?

1 8509

Explain materialized views and how they are used.

2459

When a user process fails, what background process cleans up after it?

1 9703

What background process refreshes materialized views?

Accenture, FLSmidth,

2 12578

Un-Answered Questions { Databases }

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1924

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

What are the parts of a function?

956

Is mysql case-sensitive?

904

If you need to refresh a website page every time a record is updated in database, how would you do it?

941

How do I tune a mysql query?

904

Can you force a query to use a specific index?

963

Is postgresql a relational database?

855

What is a canvas in oracle forms?

1080

How do I start mysql in linux?

915

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1074

what is the difference between a primary key and a unique key? : Sql server database administration

1016

How connect excel to sql server?

1009

How is data stored on a disk?

1051

Explain cascading triggers.

1087

For More Un-Answered { Databases } Questions Click Here