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 19978

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

Adea Solutions,

3 20321

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

1 7455

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

2 11692

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

1 7928

Can XML be used to access data?

2 4038

What is referential integrity and how is it achieved?

Adea Solutions,

1 10879

What is indexing?

AOL,

2131

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

2 14352

Difference between server.transfer and server.execute method?

2 12040

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

TCS, TPK,

2 11732

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

ASD Lab,

2 9309

What is a function? Give some example?

3 10181

What is a stored procedure?

3 6321

Difference between Function and Procedure-in general?

6 15003

Un-Answered Questions { Databases }

how to implement the logic in procedures if the source side data deleted that will reflect the target side table?

691

What is the function of Redo Log in Oracle?

1222

How you provide security to cube? : sql server analysis services, ssas

971

How do I remove duplicate rows from a table in sybase?

915

How to Check if table exists in sql server?

1147

difference of using cursor for loop and open,fetch,close.which one is better

1810

what is a cursor? : Mysql dba

1028

How many companies are using mongodb?

What is the difference between conversions and interfaces? : oracle accounts receivable

1242

How do you optimize a query?

1013

What is pg_catalog in postgres?

925

What is pl sql and why it is used for?

1120

How do you rename a table in mysql?

1036

Explain data independence & its types.

1056

Will the writetext statement activate a trigger?

1106

For More Un-Answered { Databases } Questions Click Here