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

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

1 4080

What is advantage of having disk shadowing/ Mirroring ?

1 4244

How will you create multiple rollback segments in a database ?

1 4402

What is the functionality of SYSTEM table space ?

3 7731

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

1 3723

What is meant by free extent ?

2 5340

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

1 4809

What is meant by redo log buffer ?

3 7252

What is the role of PCTFREE parameter is Storage clause ?

2 6103

What is use of Rollback Segments In Database ?

4 6887

What is a Rollback segment entry ?

TCS,

3 8179

How will you monitor the space allocation ?

3 8623

What is meant by recursive hints ?

1 4634

What is the OPTIMAL parameter ?

TCS,

1 6269

What is Database Buffers ?

4 11829

Un-Answered Questions { Databases }

What are the differences between char and varchar2 in oracle?

1246

What is the difference between a view and a stored procedure?

1090

How to create a new view in mysql?

963

Which is faster innodb or myisam?

1099

What is the difference between couchdb and rdbms?

What is difference between db2 and sql?

1046

In which sql server version report builder introduced?

152

What are the three basic rules which are to be followed for the relational model of the database?

1068

WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?

3007

What do we mean by record group in oracle forms?

1132

According to you what goes into making the best database administrator? : sql server database administration

1023

How many row comparison operators are used while working with a subquery?

1073

How do you rename a table in mysql?

1102

What is the recommended total size of your memory optimized tables?

1005

What are date and time data types in ms sql server?

1160

For More Un-Answered { Databases } Questions Click Here