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

What is the difference between column level constraints and table level constraints?

IBM, TCS,

14 87595

Can we create index on views?

CTS, Syntel, TCS,

19 126026

Can we create more than one index on particular column?

1 6392

What is a cluster?

2 5728

What is the difference between implicit index and explicit index?

TCS,

2 24210

What are virtual columns?

TCS,

2 7285

What is a materialised view?

5 8693

What is the difference between normal and corelated subqueries?

2 9887

what is sql and plsql

6 11342

what is the difference between to_char and to_date functions?

Infosys,

10 67273

what is organisational index?

1 5331

what are the advantages of cursors than procedures?

2 12025

what is the difference between trigger and storedprocedures

Tech Mahindra,

16 32547

What is a Database instance ? Explain?

3 8292

What is Parallel Server ?

3 5871

Un-Answered Questions { Databases }

Does full backup break log chain?

977

Explain by listing some major advantages of dbms.

944

Can you please differentiate between a primary key and a unique key?

1020

How to access postgresql database from another machine?

782

Can you force a query to use a specific index?

963

What are the features of pl sql?

1079

Where do we use connected and un connected lookups?

Is insert autocommit in oracle?

1090

Who created postgresql?

774

What is sql constant?

1045

is it possible to pass an object or table to a procedure as an argument?

1147

Tell me what is use of except clause? How it differs from not in clause?

973

What are the types of lock supported by ?

1057

Who is dba in dbms?

588

when would you go for denormalization? : Sql server database administration

880

For More Un-Answered { Databases } Questions Click Here