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

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

1 1148

Can a select statement fire a trigger?

1 1236

What are conditional predicates?

1 1149

Does a user_objects view have an entry for a trigger?

1 1062

Explain some predefined exceptions.

1 1106

Does user triggers have entry for trigger with compilation errors?

1 1114

Explain uses of cursor.

1 1780

Explain 3 basic parts of a trigger.

1 1393

Show code of a cursor for loop.

1 1135

What does closing a cursor do?

1 1397

How many triggers can be applied to a table?

1 1148

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

1 1132

Show the cursor attributes of pl/sql.

1 1127

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

1 1323

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

1 1268

Un-Answered Questions { Databases }

What is current version of mysql?

1069

What is a scheduled job or what is a scheduled task?

1031

How do I remove duplicates in two columns?

1177

Have you written applications to retrieve stored images in a table?

1083

What are the different subsets of sql?

1646

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2308

Can delete statement be rollbacked?

1050

What is in place upgrade in sql server?

1121

how to start mysql server? : Sql dba

1258

What is sql server query analyzer?

1121

How do I find query history in sql server?

1018

What is the primary use of the model database?

1144

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1207

What is the difference between upgrade and migration in sql server?

1175

Is there some bulk load or other way to import a lot of data fast?

929

For More Un-Answered { Databases } Questions Click Here