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

How can i Relate Tables in SSIS

HCL,

1081

What are audit control procedures?

Ernst Young, Thomson Reuters,

990

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

MCN Solutions,

984

What is the Disadvantage of indexed sequential file.

HCL,

1084

Explain Geography datatype in SQL Server

Infosys,

1129

What is the difference between implicit and explicit transaction?

1011

Tell me about joins in database system and explain each in detail.

Axtria, ITC Indian Tobacco Company,

1046

What is SubQuery in SQL Server 2008

HCL,

1021

How to find Duplicate Records In table?

HCL,

1015

What is the beast way to write CTE in SQL Server ?

HCL,

1045

Why is DML provided?

Ernst Young, Thomson Reuters,

1 2691

What are the types of database recovery models?

HCL,

1124

What is function of CUBE ?

HCL,

1046

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

Flextronics,

1136

What is order of B+tree?

HCL,

1107

Un-Answered Questions { Databases }

What language does oracle use?

1100

What is a junior dba?

620

How to increment dates by 1 in oracle?

1085

What is difference between mongodb and mysql?

917

What is normalization in sql?

1011

What are functions in the sql server?

1218

What does dml mean?

986

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

1041

How to attach adventureworkslt physical files to the server?

1106

Where is my mongodb database?

Explian rowid, rownum? What are the psoducolumns we have?

1001

What is advantage of dbms?

1011

Explain what are partitioned views and distributed partitioned views?

943

What is bson and how can restore this file in mongodb?

Explain what is gridfs in mongodb?

For More Un-Answered { Databases } Questions Click Here