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 the difference between a Local temporary table and a Global temporary table? How is each one used?

HCL,

2 20068

What are cursors? Name four types of cursors and when each one would be applied?

Adea Solutions,

3 20469

How do you use DBCC statements to monitor various aspects of a SQL server installation?

1 7515

How do you load large data to the SQL server database?

2 11784

How do you check the performance of a query and how do you optimize it?

1 7993

Can XML be used to access data?

2 4127

What is referential integrity and how is it achieved?

Adea Solutions,

1 10960

What is indexing?

AOL,

2214

What is normalization and what are the different forms of normalizations?

2 14473

Difference between server.transfer and server.execute method?

2 12133

What is better - 2nd Normal form or 3rd normal form? Why?

TCS, TPK,

2 11860

Can we rewrite subqueries into simple select statements or with joins? Example?

ASD Lab,

2 9412

What is a function? Give some example?

3 10307

What is a stored procedure?

3 6456

Difference between Function and Procedure-in general?

6 15199

Un-Answered Questions { Databases }

What is a recursive stored procedure?

1257

Explain the advantages of data integration suite in sybase.

937

Can we insert data if clustered index is disabled?

990

What is the role of 8 analysers in mongodb?

Please explain oracle data types with examples?

1132

Mention what is the command syntax for inserting a document?

What are the parts of microsoft access?

992

Explain the phases a transaction has to undergo?

1118

How is postgresql different from oracle?

813

What are the basic functions of a database?

1123

How many types of indexes are there in mysql?

961

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1268

Is nosql relational?

1004

Define join and name different types of joins?

1058

What is the usage of the distinct keyword?

1279

For More Un-Answered { Databases } Questions Click Here