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

What do you mean by merge in oracle?

1035

Describe an oracle table?

1105

What are the differences between primary key and unique key?

1067

What is the difference between substr and instr?

1095

Describe varray?

1118

How can you merge two tables in oracle?

1051

How to store pictures on to the database?

1035

Explain temporal data types in oracle

1135

List out the difference between commit, rollback, and savepoint?

1098

What is transaction server isolation?

1098

What is transaction server auto commit?

1119

What is transaction server explicit transaction?

1093

What is transaction server distributed transaction?

1135

What is transaction server consistency?

1113

Do you know nested transaction?

1006

Un-Answered Questions { Databases }

What does new grouping sets enables you to do?

1091

Can you insert NULL in unique column?

1213

What are different clauses used in sql?

1174

How do I find the sql server version?

1086

What is the difference between substr & instr functions?

1297

When does checkpoint occur?

935

What is mysql server used for?

1001

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

2218

What is database management system explain?

988

How to call stored procedure using http soap?

1134

What the various ways to tune a teradata query

3335

Is primary key indexed by default?

840

What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?

640

What is function and procedure in pl sql?

1125

what is the information that can be stored inside a bit column? : Sql server database administration

1012

For More Un-Answered { Databases } Questions Click Here