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 is an oracle stored procedure?

1050

What is difference between stored procedures and application procedures?

1013

How to order siblings in oracle hierarchy queries?

1047

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1190

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

997

How to know the last executed procedure?

1099

What is difference between stored function and application function?

1199

How can a function retun more than one value in oracle with proper example?

1074

In a distributed database system, can we execute two queries simultaneously?

1090

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1074

What is a database trigger?

1067

What are types of exception?

922

Explian rowid, rownum?

1012

What are % type and % rowtype?

1028

Name some usages of database trigger?

1019

Un-Answered Questions { Databases }

How is data stored in a relational database?

944

Which sql server is best?

992

What is the difference between sga and pga?

615

What are transactions and its controls?

1061

How many threads can mysql handle?

973

What is couchdb and why it is used?

What is log shipping?

960

Explain what are the type of synonyms?

1111

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

1079

What are bind variables and why are they important?

543

How can we encrypt and decrypt a data presented in a table using mysql?

1063

What is the use of =,==,=== operators?

1013

What is mscorsvw.exe - process - microsoft .net framework ngen?

955

Does mongodb store data in memory?

How to detect applications and users that hold transactions open too long?

902

For More Un-Answered { Databases } Questions Click Here