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 would you determine what sessions are connected and what resources they are waiting for?

2 8840

Describe what redo logs are.

1 5172

How would you force a log switch?

4 14026

Give two methods you could use to determine what DDL changes have been made.

2 11629

What does coalescing a tablespace do?

1 15608

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 7273

Name a tablespace automatically created when you create a database.

5 12877

When creating a user, what permissions must you grant to allow them to connect to the database?

3 8947

How do you add a data file to a tablespace?

3 8063

How do you resize a data file?

2 14206

What view would you use to look at the size of a data file?

3 9005

What view would you use to determine free space in a tablespace?

3 9533

How would you determine who has added a row to a table?

4 11504

How can you rebuild an index?

6 14119

Explain what partitioning is and what its benefit is.

2 7534

Un-Answered Questions { Databases }

Does postgres cache queries?

835

What happen when an index does not fit into ram?

Can we call procedure inside function in oracle?

1153

What is a table called in mongodb?

What is odi studio?

639

Explain the role of indexing in databases?

1191

What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?

611

What is the phantom problem?

1047

What are few of the schema objects that are created using PL/SQL?

1085

In mysql, what is joins? Explain

1034

How to delete an existing row from a table in oracle?

1132

Advantages and disadvantages of stored procedure?

1172

List the advantages of using stored procedures?

1112

How do I edit a stored procedure in sql server?

974

What is blob in postgresql?

976

For More Un-Answered { Databases } Questions Click Here