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?

521

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

508

Do you need a commit after ddl statements?

518

Explain the wait events in statspack report 'enqueue'?

523

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

549

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

590

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

537

What are bind variables and why are they important?

505

Explain force logging feature in 9i.

564

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

548

What operator tests column for the absence of data?

542

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

515

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

571

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

537

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

505

Un-Answered Questions { Databases }

What is pl sql in dbms?

902

Why would someone use a database?

872

What stored by the model?

984

How to rebuild the master database?

1014

What is entity and its types?

867

What is delimiter in mysql trigger?

898

Explain an index?

1095

Explain do view contain data?

941

which backup strategy you are following at ur company

2103

What are the built-in functions used for sending Parameters to forms ?

3309

How easy is netlib to use?

923

What do you understand by triggers and mention the different types of it?

882

What is an implicit commit?

996

What is metadata in dbms?

906

How to convert string to objectid in mongoose?

For More Un-Answered { Databases } Questions Click Here