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

3 10658

How would you go about generating an EXPLAIN plan?

2 8193

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

2 7248

Explain an ORA-01555

2 6920

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 18839

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

2 10957

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 9113

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

1 4713

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2392

Explain the use of table functions.

1 5632

Name three advisory statistics you can collect.

1 5679

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

1 8571

Explain materialized views and how they are used.

2501

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

1 9764

What background process refreshes materialized views?

Accenture, FLSmidth,

2 12672

Un-Answered Questions { Databases }

Is mysql a dbms?

949

wat wil hapn if we give the both read and deny read permission to user?

2154

What is database client?

1053

what does myisamchk do? : Sql dba

1079

What are the various constraints used in oracle?

1104

Is it good to store image in database?

954

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1153

difference between global n context sensitive segments?

2732

Explain what a database is?

1087

Any work done in oracle workflow builder. Did you customize or build a new workflow?

Does office 365 include ms access?

911

when would you go for denormalization? : Sql server database administration

911

How to change the data type of an existing column with "alter table" statements in ms sql server?

1041

What are the types of stored procedures?

857

Describe a subquery.

1107

For More Un-Answered { Databases } Questions Click Here