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 the role of indexing in databases?

1156

what does the t-sql command ident_incr does? : Transact sql

1091

what is the difference between truncate and delete statement? : Transact sql

1089

what is “go” in t-sql? : Transact sql

1127

what are the join types in tsql? : Transact sql

1081

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

963

what is uncommittable transactions? : Transact sql

1013

what are the t string functions available in tsql? : Transact sql

1038

what is the syntax used for partition in tsql? : Transact sql

1034

what are rollup and cube in t-sql? : Transact sql

1125

what does the t-sql command ident_current does? : Transact sql

1005

what are dynamic queries in t-sql? : Transact sql

1040

what is top in tsql? : Transact sql

1141

what is sub-query? : Transact sql

1121

how does a local variable is defined using t-sql? : Transact sql

1031

Un-Answered Questions { Databases }

What causes re-resolution of a stored procedure in sybase?

911

How can a function retun more than one value in oracle with proper example?

1097

How would you configure identities in sybase?

1043

What is unsigned int in mysql?

963

Is it possible to use primary key of one table as a primary key in many other tables?if yes, how?

788

What is executereader?

975

a text item is there what r the different types of triggers associated with it

2039

Explain integrity constraints?

1123

What are the different types of backups that exist?

1187

What do you mean by denormalization?

1048

What is the difference between mongodb and mysql?

How do you clear the screen in sql?

1093

What is bcp? When does it use?

959

How to enter unicode character string literals in ms sql server?

1097

What is a join in sql?

1116

For More Un-Answered { Databases } Questions Click Here