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?

1219

Explain full-text query in sql server?

1055

Do you know how to make remote connection in database?

1013

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?

1117

Un-Answered Questions { Databases }

What are the advantages of manual database?

1016

Differences between clustered and non-clustered in sybase?

954

What is MTTR advisor in Oracle?

1145

How to use the inserted and deleted pseudo tables?

1010

What does clouddb kit mean?

What is “asynchronous” communication in sql server service broker?

1084

What is server-level principal?

122

What is linq to sql?

1183

Explain what is it unwise to create wide clustered index keys?

1028

How can I detect whether a given connection is blocked?

1120

What is the use of lockboxes? : oracle accounts receivable

1270

What are different types of collation sensitivity?

1031

What is the difference between mysql and oracle?

1015

What is the difference between the application object and session object?

1129

Do I need to pay for mysql?

954

For More Un-Answered { Databases } Questions Click Here