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

Which parameter in Storage clause will reduce no. of rows per block?

1 4012

What is advantage of having disk shadowing/ Mirroring ?

1 4177

How will you create multiple rollback segments in a database ?

1 4319

What is the functionality of SYSTEM table space ?

3 7623

List the factors that can affect the accuracy of the estimations ?

1 3656

What is meant by free extent ?

2 5245

List the Optional Flexible Architecture (OFA) of Oracle database ?

1 4744

What is meant by redo log buffer ?

3 7125

What is the role of PCTFREE parameter is Storage clause ?

2 6010

What is use of Rollback Segments In Database ?

4 6755

What is a Rollback segment entry ?

TCS,

3 8059

How will you monitor the space allocation ?

3 8512

What is meant by recursive hints ?

1 4573

What is the OPTIMAL parameter ?

TCS,

1 6189

What is Database Buffers ?

4 11639

Un-Answered Questions { Databases }

How to add a column ‘salary’ to a table employee_details?

1012

How long can an error message be in raiseerror function?

1002

Are all views updatable ?

1152

If the job running very slow what is the action you do

1892

Is postgresql is nosql?

886

What is pdo in php mysql?

946

What are the five functions of a database?

607

What happens if you insert a duplicate key for the primary key column in ms sql server?

976

What is the difference between the LIKE and REGEXP operators?

1035

What does GEQO stands for in PostgreSQL?

1391

Explain the xml support sql server extends?

1040

what is 'mysqladmin' in mysql? : Sql dba

1025

What are the dmvs?

1014

What is n tier architecture in dbms?

923

What is the significance of null value and why should we avoid permitting null values?

988

For More Un-Answered { Databases } Questions Click Here