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?

990

What is difference between stored procedures and application procedures?

959

How to order siblings in oracle hierarchy queries?

983

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

1127

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

949

How to know the last executed procedure?

1035

What is difference between stored function and application function?

1105

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

1029

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

998

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

1023

What is a database trigger?

1019

What are types of exception?

876

Explian rowid, rownum?

960

What are % type and % rowtype?

983

Name some usages of database trigger?

969

Un-Answered Questions { Databases }

Is microsoft access part of office?

800

How do you prevent oracle from giving you informational messages during and after a sql statement execution?

527

What is auditing in sql server?

883

What are all the ddl commands?

1118

How do I zip a file in mysql?

927

What is key in mysql?

838

What will have to do if a shard is down or slow and you do a query?

What is an anonymous block?

1158

Does facebook use graph database?

989

What is cte (common table expression)?

979

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2529

What is the latest mysql version?

931

What is meant by Active-Passive and Active-Active clustering setup?

1069

Tell me what do we need queues in sql service broker?

927

What does a database contain?

824

For More Un-Answered { Databases } Questions Click Here