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

Do you know data definition language, data control language and data manipulation language?

1091

Do you know 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?

1101

How to search for a string in all stored procedure in sql server?

1061

Explain what is scheduled job and how to create it?

1026

Tell me about builtinadministrator?

1046

Do you know what is xpath?

1158

What is public role in sql server?

1218

Explain full-text query in sql server?

1054

Do you know how to make remote connection in database?

1012

Tell me what are the advantages of using stored procedures?

1068

How to make remote connection in database?

1055

Explain what are the different index configurations a table can have?

1167

Tell me what is difference between view and materialized view?

985

Tell me the use of keyword with encryption. Create a store procedure with encryption?

1065

Do you know concepts and capabilities of sql server?

1115

Un-Answered Questions { Databases }

Explain primary key in sql server?

1077

When was mongodb founded?

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2363

How do I restart sql?

1028

How to create a single index for multiple columns?

1086

How to identify current user in ssrs report?

408

What is primary key and foreign key?

1015

How many triggers can be applied on a table?

990

Is rowid unique in oracle?

1049

What is RAID? What are the different types of RAID configurations?

1187

What are data types in pl sql?

1200

How to delete duplicate records based on single column from a table?

1107

Can I remove old files in the move chunk directory in mongodb?

How to check if microsoft access database engine 2010 redistributable is installed?

919

What is a data lock in oracle?

1182

For More Un-Answered { Databases } Questions Click Here