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?

1200

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?

1092

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 do I switch users in mysql?

970

What happens when transaction log is full?

927

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

1013

How to replace null values in expressions using isnull()?

1101

How would you remodel an existing access database?

933

What are the advantages of ms access over ms excel?

790

How to make conditional sum in ssrs?

177

What is the meaning of resultset type_scroll_insensitive?

956

What is raw datatype?

1136

How important is to list the column names when doing an insert?

1042

explain primary keys and auto increment fields in mysql : sql dba

977

What is loop in pl sql?

1037

Define Wed Edition in SQL Azure?

100

How do you use automatic pga memory management with oracle 9i and above?

589

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1058

For More Un-Answered { Databases } Questions Click Here