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

Explain atomicity?

1132

What is transaction server implicit?

1071

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1005

Explain why variables called the most powerful component of ssis?

1180

Explain the use of containers in ssis and also their types?

1022

What is precedence constraint?

1039

Why variables called the most powerful component of ssis?

1131

Explain error handling in ssis?

1078

What are the types of containers in ssis?

1243

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

1030

Explain the use of containers in ssis?

1021

Why is the need for data conversion transformations?

1113

What is conditional split?

1142

Can we add our custom code in ssis?

1042

Explain the difference between control flow and data flow?

1061

Un-Answered Questions { Databases }

Which command is used to call a stored procedure?

1055

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1837

What is the sql profiler?

1001

Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.

1206

How do you create a simple database?

1036

How to change the order of columns in Oracle SQL Plus ?

1109

What is difference between data and database?

1170

What is the use of triggers?

1086

what happens if you no create privilege in a database? : Sql dba

1050

What are the results of running this script?

978

If you see the value for reloads is high in the estat library cache report is this a matter for concern?

677

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1112

How many columns are in a database table?

963

What is mutating sql table?

1162

What is posting?

1086

For More Un-Answered { Databases } Questions Click Here