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 5609

Does SQL*Plus contains pl/sql Engine?

TCS,

1 10434

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

Ramco,

2 10461

what is the purpose of update command in oracle?

MBT,

7 14113

what is Normalization means..?

AZTEC, Bank Of America, Infosys, TCS,

8 32567

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

AZTEC,

4 14752

Define 'view' advantage ?

AZTEC, TCS,

2 11767

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

4 36352

What command do we use to rename a db?

IBM,

5 14139

What are the four main query statements?

Wipro,

7 22478

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

3 16303

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 10119

What is the purpose of UPDATE STATISTICS?

2 14006

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

3 9215

Un-Answered Questions { Databases }

What is the purpose of mysql database?

973

How oracle handles dead locks?

1131

Describe in brief system database.

1077

What is mysql_connect?

1002

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2189

What is the equivalent of oracle/db2 coalesce function in sybase?

936

What port is mysql running on?

987

What is the password of mysql?

1017

What is the biggest advantage of rdbms?

1114

Explain indexing and what are the advantages of it?

1075

How can you handle the –secure-file-priv in mysql?

995

What area unit the various kinds of info compression introduced in sql server 2008?

1141

Can we use where clause with group by?

950

What is a degree of relation?

1069

What is the best free database?

960

For More Un-Answered { Databases } Questions Click Here