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

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

TCS,

7 21881

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 11739

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

TCS,

4 20114

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

2 10808

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

2 11655

Where would you look for errors from the database engine?

IBM,

2897

Compare and contrast TRUNCATE and DELETE for a table.

7 16047

Give the reasoning behind using an index.

2 8787

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

2 7734

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

1 4037

Give two examples of referential integrity constraints.

2 8734

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?

2580

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

5 24723

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

2 5429

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

1 3491

Un-Answered Questions { Databases }

How can we view last record added to a table?

1110

How to save query output to a local file?

1089

What is postgresql? Explain the history of postgresql.

942

What do you mean by cql?

What are the purposes and advantages stored procedure?

1020

What is mysql default port number?

1057

Can you tell the difference between mysql_fetch_object and mysql_fetch_array?

1050

what are the disadvantages of mysql? : Sql dba

1212

What is a subquery in a select query statement in ms sql server?

1191

i have cleared the nic test...please send me the interview questions if anyone have them.... my email id is v84priya@gmail.com

1940

What are “lock” hints?

1108

How important is to list the column names when doing an insert?

1112

You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

319

What do you understand by nosql databases?

What is the purpose of a sql?

1046

For More Un-Answered { Databases } Questions Click Here