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 6446

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

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

6 33641

What is ON DELETE CASCADE?

3 11137

Difference between SUBSTR and INSTR?

3 35565

What are the usage of SAVEPOINTS?

5 17378

What is correlated sub-query?

Oracle,

7 42229

What is difference between TRUNCATE & DELETE?

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

16 44988

What is the Subquery?

4 7503

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

4 14263

Explain UNION,MINUS,UNION ALL, INTERSECT?

1 13214

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

3 13793

What are the pre requisites?

1 5433

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

Saama Tech,

6 33618

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

TCS,

5 20276

What is ROWID?

8 19349

Un-Answered Questions { Databases }

What is sybase infomaker?

883

What are the advantages and disadvantages of views in the database?

991

When to use inner join and left join?

906

Why Master database is required?

1060

Is mysqli deprecated?

894

What are the parameters that we can pass through a stored procedure?

1000

What do you understand by the analysis services in sql server?

895

What is the difference between getdate and sysdatetime?

942

What is “namespace” in mongodb?

What do you mean by merge in oracle and how can we merge two tables?

1003

Explain how Neo4j stores primitive array?

what is an index? : Sql dba

933

List various types of log-based recovery in DBMS.

939

What are the advantages of the mirroring?

1015

What is psql?

776

For More Un-Answered { Databases } Questions Click Here