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

What are the advantages of using stored procedures?

1 1031

What is the command to change the recovery model?

1 1121

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

1 1109

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

1 1069

Will count(column) include columns with null values in its count?

1 1181

What is isolation levels?

1 1105

What are the default system databases in sql server 2000?

1 1103

What does the not null constraint do?

1 1229

How to rebuild master databse?

1 1151

What command would you use to create an index?

1 1130

What command do we use to rename a database?

1 1152

Do comments need to go in a special place in sql server 2005?

1 943

What is the purpose of the model database?

1 1104

What is the sql server 2000 version number?

1 1184

Name 3 ways to get an accurate count of the number of records in a table?

1 1113

Un-Answered Questions { Databases }

please send me oracle pl/sql exp resume. and also faqs...

2568

how to use regular expression in pattern match conditions? : Sql dba

1108

What is sql or structured query language?

1220

What is the current version of sql?

1091

What is the latest version of postgresql?

951

what are the advantages of sql ? : Sql dba

1140

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1194

what is bcp? When does it used? : Sql dba

1055

Design database draw er diagram for a certain scenario ?

4650

What is the primary use of the model database?

1146

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8227

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2211

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?

1847

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

1235

What is standby servers? Explain types of standby servers.

1077

For More Un-Answered { Databases } Questions Click Here