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 33968

What is ON DELETE CASCADE?

3 11281

Difference between SUBSTR and INSTR?

3 35811

What are the usage of SAVEPOINTS?

5 17630

What is correlated sub-query?

Oracle,

7 42520

What is difference between TRUNCATE & DELETE?

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

16 45795

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 14451

Explain UNION,MINUS,UNION ALL, INTERSECT?

1 13312

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

3 13971

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 33904

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

TCS,

5 20534

What is ROWID?

8 19672

Un-Answered Questions { Databases }

Can you have more than one key in a database?

937

How to import sql file in postgresql pgadmin 4?

846

what are the new features in SSRS?

134

all the queries used in sql

2657

How to call stored procedure using http soap?

1077

Does inner join return duplicate rows?

976

Can we rename database in mysql?

945

What is the default database in postgresql?

904

Can we use two order by clause in query?

967

What are the types of containers in ssis?

1171

What are the different types of dbmss?

1013

What is recovery manager(rman) backup in Oracle?

1183

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2220

What is checkpoint in sql server?

1157

How to execute mysql query in php?

914

For More Un-Answered { Databases } Questions Click Here