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

what is sql server? : Sql server database administration

1004

what is denormalization? : Sql server database administration

941

can you instantiate a com object by using t-sql? : Sql server database administration

1010

explain different types of joins? : Sql server database administration

1000

what is a deadlock? : Sql server database administration

1081

what is blocking? : Sql server database administration

1053

explain different types of constraints? : Sql server database administration

963

what is a join and explain different types of joins? : Sql server database administration

970

what protocol both networks use? : Sql server database administration

985

what changed between the previous version of sql server and the current version? : Sql server database administration

1020

Is sql server implemented as a service or an application? : Sql server database administration

977

explain different types of cursors? : Sql server database administration

1102

Do you know the cursor optimization tips?

1007

Explain temporary table vs table variable by using cursor alternative?

1014

Can you explain the disadvantages/limitation of the cursor?

1004

Un-Answered Questions { Databases }

HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE

2238

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2028

Differentiate sql server reporting services vs. Crystal reports?

203

Can you insert NULL in unique column?

1179

Why stored procedures are faster than query?

1039

How do I make an action query?

949

What is sql view?

1052

What is the difference between TRUNCATE and DROP?

1157

What is myisam?

989

Differentiate between a local and a global temporary table?

969

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

897

What is Dependency Injection and provide example?

1135

What are modules in ms access?

800

How to create local server in postgresql?

900

Explain what is a subquery ?

1203

For More Un-Answered { Databases } Questions Click Here