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

Can a commit statement be executed as part of a trigger?

1059

Can a select statement fire a trigger?

1170

What are conditional predicates?

1064

Does a user_objects view have an entry for a trigger?

1018

Explain some predefined exceptions.

1043

Does user triggers have entry for trigger with compilation errors?

1043

Explain uses of cursor.

1 1689

Explain 3 basic parts of a trigger.

1331

Show code of a cursor for loop.

1063

What does closing a cursor do?

1328

How many triggers can be applied to a table?

1069

How would you reference column values before and after you have inserted and deleted triggers?

1068

Show the cursor attributes of pl/sql.

1055

Which data dictionary views have the information on the triggers that are available in the database?

1245

What are the events on which a database trigger can be based?

1195

Un-Answered Questions { Databases }

What is NOT NULL Constraint in sql server 2012?

1005

Explain the storage engines in mysql?

1005

Is couchdb used in the software industry?

What does over partition by mean in sql?

985

What is data sublanguage?

1038

Can you always create a cache of a report?

174

What do you mean by adaptive server enterprise?

954

You want to implement the many-to-many relationship while designing tables. How would you do it?

999

How insert into statements in sql?

1081

Explain different forms of normalization?

951

what is difference between delete and truncate commands? : Sql dba

1138

How do I start microsoft access?

892

What are replica sets in mongodb?

How to test values returned by a subquery with the in operator?

1203

What is 1nf 2nf 3nf in dbms?

904

For More Un-Answered { Databases } Questions Click Here