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

Where the integrity constrints are stored in Data Dictionary?

1 6547

What is a join?Explain the different types of joins?

Bank Of India, CitiGroup, Google, ICICI, Saama Tech, SkyTech, TCS,

6 33971

What is ON DELETE CASCADE?

3 11283

Difference between SUBSTR and INSTR?

3 35814

What are the usage of SAVEPOINTS?

5 17633

What is correlated sub-query?

Oracle,

7 42521

What is difference between TRUNCATE & DELETE?

Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,

16 45802

What is the Subquery?

4 7677

If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?

4 14452

Explain UNION,MINUS,UNION ALL, INTERSECT?

1 13313

Can a view be updated/inserted/deleted?If Yes under what conditions?

3 13972

What are the pre requisites?

1 5531

What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?

Saama Tech,

6 33907

What is the fastest way of accessing a row in a table?

TCS,

5 20538

What is ROWID?

8 19673

Un-Answered Questions { Databases }

When sql appeared?

1100

What is latest version of mysql?

1027

Explain materialized views and how they are used.

2443

Explain the various types of oracle report?

1074

How do I apply a custom Ribbon after a user logs into the database? I want to use a different ribbon based upon the users level of security. I have 3 levels.

2387

List out the difference between union and union all in sql server?

990

How many sql databases can you have on one server?

1081

How to delete duplicate records based on single column from a table?

1050

Explain boyce and codd normal form(bcnf)?

958

What is unique key constraint?

1060

How to check if sybase database is up and running?

867

How do I check my drivers?

917

Can you selectively load only those records that you need? : aql loader

1048

What are hotfixes and patches?

946

What are the consideration at tehe migration of Oracle 9i to 10G.

3066

For More Un-Answered { Databases } Questions Click Here