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

Compare and contrast TRUNCATE and DELETE for a table.

3 7539

Give the reasoning behind using an index.

2 6390

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

1 3920

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

1 8222

Give two examples of referential integrity constraints.

1 4867

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 15185

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

HCL,

1 8181

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

1 8770

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

1 5203

How would you go about generating an EXPLAIN plan?

Satyam,

1 4934

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

2657

Explain an ORA-01555

2 7158

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

2 7777

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

1 5289

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 4470

Un-Answered Questions { Databases }

How do I connect to postgresql on windows?

968

Differentiate between truncate vs delete in mssql?

1168

where do u put the report file

2135

What is foreign key in sql with example?

979

What are the ways tablespaces can be managed and how do they differ?

2450

What is primary key, unique key, and foreign key?

1018

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

2049

Do we consider null values the same as that of blank space or zero?

1022

How to connect to SQL Azure Database by using sqlcmd?

140

How to run the anonymous block again?

1175

How to verify a login name with sqlcmd tool?

1267

What are tuples in sql?

1200

Explain the different index configurations a table can have?

995

How can I add Reporting Services reports to my application?

132

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

1098

For More Un-Answered { Databases } Questions Click Here