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 3752

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

Wipro,

2 5441

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

1 4387

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

1 3534

What is term? What is use of term?

1 3970

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

1 3763

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

1 4979

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 3433

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

1 4415

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 4036

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

1 3880

Un-Answered Questions { Databases }

How to select all columns of all rows from a table with a select statement in ms sql server?

1201

What happen when we delete the table using trigger?

952

What is mutating trigger?

1074

How many types of objects are there?

1077

What is data block in Oracle?

1155

How we can apply bit m a podded index in ms access

2145

What is the advantages and disadvantages of database management system?

1072

What are the different types of subquery?

1208

What is full outer join in sql server joins?

1143

What is the “__v” field in mongoose?

How would you fix a munged log in sybase ?

1016

How to write pl sql program in mysql command prompt?

1165

Can we write dml inside a function in sql server?

1004

What is the difference between a primary key and a unique key?

1108

What is olr?

For More Un-Answered { Databases } Questions Click Here