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

1115

What is difference between stored procedures and application procedures?

1066

How to order siblings in oracle hierarchy queries?

1110

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

1248

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

1053

How to know the last executed procedure?

1156

What is difference between stored function and application function?

1290

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

1127

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

1155

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

1132

What is a database trigger?

1135

What are types of exception?

963

Explian rowid, rownum?

1084

What are % type and % rowtype?

1081

Name some usages of database trigger?

1084

Un-Answered Questions { Databases }

What is the example of rdbms?

984

What is load plan and types of load plans in ODI?

668

What do you mean by a deadlock?

1109

explain detail about ftp in datastage?

2293

What is the usage of the sign function?

1195

What is the role of database management system?

983

How to modify the underlying query of an existing view?

1030

What is rdbms data?

973

State some criteria and their effects of a database?

964

How do you create a simple database?

1036

How to connect to the server with user account: sys?

1061

Explain about achiever in sql?

1086

What do you understand by a database object? Can you list a few of them?

1063

How do I create a partition table in sql server?

1184

What are the steps you will take to improve the performance of a poor performing query?

1019

For More Un-Answered { Databases } Questions Click Here