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 88131

Can we create index on views?

CTS, Syntel, TCS,

19 126659

Can we create more than one index on particular column?

1 6456

What is a cluster?

2 5831

What is the difference between implicit index and explicit index?

TCS,

2 24326

What are virtual columns?

TCS,

2 7427

What is a materialised view?

5 8872

What is the difference between normal and corelated subqueries?

2 9983

what is sql and plsql

6 11591

what is the difference between to_char and to_date functions?

Infosys,

10 67616

what is organisational index?

1 5396

what are the advantages of cursors than procedures?

2 12143

what is the difference between trigger and storedprocedures

Tech Mahindra,

16 33040

What is a Database instance ? Explain?

3 8423

What is Parallel Server ?

3 5987

Un-Answered Questions { Databases }

Explain the terms ‘record’, ‘field’ and ‘table’ in terms of database.

1067

Calculate difference between 2 date / times in oracle sql?

1103

What is a sub query? What are its various types?

1294

Explain the use of dde package in d2k.

What are the 3 main types of search queries?

890

What is function of CUBE ?

1092

What is an Oracle database Full Backup?

1182

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2333

What is the maximum row of a size?

1072

What is the difference between the LIKE and REGEXP operators?

1095

How to check your oracle database 10g xe installation?

1056

How will you add a new style in a table?

854

How to delete duplicate rows in sql server?

1161

List various types of log-based recovery in DBMS.

1033

Why use mysql procedures?

1034

For More Un-Answered { Databases } Questions Click Here