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,

1050

What are audit control procedures?

Ernst Young, Thomson Reuters,

953

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

MCN Solutions,

952

What is the Disadvantage of indexed sequential file.

HCL,

1044

Explain Geography datatype in SQL Server

Infosys,

1087

What is the difference between implicit and explicit transaction?

976

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

Axtria, ITC Indian Tobacco Company,

1017

What is SubQuery in SQL Server 2008

HCL,

986

How to find Duplicate Records In table?

HCL,

984

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

HCL,

998

Why is DML provided?

Ernst Young, Thomson Reuters,

1 2626

What are the types of database recovery models?

HCL,

1075

What is function of CUBE ?

HCL,

995

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

Flextronics,

1080

What is order of B+tree?

HCL,

1079

Un-Answered Questions { Databases }

how to include character strings in sql statements? : Sql dba

1021

How to create a scrollable cursor with the scroll option?

959

i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

1951

What is data example?

840

Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.

539

How do I drop a database in mysql?

1078

What are the functions of mysql?

903

How to drop an existing table with "drop table" statements in ms sql server?

1051

In which language couchdb is written?

What is use of dbms?

879

What is data sublanguage?

992

What is execute immediate?

1032

What is the maximum connection pool size?

923

Differentiate between delete and truncate table?

1022

Why does couchdb not use mnesia?

For More Un-Answered { Databases } Questions Click Here