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

Explain atomicity?

1065

What is transaction server implicit?

1023

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

962

Explain why variables called the most powerful component of ssis?

1117

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

980

What is precedence constraint?

996

Why variables called the most powerful component of ssis?

1092

Explain error handling in ssis?

1041

What are the types of containers in ssis?

1186

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

990

Explain the use of containers in ssis?

975

Why is the need for data conversion transformations?

1079

What is conditional split?

1092

Can we add our custom code in ssis?

1000

Explain the difference between control flow and data flow?

1016

Un-Answered Questions { Databases }

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1300

How do you store pictures in a database?

1017

Which is better join or subquery?

1152

Mention the command used to rename the database.

1024

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1155

Describe in brief authentication modes in sql server.

1040

What is confine mode and flex mode?

What are sql queries used for?

1037

How do I import a csv file into postgres?

923

how many triggers are allowed in mysql table? : Sql dba

1084

How do I drop a database in mysql?

1131

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2204

How will you optimize a stored procedure optimization?

1053

What is a data type in a database?

1038

What is the main reason behind using an index?

1031

For More Un-Answered { Databases } Questions Click Here