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 are the roles and user accounts created automatically with the database ?

1 3797

What are the database administrators utilities avaliable ?

2 3889

What are the minimum parameters should exist in the parameter file (init.ora) ?

1 3931

What is a trace file and how is it created ?

2 4007

What are roles ? How can we implement roles ?

2 5447

What are the steps to switch a database's archiving mode between NO ARCHIVELOG and ARCHIVELOG mode ?

1 5757

How can you enable automatic archiving ?

2 6006

How can we specify the Archived log file name format and destination ?

2 7325

What is the use of ANALYZE command ?

3 7172

How can we reduce the network traffic ?

Keane India Ltd,

3 6233

What is snapshots ?

2 6154

What are the various type of snapshots ?

3 5600

Differentiate simple and complex, snapshots ?

2 5131

What dynamic data replication ?

2 6581

How can you Enforce Refrencial Integrity in snapshots ?

1 4285

Un-Answered Questions { Databases }

How to do paging with oracle?

1012

Where in ms sql server is ’100’ equal to ‘0’?

1103

What is union, minus and interact commands?

1317

How you improve the performance of sql*loader? : aql loader

1024

You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

121

what is checksum in sql server.........???

1700

What is a collation in ms sql server?

1100

How would concatenate strings in mysql?

1047

What is current version of mysql?

987

Can we invoke one form from another in a multi-forms application?

1143

What is the advantages and disadvantages of database management system?

1032

what is an informix instance?

Can an access database be used online?

915

What is the purpose of object explorer and its features? : sql server management studio

1227

What is in place upgrade in sql server?

1062

For More Un-Answered { Databases } Questions Click Here