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

Compare and contrast TRUNCATE and DELETE for a table.

3 7419

Give the reasoning behind using an index.

2 6242

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

1 3856

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

1 8145

Give two examples of referential integrity constraints.

1 4797

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?

3 15046

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

HCL,

1 8059

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

1 8695

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

1 5127

How would you go about generating an EXPLAIN plan?

Satyam,

1 4855

How would you go about increasing the buffer cache hit ratio?

2599

Explain an ORA-01555

2 7076

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

2 7670

How would you determine the time zone under which a database was operating?

1 5188

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 4387

Un-Answered Questions { Databases }

What is use of package in pl sql?

1013

How do I add a foreign key in pgadmin?

910

Why union all is faster than union?

913

Write a query to remove duplicate rows from a table?

889

What is Cross Join and in which scenario do we use Cross Join?

1013

What does pragma mean?

1054

What is primary key in ms access 2007?

843

how will add additional conditions in sql?

1103

Explain acid?

1080

What type of join is sql join?

982

What is the difference between deallocate cursor and close cursor?

1259

Is dynamodb a mongodb?

What do you know about couchdbkit?

How can you make a database as your current database?

1050

What is rds instance?

813

For More Un-Answered { Databases } Questions Click Here