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 does asynchronous call backs means?

Alcatel-Lucent,

1093

How do you implement session management in SQL Server mode?

Cap Gemini,

1044

How many databases Microsoft SQL server provides?

Abacus,

1043

What does Master database contains?

Abacus,

1092

What gets stored inside msdb database?

Abacus,

1213

What is the use of tempdb? What values does it hold?

Abacus,

1017

Why Master database is required?

Abacus,

1074

Why SQL Agent is used?

Abacus,

1083

Explain the types of indexes.

Accenture,

1141

How network traffic be reduced by using the stored procedure?

Accenture,

1064

What is a trigger? Why we need it?

Accenture,

958

What is the difference between functions and stored procedures?

Accenture,

1111

How self join is different from outer join?

Blue Star,

1079

What are the different types of indexes?

Blue Star,

1059

What is meant by referential integrity?

Blue Star,

965

Un-Answered Questions { Databases }

What does select * from mean in sql?

3104

What is sql stored procedure?

1035

Is postgresql a language?

784

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1014

List some of the rules that apply to creating and using a ‘view’

831

How to login to the server without an instance?

1128

What is auto increment?

951

How to drop all foreign keys in database?

1000

What is different type of rman backup?

625

What is oracle in java?

927

Is mongodb a graph database?

Explain what are the restrictions that views have to follow? : sql server architect

753

Does view contain data?

995

What is query log in mysql?

915

What joins are and how you can open the database in access?

823

For More Un-Answered { Databases } Questions Click Here