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 7428

Give the reasoning behind using an index.

2 6252

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

1 3857

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

1 8149

Give two examples of referential integrity constraints.

1 4803

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 15056

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

HCL,

1 8070

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

1 8700

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

1 5136

How would you go about generating an EXPLAIN plan?

Satyam,

1 4861

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

2604

Explain an ORA-01555

2 7085

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

2 7682

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

1 5196

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 4389

Un-Answered Questions { Databases }

What are privileges and grants?

1067

Explain the etl (extraction, transformation, and loading)?

1001

Why plvtab is considered as the easiest way to access the pl/sql table?

1218

is it important for a database administrator to understand the operating system and file access? : Sql server administration

1037

what is the informix-list@iiug.org mailing list?

How to perform backup for certificates in sql server? : sql server security

1100

You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?

591

What is alternate key?

929

What is a view and what are its advantages?

1116

What is a design view?

932

What is the maximum size of an access database?

859

Can you explain insert, update and delete query?

1066

How do I stop a mysql command?

998

Does a join table need a primary key?

958

What do you understand by a stored procedure?

1092

For More Un-Answered { Databases } Questions Click Here