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

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

TCS,

7 21675

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 11639

How do you switch from an init.ora file to a spfile?

TCS,

4 19988

Explain the difference between a data block, an extent and a segment.

2 10746

Give two examples of how you might determine the structure of the table DEPT.

2 11548

Where would you look for errors from the database engine?

IBM,

2866

Compare and contrast TRUNCATE and DELETE for a table.

7 15849

Give the reasoning behind using an index.

2 8717

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 7646

What type of index should you use on a fact table?

1 3986

Give two examples of referential integrity constraints.

2 8641

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2527

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 24524

What command would you use to create a backup control file?

2 5331

Give the stages of instance startup to a usable state where normal users may access it.

1 3441

Un-Answered Questions { Databases }

What are data regions?

140

Does mongodb use hadoop?

What is system global area (sga) in oracle?

1006

what kind of lan types do you know? : Sql server database administration

994

Does storing of data in stored procedures increase the access time? Explain?

1129

Can we join more than 2 tables in sql?

1036

Can we shrink data file in sql server?

1065

What do you understand by check constraint in sql server?

958

How many indexes per table are allowed in postgresql?

864

Where is match command used in neo4j?

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

2275

Define concurrency control. : Transact sql

1195

What is the datatype of image?

973

Explain what are the advantages of views?

1081

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1048

For More Un-Answered { Databases } Questions Click Here