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 7425

Give the reasoning behind using an index.

2 6249

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 8149

Give two examples of referential integrity constraints.

1 4801

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 15050

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

HCL,

1 8067

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

1 8698

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

1 5133

How would you go about generating an EXPLAIN plan?

Satyam,

1 4858

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

2601

Explain an ORA-01555

2 7083

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

2 7679

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

1 5194

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 4389

Un-Answered Questions { Databases }

What is wal in postgresql?

868

Differentiate sql server reporting services vs. Crystal reports?

203

What do you understand by the oracle?

551

Explain the use of assign statement in progress database?

905

What is SQL Tuning Advisor in Oracle?

1183

explain about mysql and its features. : Sql dba

1018

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2103

Can we do dml on views?

960

What is implicit cursor in pl sql?

1097

How do we select distinct values from a table?

929

What is data modeling with example?

1003

Explain procedure cache?

966

Query to retrieve record for a many to many relationship ?

2521

what is the primary use of the model database? : Sql server administration

1051

How to create an oracle database manually?

1090

For More Un-Answered { Databases } Questions Click Here