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

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

Sierra Atlantica,

1 5496

Does SQL*Plus contains pl/sql Engine?

TCS,

1 10346

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

Ramco,

2 10346

what is the purpose of update command in oracle?

MBT,

7 13893

what is Normalization means..?

AZTEC, Bank Of America, Infosys, TCS,

8 32230

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

AZTEC,

4 14576

Define 'view' advantage ?

AZTEC, TCS,

2 11666

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

4 36190

What command do we use to rename a db?

IBM,

5 13936

What are the four main query statements?

Wipro,

7 22254

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

3 16153

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

2 20736

What is SQL server agent?

HCL, SAP Labs,

2 9971

What is the purpose of UPDATE STATISTICS?

2 13913

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

3 9058

Un-Answered Questions { Databases }

Write a code to select distinct records without using the DISTINCT keyword.

1115

How to create an oracle database manually?

1086

What is index hunting and how does it help in improving query performance?

1995

What is the difference between count () and rowcount ()?

1029

What is the difference between cross join and natural join?

1022

Explain what is sql?

1119

What are the different types of nosql databases? Give some examples.

How can you see all indexes defined for a table?

1121

What is ordbms with example?

918

What is dynamic query?

977

How does a covering index work?

962

What are the ansi data types supported in oracle?

947

Provide an explanation about write ahead logging?

793

What is 2nf in database?

1008

How to create a new table in a given schema?

1189

For More Un-Answered { Databases } Questions Click Here