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,

1157

How do you implement session management in SQL Server mode?

Cap Gemini,

1099

How many databases Microsoft SQL server provides?

Abacus,

1087

What does Master database contains?

Abacus,

1136

What gets stored inside msdb database?

Abacus,

1247

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

Abacus,

1072

Why Master database is required?

Abacus,

1141

Why SQL Agent is used?

Abacus,

1145

Explain the types of indexes.

Accenture,

1216

How network traffic be reduced by using the stored procedure?

Accenture,

1118

What is a trigger? Why we need it?

Accenture,

996

What is the difference between functions and stored procedures?

Accenture,

1161

How self join is different from outer join?

Blue Star,

1120

What are the different types of indexes?

Blue Star,

1118

What is meant by referential integrity?

Blue Star,

1010

Un-Answered Questions { Databases }

What is pragma in pl sql?

1110

Tell me what is the significance of null value and why should we avoid permitting null values?

984

Is facebook a database?

877

What is partition index in sql server?

1120

What does executeupdate return?

975

What are the steps you must follow to hide sql server instances?

978

What is an index in a database?

979

What is a user view?

746

What do you think of this implementation? Can this be implemented better?

941

What is federation member?

116

write a command to view the content of the table

898

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2270

what are the new features introduced in oracle form services in 11g release 2?

1035

What is a mutating table error and how can you get around it?

1049

what's the difference between a primary key and a unique key? : Sql server database administration

948

For More Un-Answered { Databases } Questions Click Here