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 report model project?

142

What is report server project?

149

What is report snapshot in ssrs?

271

What is format parameter in ssrs?

147

What is snapshot parameter in ssrs?

151

What is the report builder?

141

What are the rendering extensions of ssrs?

157

What is the location of pre_defined_functions.

1166

What is a call statement? Explain with an example.

1019

If a cursor is open, how can we find in a pl/sql block?

1169

Explain polymorphism in pl/sql.

1125

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1040

Is it possible to pass parameters to triggers?

1106

What are the different types of triggers?

1139

Explain the uses of database trigger.

1119

Un-Answered Questions { Databases }

What do you mean by super key, primary key, foreign key and candidate key?

974

What is the full meaning of mysql?

969

What is Lock table in SQL?

1476

What is the difference between SQL notification and SQL invalidation?

1198

What is the maximum number of columns in sql table?

1176

How to connect sql server management studio express to sql server 2005 express?

1049

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

2763

How to load data files into tables with 'mysqlimport'?

1001

Is sql workbench free?

1005

What is difference between equi join and natural join?

1047

What stored by the tempdb ? : sql server database administration

1057

How can I insert images into a Mysql database?

1058

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2266

How to do login in mysql with unix shell.

1112

How to unlock the sample user account in oracle?

1018

For More Un-Answered { Databases } Questions Click Here