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 10547

How would you go about generating an EXPLAIN plan?

2 8081

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

2 7149

Explain an ORA-01555

2 6821

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 18741

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

2 10829

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 9034

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

1 4644

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2346

Explain the use of table functions.

1 5563

Name three advisory statistics you can collect.

1 5603

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

1 8498

Explain materialized views and how they are used.

2446

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

1 9694

What background process refreshes materialized views?

Accenture, FLSmidth,

2 12564

Un-Answered Questions { Databases }

How can I see all tables in sql?

1081

What do you mean by couchdbkit?

What is background process in Oracle?

1108

explain how to create a new schema in a database? : Sql server database administration

1112

How to search for a string in all stored procedure in sql server?

1004

What is the purpose of a field in a database?

969

What are stored procedures in mysql?

1021

Explain for xml explicit mode?

980

What is procedure in mysql?

942

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

1392

What is bulk copy or bcp in oracle?

1126

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1043

What are the disadvantages of using the stored procedures?

1110

How to get all stored procedures in sql server?

1004

Why do we use joins?

1048

For More Un-Answered { Databases } Questions Click Here