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 is fill factor and pad index?

1066

What are constraints in microsoft sql server?

1219

What is user-defined function?

1035

What guidelines should be followed to help minimize deadlocks?

995

Differentiate between ms sql server reporting services vs crystal reports?

948

What is the use of keyword with encryption.

1086

What is default constraint in ms sql server?

1106

Explain transaction server explicit transaction?

978

What is exporting utility?

1091

What is the use of keyword with encryption. Create a store procedure with encryption?

1002

Explain time data type in sal server 2008?

972

Explain transaction server isolation?

1086

What is thr feature of change data capture?

1039

What is exporting and importing utility?

1149

Explain transaction server distributed transaction?

1039

Un-Answered Questions { Databases }

what are the type of locks ? : Sql dba

1010

Where is dbms used?

1129

How to throw custom exception in Stored Procedure?

1097

What do you mean by etl?

what is the role of dip user in our database?

2464

Explain “not null constraint” in sql server?

1090

How to execute a function in postgresql?

972

What is difference between unix timestamp and mysql timestamp?

1064

What is data model example?

1128

What is Difference Between Unique and Primary Key Constraints?

1155

How to unzip a file in ssis?

1127

What happens to index when table is dropped?

872

What is report subscription?

132

What flow of MSExcel in odi?

634

In what sequence sql statement is processed?

1057

For More Un-Answered { Databases } Questions Click Here