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

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

1054

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?

1060

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

1014

Explain what is scheduled job and how to create it?

971

Tell me about builtinadministrator?

1011

Do you know what is xpath?

1100

What is public role in sql server?

1163

Explain full-text query in sql server?

1017

Do you know how to make remote connection in database?

977

Tell me what are the advantages of using stored procedures?

1026

How to make remote connection in database?

1015

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

1126

Tell me what is difference between view and materialized view?

948

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

1014

Do you know concepts and capabilities of sql server?

1074

Un-Answered Questions { Databases }

What is the purpose of TNS?

1046

Explain sql delete command?

1065

What is the difference between local variables and global variables?

1135

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

2103

Explain replication manager.

835

Write the syntax for creating a collection and dropping a collection in mongodb.

What do you mean by deadlock dbms?

1113

How do I run sql profiler?

1083

What are all types of user defined functions?

1088

Is it ok to shrink transaction log?

1020

What is the difference between set and select?

1110

How can you export data in excel format?

910

what is sub-query? : Transact sql

1113

What are pl/sql cursors?

1063

What is database management used for?

940

For More Un-Answered { Databases } Questions Click Here