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

What is the use of RECORD option in EXP command ?

1 4047

What is the use of PARFILE option in EXP command ?

1 3882

What is the use of PARFILE option in EXP command ?

1 3977

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

1 3949

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

1 4248

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

1 3618

What is the use of FILE option in IMP command ?

1 3630

What is the use of SHOW option in IMP command ?

1 4320

What is the use of IGNORE option in IMP command ?

1 4551

What is the use of GRANT option in IMP command ?

1 3835

What is the use of INDEXES option in IMP command ?

2 5258

What is the use of ROWS option in IMP command ?

1 3891

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

4 13350

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

4 14989

What is a Tablespace?

5 10186

Un-Answered Questions { Databases }

What is primary key in ms access 2007?

901

What is the tcp/ip port on which sql server runs?

1247

How to create database with physical files specified in ms sql server?

1035

What is a schema in postgres?

852

What is database url?

1045

Can you explain what are commit and rollback in sql?

988

How to get a list of all tables with "sys.tables" view in ms sql server?

1088

What is the max nvarchar size?

1037

What are materialized views & where do we use them? What is a materialized view log?

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

2000

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1199

What is a sequence in a database?

1068

What's the difference between star and snow flake schema?

1094

what are the new features introduced in sql server 2000? : Sql server database administration

980

What are the advantages of using stored procedures in sql server?

1058

For More Un-Answered { Databases } Questions Click Here