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 3620

State the order in which these triggers are executed ?

1 3901

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

1 4776

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 8435

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 4660

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

1 4247

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 7469

When does an on-lock trigger fire ?

1 13062

What is Post-Block?

1 4882

Un-Answered Questions { Databases }

What is meant by database in access 2010?

887

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1118

What is dbms introduction?

958

What do you understand by physical_only option in dbcc checkdb?

987

What is coalesce in sql?

1069

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2362

What is difference statement and preparedstatement?

989

What are three advantages to using sql?

1028

How is SQL Azure different than SQL server?

225

What do you mean by e-r model & object-oriented model?

943

What are vdl and sdl?

1175

Can we use jpa with mongodb?

How can I get the number of records affected by a stored procedure?

1069

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

953

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2354

For More Un-Answered { Databases } Questions Click Here