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 }

What does an inner join do?

1179

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

962

What is the maximum size of mysql database?

955

how many ways we can we find the current date using mysql? : Sql dba

1099

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

555

Difference between data and information, and how are they related in a database?

975

What are the uses of append query?

845

Explain few examples of stored procedure over triggers?

1042

how to restore particular schema from rman full backup?

1754

How to return top 5 rows in oracle?

1062

Explain the purpose of oracle real application clusters (rac)?

Which sql server table is used to hold the stored procedure script?

948

Mention a query to calculate the even and odd records from a table

964

What you can use regular expression for in mysql?

946

What is a staging area? Do we need it?

For More Un-Answered { Databases } Questions Click Here