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

Where in ms sql server is ’100’ equal to ‘0’?

1103

Explain iaas, paas and saas?

Explain the Ways to improve the performance of a sql azure database?

What are parameterized reports?

204

Differentiate sql server reporting services vs. Crystal reports?

203

What are cascading parameters in ssrs reports?

234

What are sub reports?

204

How to create sub reports?

246

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1119

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

1012

Explain lock escalation? : Transact sql

1214

Explain how to use transactions efficiently : transact sql

994

How do you determine the current isolation level? : Transact sql

1171

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1021

What is the default isolation level in sql server? : Transact sql

1047

Un-Answered Questions { Databases }

what is the use of ocr?

1049

How do you bind variables in oracle?

994

What is a user role in oracle?

1145

What is mysqli_select_db?

981

What is sequelize?

797

Explain foreign key in sql server?

1043

Explain the phases a transaction has to undergo?

1080

How do I check if log truncation is blocked in sybase?

837

Explain the concept of acid properties in dbms?

1117

How to Join tables on common columns.

1203

What do you understand by physical_only option in dbcc checkdb?

995

What is ceil and floor in oracle?

1086

Explain cross join or cartesian product in sql?

904

Do you know what is difference between index seek vs. Index scan?

967

How to use user defined functions in expressions?

1116

For More Un-Answered { Databases } Questions Click Here