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

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

577

How do you put database is archivelog mode, explain procedure?

549

Do you need a commit after ddl statements?

561

Explain the wait events in statspack report 'enqueue'?

577

What is the difference between raid 5 and raid 10? Which is better for oracle?

589

What is the difference between truncate and delete? Why is one faster?

648

Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?

587

What are bind variables and why are they important?

543

Explain force logging feature in 9i.

608

Which rman command is used to create an exact replica of a database innew host?

593

What operator tests column for the absence of data?

599

System tablespace cant be exported from one database and imported into another why?

555

Explain the wait events in statspack report 'db sequential real'?

636

Explain the wait events in statspack report 'db scattered read'?

581

What is your favorite tool for day-to-day oracle operation?

548

Un-Answered Questions { Databases }

Why it is recommended to avoid referencing a floating point column in the where clause?

964

Which function is used to create an index?

Explain the steps to use transact-sql cursor?

1062

When we should use @@error?

965

explain the storage models of olap? : Sql server database administration

958

How big can a mongodb be?

What is an anonymous block?

1242

Explain the differences between rdbms and graph database?

explain the options of myisamchk to improve the performance of a table. : Sql dba

1010

Can foreign key have duplicate values?

888

What are the types of rdbms?

898

Explain about the sybase group?

909

What is rdbms and also explain its components?

1097

Tell me what is log shipping?

977

Why do we use %rowtype & %type in plsql?

1048

For More Un-Answered { Databases } Questions Click Here