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

Where can you add custom error messages to sql server?

1198

What is the primary use of the model database?

1144

what is the difference between openrowset and openquery?

1186

Why and when do stored procedure recompile?

1052

How can you append an identity column to a temporary table?

1065

What is the difference between for xml raw and for xml auto?

1108

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

Why should you use or avoid select * statements?

1105

When should you use an instead of trigger?

1042

What is an indexed view?

1018

How can you know if the row fetched from cursor is still valid in underlying table?

1 1067

What is the difference between a primary key and a unique key? Are they the same?

1 1153

how you can list all the tables in a database?

1 1089

What is a mixed extent?

1 1101

After removing a table from database, what other related objects have to be dropped explicitly?

1 1134

Un-Answered Questions { Databases }

1207

What is oracle latest version?

1169

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1841

If a cursor is open, how can we find in a pl/sql block?

1235

Any work done in oracle workflow builder. Did you customize or build a new workflow?

What kind of problems occurs if we do not implement proper locking strategy?

1493

How to enter binary string literals in ms sql server?

1235

Why and when do stored procedure recompile?

1052

Were you involved in any data conversion, which one?

how to start mysql server? : Sql dba

1258

Do we need to rebuild index after truncate?

1128

How to connect php with different port numbers?

1177

What are the two main functions of queries in databases?

1523

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1947

What is an indexed view?

1018

For More Un-Answered { Databases } Questions Click Here