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 8748

Describe what redo logs are.

1 5087

How would you force a log switch?

4 13867

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

2 11516

What does coalescing a tablespace do?

1 15508

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

2 7161

Name a tablespace automatically created when you create a database.

5 12680

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

3 8839

How do you add a data file to a tablespace?

3 7904

How do you resize a data file?

2 14099

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

3 8887

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

3 9426

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

4 11361

How can you rebuild an index?

6 13895

Explain what partitioning is and what its benefit is.

2 7372

Un-Answered Questions { Databases }

What is the difference between Normalization and De-normalization?

1099

What is a coalesce? What is the equivalent of oracle/db2 coalesce function in sybase?

908

What is toast in postgres?

936

Explain alternate key, candidate key and composite key in sql server?

916

How can we solve concurrency problems?

1061

What programs use sql?

1017

What is a sql*loader control file?

1274

What are the differences between binary and varbinary?

1063

Is pgadmin free?

788

Does uninstalling mysql delete database?

1028

What is an oracle recycle bin?

1011

In which database can extended stored procedures be added?

908

What is max connections in mysql?

937

Explain snapshot replication.

957

Why do we use cursors?

994

For More Un-Answered { Databases } Questions Click Here