Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3239)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3312)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1391)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

What is a data dictionary and how can it be created?

617

Why do we need integrity constraints in a database?

590

What are the different responsibilities of a dba?

308

How can we tune a sql query to optimize the performance of a database?

What is a password file in a database and why is it required when a user can be authenticated using data dictionary tables?

What is rac?

What is table partitioning and why is it required?

What is table partitioning?

What is an explain plan and how does it help in optimizing the sql query?

What is a recovery catalog?

How is incremental backup different from differential backup?

What do you understand by row chaining?

What is tkprof and how can we use it?

How can a single instance environment be converted into rac environment and how will they be different?

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

Un-Answered Questions { Databases }

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

474

How will you monitor replication latency in transactional replication? : sql server replication

618

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

612

How do I convert a spreadsheet to a database?

460

What is a database call?

562

How many types of dimensions in oracle?

276

What is the best postgresql gui tool?

407

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

662

How to drop a stored procedure in oracle?

592

what are the security recommendations while using mysql? : Sql dba

581

What are the four components of a database system?

420

What is a result set object returned by odbc_exec()?

554

Is mysql still relevant?

522

What is group by in sql?

550

How to write date and time literals in oracle?

559

For More Un-Answered { Databases } Questions Click Here