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 10674

How would you go about generating an EXPLAIN plan?

2 8221

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

2 7273

Explain an ORA-01555

2 6936

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 18865

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

2 10967

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 9129

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

1 4731

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

1 2401

Explain the use of table functions.

1 5643

Name three advisory statistics you can collect.

1 5685

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

1 8580

Explain materialized views and how they are used.

1 2504

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

1 9774

What background process refreshes materialized views?

Accenture, FLSmidth,

2 12693

Un-Answered Questions { Databases }

What are the two main functions of queries in databases?

1509

How to put more than 1000 values into an oracle in clause?

1095

What is clustered index

1069

Can one drop a column from a table?

1075

how to use regular expression in pattern match conditions? : Sql dba

1096

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2335

How do I create a trace in sql server?

1102

Why use identity in sql server?

1185

i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

1848

What is the best sql course?

1031

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2691

How to define array in mongoose schema?

Equi join and non equi join is possible with sql server?

1110

What is a view in sql?

1033

Can delete statement be rollbacked?

1038

For More Un-Answered { Databases } Questions Click Here