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

Where is a procedure return in an external pl/sql library executed at the client or at the server?

1 3755

Where is the external query executed at the client or the server?

Wipro,

2 5443

What are the default parameter that appear at run time in the parameter screen?

1 4390

Which parameter can be used to set read level consistency across multiple queries?

1 3535

What is term? What is use of term?

1 3972

Is it possible to insert comments into sql statements return in the data model editor?

1 3765

If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?

1 4981

What are the sql clauses supported in the link property sheet?

1 4302

To execute row from being displayed that still use column in the row which property can be used?

1 3434

Is it possible to set a filter condition in a cross product group in matrix reports?

1 4420

If a break order is set on a column would it effect columns which are under the column?

1 4167

With which function of summary item is the compute at options required?

1 3981

What is the purpose of the product order option in the column property sheet?

1 4084

How can a button be used in a report to give a drill down facility?

1 4037

What are the two ways by which data can be generated for a parameter's Using static values?

1 3882

Un-Answered Questions { Databases }

Explain the classification of Database Management System?

4270

What does data normalization mean?

1028

What is an explain plan and how does it help in optimizing the sql query?

Explain the truncate in oracle?

1015

What is procedure in pl sql?

1094

What are information schema views?

1037

What is mapping schema?

1074

What is date functions?

1092

What is postgis used for?

880

What do you understand by aggregation and atomicity?

960

What are three advantages to using sql?

1074

How MySQL Optimizes DISTINCT?

1169

How to make a column bigger and delete unique from table.

1047

Can a table be created inside a trigger?

1014

How to Truncate Table in Oracle

1219

For More Un-Answered { Databases } Questions Click Here