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

Where the integrity constrints are stored in Data Dictionary?

1 6622

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

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

6 34235

What is ON DELETE CASCADE?

3 11409

Difference between SUBSTR and INSTR?

3 36037

What are the usage of SAVEPOINTS?

5 17827

What is correlated sub-query?

Oracle,

7 42752

What is difference between TRUNCATE & DELETE?

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

16 46413

What is the Subquery?

4 7831

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

4 14574

Explain UNION,MINUS,UNION ALL, INTERSECT?

1 13391

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

3 14085

What are the pre requisites?

1 5626

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

Saama Tech,

6 34134

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

TCS,

5 20734

What is ROWID?

8 19912

Un-Answered Questions { Databases }

What are the different types of sub-queries?

1090

What is filestream?

1049

What is sql server programming?

1091

What are out-of-range errors with date and time literals?

1094

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

1124

What are the ansi data types supported in oracle?

991

Why do we need cursors in pl sql?

1157

Does a server store data?

954

if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

1946

What is the difference between mysql_fetch_assoc and mysql_fetch_array?

1149

What are different types of views?

987

Why do we use stored procedures in sql server?

998

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1190

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

1021

How do I create a foreign key in postgresql?

802

For More Un-Answered { Databases } Questions Click Here