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

How do you trap the error in forms 3.0 ?

1 3619

State the order in which these triggers are executed ?

1 3900

What is the usuage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS ?

1 4775

When will ON-VALIDATE-FIELD trigger executed ?

1 4222

A query fetched 10 records How many times does a PRE-QUERY Trigger and POST-QUERY Trigger will get executed ?

2 8434

What is the difference between ON-VALIDATE-FIELD trigger and a POST-CHANGE trigger ?

1 8453

What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?

2 4659

What is the difference between a POST-FIELD trigger and a POST-CHANGE trigger ?

1 4246

When is PRE-QUERY trigger executed ?

3 7699

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the smae block level ?

2 5099

Can we use GO-BLOCK package in a pre-field trigger ?

2 6318

Is a Keystartup trigger fires as result of a operator pressing a key explicitly ?

1 3353

How can you execute the user defined triggers in forms 3.0 ?

2 7468

When does an on-lock trigger fire ?

1 13061

What is Post-Block?

1 4881

Un-Answered Questions { Databases }

What is a behavioral trigger?

983

What is an ndf file?

1000

what are the advantages and disadvantages of views in a database? : Sql dba

1045

What are the types of subquery?

1047

Why is mysql popular?

892

Explain the rollup operator?

1084

How can windows applications connect to sql servers via odbc?

1132

What is record in ms access?

858

How to place comments in pl/sql?

1170

How do I spool in oracle?

1016

Can multiple columns be used in sql group by clause in ms sql server?

1058

Define primary key?

1144

What is bookmark link in ssrs?

247

What is ims software environment?

913

In what sequence sql statement is processed?

1019

For More Un-Answered { Databases } Questions Click Here