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 3927

What is advantage of having disk shadowing/ Mirroring ?

1 4084

How will you create multiple rollback segments in a database ?

1 4210

What is the functionality of SYSTEM table space ?

3 7470

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

1 3570

What is meant by free extent ?

2 5125

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

1 4661

What is meant by redo log buffer ?

3 6969

What is the role of PCTFREE parameter is Storage clause ?

2 5884

What is use of Rollback Segments In Database ?

4 6564

What is a Rollback segment entry ?

TCS,

3 7905

How will you monitor the space allocation ?

3 8369

What is meant by recursive hints ?

1 4501

What is the OPTIMAL parameter ?

TCS,

1 6100

What is Database Buffers ?

4 11440

Un-Answered Questions { Databases }

What is a delete query?

735

Write a query to remove duplicate rows from a table?

837

what is informix binary large object?

How to get the definition of a stored procedure back?

923

what are the different functions in sorting an array? : Sql dba

971

Components of Oracle Data Integrator?

499

How do I add a column to a table in mysql?

853

How can you maintain a relationship between different databases in access?

868

What the different types of replication and why are they used? : sql server DBA

1107

Explain the difference between mysql and mysql interfaces in php?

1010

Is sql free?

889

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

927

How to delete all rows with truncate table statement in ms sql server?

933

Which join condition can be specified using on clause?

901

Which is faster join or subquery in oracle?

934

For More Un-Answered { Databases } Questions Click Here