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

What is the use of RECORD option in EXP command ?

1 3937

What is the use of PARFILE option in EXP command ?

1 3792

What is the use of PARFILE option in EXP command ?

1 3872

What is the use of ANALYSE ( Ver 7) option in EXP command ?

1 3840

What is the use of CONSISTENT (Ver 7) option in EXP command ?

1 4176

What is use of LOG (Ver 7) option in EXP command ?

1 3524

What is the use of FILE option in IMP command ?

1 3552

What is the use of SHOW option in IMP command ?

1 4235

What is the use of IGNORE option in IMP command ?

1 4472

What is the use of GRANT option in IMP command ?

1 3762

What is the use of INDEXES option in IMP command ?

2 5119

What is the use of ROWS option in IMP command ?

1 3781

What are the components of Physical database structure of Oracle Database?

4 13194

What are the components of Logical database structure of ORACLE database?

4 14795

What is a Tablespace?

5 9960

Un-Answered Questions { Databases }

How many rows can an access table hold?

887

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

2076

What are the differences between char and varchar data types?

1107

What is the maximum size of table in mysql?

1028

Give the different types of rollback segments.

1031

Write a unique difference between a function and a stored procedure.

995

What is delimiter in mysql?

874

How do I find the database name in oracle?

1037

Does union all remove duplicates?

1062

Can we store pictures in the database and if so, how it can be done?

1043

What is the similarity between mongodb and couchdb?

tell me the disaster recovery plan

2516

Why sql query is slow?

997

What is sorting in dbms?

959

What is local temp table?

960

For More Un-Answered { Databases } Questions Click Here