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

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

IBM,

1 4962

What are the advantages of VIEW?

5 34023

How many LONG columns are allowed in a table?

CTS,

6 24384

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

3 16728

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

1 6434

What is Referential Integrity?

IBM,

3 12815

What are the data types allowed in a table?

3 7506

What is an Integrity Constraint?

4 9443

Explain Connect by Prior?

2 11794

What are the types of SQL Statement?

3 20853

What is a transaction?

5 9123

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

6 12965

What is CYCLE/NO CYCLE in a Sequence?

2 9822

What is a database link?

3 8525

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

5 14383

Un-Answered Questions { Databases }

What is rdbms with diagram?

833

Does execute immediate commit?

1153

What does specialization in DBMS mean?

1099

Are resultset updatable?

896

Which are new data types introduced in sql server 2008?

991

What are stored procedures used for?

962

various types of hints and their usage

2627

Can you explain what are commit and rollback in sql?

888

What data types does sybase support?

842

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

902

State the use of couchdb?

What are different types of collation sensitivity?

943

What are the restrictions on external table columns?

995

What causes mysql too many connections?

878

What is blob database?

873

For More Un-Answered { Databases } Questions Click Here