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

How do you trap the error in forms 3.0 ?

1 3667

State the order in which these triggers are executed ?

1 3969

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

1 4856

When will ON-VALIDATE-FIELD trigger executed ?

1 4297

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

2 8523

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

1 8521

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

2 4737

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

1 4300

When is PRE-QUERY trigger executed ?

3 7852

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

2 5209

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

2 6400

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

1 3407

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

2 7566

When does an on-lock trigger fire ?

1 13150

What is Post-Block?

1 4946

Un-Answered Questions { Databases }

How do I run a pl sql procedure in sql developer?

1022

How do I create a database in pgadmin 4?

845

how many triggers are allowed in mysql table? : Sql dba

1107

How many columns should be in an index?

1018

how many columns can be used for creating index? : Sql dba

989

What are the different types of (all page) locks in sybase?

868

How to use subqueries with the in operators in ms sql server?

1129

how are mysql timestamps seen to a user? : Sql dba

1201

What is database replication? What are the different types of replication you can set up in sql server?

1018

Is microsoft access part of office?

940

Explain the difference between mysql_fetch_array(), mysql_fetch_object()?

999

What is example of database?

1137

what is the dual table in oracle?

1044

What is right outer join in sql server joins?

1226

What are the differences between lost updates and uncommitted dependencies?

1148

For More Un-Answered { Databases } Questions Click Here