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 use of custom fields in report?

1044

What is bit data type?

1083

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1022

How sql server enhances scalability of the database system?

1319

What is partitioned view?

962

Define compound operators?

972

What are the filtered indexes?

1098

Explain transaction server consistency?

1019

What is it unwise to create wide clustered index keys?

1049

Explain transaction server implicit?

1028

Define inner join? Explain with an example?

1052

Explain the difference between function and stored procedure?

997

Explain the architecture of ms sql reporting service?

972

What is lock escalation and what is its purpose?

1030

Explain syntax for dropping triggers?

970

Un-Answered Questions { Databases }

Have you created fact table and dimension tables?

684

What is built-in/administrator?

1080

Can we insert data into materialized view?

994

What are the different operators available in sql?

1059

what is the difference between openrowset and openquery?

1164

How many types of keys are there?

1078

How many primary keys are possible in a table?

966

What is required by oracle rac database to connect to a network?

What is the difference between a unique key and primary key?

1007

Is there a free version of mysql?

994

Explain prerequisites and post activities of oracle database installation

2185

What causes the "snapshot too old" error? How can this be prevented or mitigated?

554

Explain how you can import data from other sources into access database?

899

What are the characteristics of database management system?

1064

What is the difference between having and a where in sql?

1154

For More Un-Answered { Databases } Questions Click Here