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

Explain overloading. Can functions be overloaded?

1017

Give the advantages and disadvantages of clusters.

1060

Define oracle database

1052

Explain oracle instance.

1187

What is ceil and floor in oracle?

1080

Can a parameter be passed to a cursor?

1140

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1080

Explain user account with reference to oracle.

997

Explain constraining triggers.

1108

What is the maximum limit on the number of columns in a table?

1100

Why do you create or replace procedures rather that drop and recreate.

1020

How would you change old and new values in an insert, delete and update triggers?

1033

Explain oracle’s system global area (sga).

1154

Differentiate between function and procedure in oracle.

1092

Give the constructs of a package, function or a procedure.

1068

Un-Answered Questions { Databases }

Where is the data stored in a database?

1058

What is row level locking in mysql?

1024

Can we insert data into view sql server?

943

What is truncate oracle?

983

I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

3023

What are various limitations of the views?

1071

How to retrieve data from an explicit cursor?

1073

Can sql servers link to other servers?

1099

How to restore performance issues and how to check?

2016

What is the driver name for postgresql?

821

What is meant by temporal data?

982

What is postgresql dba?

938

How to count duplicated values in a column in oracle?

1059

What is type and rowtype in pl sql?

1023

How does mysql clustering work?

934

For More Un-Answered { Databases } Questions Click Here