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

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

IBM, TCS,

14 88043

Can we create index on views?

CTS, Syntel, TCS,

19 126539

Can we create more than one index on particular column?

1 6446

What is a cluster?

2 5811

What is the difference between implicit index and explicit index?

TCS,

2 24307

What are virtual columns?

TCS,

2 7412

What is a materialised view?

5 8850

What is the difference between normal and corelated subqueries?

2 9964

what is sql and plsql

6 11549

what is the difference between to_char and to_date functions?

Infosys,

10 67556

what is organisational index?

1 5386

what are the advantages of cursors than procedures?

2 12126

what is the difference between trigger and storedprocedures

Tech Mahindra,

16 32971

What is a Database instance ? Explain?

3 8405

What is Parallel Server ?

3 5970

Un-Answered Questions { Databases }

Can you explain about buffer cash and log cache in sql server?

998

What do you mean by the term 'normalization'?

1292

what functionality does oracle provide to secure sensitive information?

1055

How would you determine what sessions are connected and what resources they are waiting for?

2180

What is dml and ddl?

1013

What is cold data?

1018

Can we create table in function?

1023

What are the parts of microsoft access?

992

Why do we partition data?

1083

Explain difference between cross join and full outer join?

1068

What are the different mysql database engines?

1238

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1161

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1222

What is the difference between value type and reference type?

992

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1119

For More Un-Answered { Databases } Questions Click Here