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

2 8744

Describe what redo logs are.

1 5082

How would you force a log switch?

4 13862

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

2 11506

What does coalescing a tablespace do?

1 15505

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

2 7158

Name a tablespace automatically created when you create a database.

5 12671

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

3 8837

How do you add a data file to a tablespace?

3 7899

How do you resize a data file?

2 14097

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

3 8881

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

3 9421

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

4 11358

How can you rebuild an index?

6 13889

Explain what partitioning is and what its benefit is.

2 7368

Un-Answered Questions { Databases }

What are the set operators in sql?

1076

Why do we use group by and order by function in mysql?

923

What is the use of tempdb? What values does it hold?

1073

What are “unrepeatable reads”?

1237

What is the difference between mongodb and cassandra?

How do I restore a mysql database?

1090

In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...

3203

How do I install and use mysql?

951

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1072

What is ase database?

1022

What is microsoft access database?

903

Explain a segment?

1093

Explain table queries and select queries.

822

What's new in sql management studio for sql server? : sql server management studio

1068

What is the requirement of self-join?

1133

For More Un-Answered { Databases } Questions Click Here