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

HCL,

2 19986

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

Adea Solutions,

3 20341

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

1 7464

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

2 11698

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

1 7938

Can XML be used to access data?

2 4043

What is referential integrity and how is it achieved?

Adea Solutions,

1 10886

What is indexing?

AOL,

2134

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

2 14361

Difference between server.transfer and server.execute method?

2 12048

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

TCS, TPK,

2 11739

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

ASD Lab,

2 9320

What is a function? Give some example?

3 10189

What is a stored procedure?

3 6323

Difference between Function and Procedure-in general?

6 15018

Un-Answered Questions { Databases }

What is the use of custom fields in report?

1015

When would you use it?

1006

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2321

What is cluster control?

843

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2175

What is function and procedure?

1042

what is rdbms? : Sql dba

1022

How can we force the database to use the user specified rollback segment?

1157

What is difference between mongodb and dynamodb?

What is a heap table?

973

Explain what is the function of sql server agent windows service?

1005

How do I open microsoft access?

879

What is normalization in a database?

1169

Is primary key a clustered index?

983

What is Normalization and its different forms?

1044

For More Un-Answered { Databases } Questions Click Here