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

Which one is the Best approach to put code, among Triggers and Procedures? Explain?

Sierra Atlantica,

1 5604

Does SQL*Plus contains pl/sql Engine?

TCS,

1 10433

How to find string or key value using pl/sql code?

Ramco,

2 10460

what is the purpose of update command in oracle?

MBT,

7 14107

what is Normalization means..?

AZTEC, Bank Of America, Infosys, TCS,

8 32562

Integrity constraints means..? how many and what are they?

AZTEC,

4 14740

Define 'view' advantage ?

AZTEC, TCS,

2 11767

how to get the automatic backup of the database in the sql server

4 36347

What command do we use to rename a db?

IBM,

5 14136

What are the four main query statements?

Wipro,

7 22468

Which command using Query Analyzer will give you the version of SQL server and operating system?

3 16297

What is the STUFF function and how does it differ from the REPLACE function?

2 20848

What is SQL server agent?

HCL, SAP Labs,

2 10116

What is the purpose of UPDATE STATISTICS?

2 13997

What is de-normalization and when do you do it?

3 9215

Un-Answered Questions { Databases }

What are the objectives of rdbms?

963

What is dba software?

692

How is access different from other microsoft office applications?

839

Is oracel sql developer written in java?

1169

How long can an error message be in raiseerror function?

1045

How mongodb is better than other sql server databases?

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

1000

How to defragment table indexes?

1040

Who are end users in dbms?

1035

What is the difference between nvl and nvl2?

1034

Does mysql automatically index foreign keys?

981

What is serial data type in postgresql?

954

Does index slows down insert statements?

1047

Explain what is raid and what are different types of raid levels?

1094

How many types of literals are available in pl sql?

1166

For More Un-Answered { Databases } Questions Click Here