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 user-defined inline table-valued function?

978

Difference between uniqe index and uniqe constraint?

995

What are ddl triggers and types of ddl trigger?

1059

How many non clustered indexes there can be on table ?

931

What are different types of subquery?

1264

Explain few of the new features of sql server 2008 management studio

946

What are “lost updates”?

1016

What command do we use to rename a db, a table and a column?

950

What is the difference between a function and a trigger?

1094

What is t-sql script to take database offline – take database online.

1100

What is a filestream?

1002

What is difference between commit and rollback when used in transactions?

977

Data table as parameter in sql server?

1064

What is the xml datatype?

1093

What is the difference between index seek vs. Index scan?

1036

Un-Answered Questions { Databases }

Define synonym?

1185

what are triggers? : Sql server database administration

922

What is background process in Oracle?

1116

What is postgresql client?

963

How can you delete databases in neo4j?

How do you use a database worksheet?

952

Can you explain the select into statement?

1043

What is the purpose of reports in a database?

899

how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)

2071

What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?

1019

Can the “if update (colname)” statement be used in a delete trigger?

1007

Why more redos are generated when the oracle database is in begin backup mode?

1138

what is table? : Sql dba

1078

What does mysqli stand for?

950

How do I use mysql?

910

For More Un-Answered { Databases } Questions Click Here