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 20064

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

Adea Solutions,

3 20466

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

1 7513

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

2 11782

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

1 7989

Can XML be used to access data?

2 4126

What is referential integrity and how is it achieved?

Adea Solutions,

1 10959

What is indexing?

AOL,

2210

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

2 14471

Difference between server.transfer and server.execute method?

2 12130

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

TCS, TPK,

2 11857

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

ASD Lab,

2 9408

What is a function? Give some example?

3 10306

What is a stored procedure?

3 6454

Difference between Function and Procedure-in general?

6 15194

Un-Answered Questions { Databases }

What are aggregate functions in sql?

1225

Is mongodb big data?

What is the use of a namespace in mongodb?

How long does replica set failover take?

What is primary key and foreign key with example?

986

Can you use order by when defining a view?

1022

What are the two characteristics of a primary key?

1035

How do you set up tablespaces during an oracle installation?

655

How oracle flex asm works?

What is right join sql?

1016

Explain about the features of sybase iq?

1070

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2288

What are the advantages to use stored procedures?

1184

What is the max nvarchar size?

1035

Can a foreign key be a duplicate?

968

For More Un-Answered { Databases } Questions Click Here