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

Oracle (3253)
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?

606

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

578

Do you need a commit after ddl statements?

603

Explain the wait events in statspack report 'enqueue'?

615

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

631

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

691

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

623

What are bind variables and why are they important?

586

Explain force logging feature in 9i.

645

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

625

What operator tests column for the absence of data?

638

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

592

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

683

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

623

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

580

Un-Answered Questions { Databases }

What is 'mysqlcheck'?

1073

What are the drawbacks of reporting in ssrs?

159

Do you know what is bit data type and whats the information that can be stored inside a bit column?

1000

What is a covered index?

987

What is Java Pool in Oracle?

1245

What is a full join?

1043

What is the difference between "as" and "is" in an oracle stored procedure?

1046

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

1055

What is microsoft access write its features?

850

What is mysql_pconnect?

969

What is the basic form of sql query?

996

Is postgresql faster than mysql?

890

How to drop an existing schema in ms sql server?

1145

What is a junior dba?

670

What is the option that can be used in PostgreSQL to find out how the query optimizer is evaluating the query given?

1369

For More Un-Answered { Databases } Questions Click Here