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

How free extents are managed in Ver 6.0 and Ver 7.0 ?

IBM,

1 5136

What are the advantages of VIEW?

5 34448

How many LONG columns are allowed in a table?

CTS,

6 24963

Is it possible to use LONG columns in WHERE clause or ORDER BY?

3 17049

Is it possible to access the current value in a session before accessing next value?

1 6608

What is Referential Integrity?

IBM,

3 13189

What are the data types allowed in a table?

3 7782

What is an Integrity Constraint?

4 9866

Explain Connect by Prior?

2 12037

What are the types of SQL Statement?

3 21168

What is a transaction?

5 9541

How to access the current value and next value from a sequence?

6 13469

What is CYCLE/NO CYCLE in a Sequence?

2 10118

What is a database link?

3 8874

If a View on a single base table is manipulated will the changes be reflected on the base table?

5 14812

Un-Answered Questions { Databases }

What is sql*loader?

1285

What is cte sql?

1052

What do we mean by hot backup & cold backup and how are they different?

Mention the differences between local and global temporary tables.

1110

Explain about the architecture of MYSQL?

1022

What is replication server? What is its role in sybase?

1000

Why indexing is used in database?

983

Explain table partitioning in sybase.

974

What is couchdb and why it is used?

What are triggers? Why do we use them? Diff types of triggers? What are magic tables?

1003

How to take user input in pl sql?

1204

How to use clusters?

1016

How do I make an action query?

993

How to drop an oracle database?

600

Explain how are indexes update?

1122

For More Un-Answered { Databases } Questions Click Here