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 nested transaction?

1101

What are the differences between clustered and non-clustered index?

1033

What is page-level compression?

964

When cursors are useful?

1104

Explain about extended stored procedure?

940

Explain what is “asynchronous” communication in sql server service broker?

917

Define inner join in sql server joins?

1059

What is row-level compre?

1002

Explain about nested stored procedure?

1029

Define left outer join in sql server joins?

960

Can we create clustered index on composite key?

1084

Explain important index characteristics?

1031

Explain about local stored procedure?

972

What is “asynchronous” communication in sql server service broker?

1034

What is bit data type? What's the information that can be stored inside a bit column?

921

Un-Answered Questions { Databases }

Can we join 3 tables in mysql?

959

What is rowtype?

1019

In mongodb how do you use $set to update a nested value?

Can we store videos in mysql database?

939

Explain the use of parfile option in exp command.

1069

How many mysql connections can handle?

892

What are the types of sql commands?

1103

Tell me what is the order in which the sql query is executed?

951

What are the properties of the transactions?

1119

What is MySQL?

1000

What is the contrast amongst drop and truncate?

1034

What is user defined datatypes and when you should go for them?

1016

What are the limitations/drawbacks or ssrs 2008 r2?

139

How to modify an existing user defined function?

1106

A trigger can reference objects outside the current database? State true or false.

1008

For More Un-Answered { Databases } Questions Click Here