Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3239)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3312)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1391)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

What are the roles and user accounts created automatically with the database ?

1 3174

What are the database administrators utilities avaliable ?

2 3011

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

1 3174

What is a trace file and how is it created ?

2 3150

What are roles ? How can we implement roles ?

2 4543

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

1 5055

How can you enable automatic archiving ?

2 4806

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

2 6346

What is the use of ANALYZE command ?

3 6058

How can we reduce the network traffic ?

Keane India Ltd,

3 4933

What is snapshots ?

2 5097

What are the various type of snapshots ?

3 4613

Differentiate simple and complex, snapshots ?

2 4205

What dynamic data replication ?

2 5686

How can you Enforce Refrencial Integrity in snapshots ?

1 3577

Un-Answered Questions { Databases }

give the syntax of grant and revoke commands? : Sql dba

607

How to connect with firebird database in delphi using tsqlconnection?

Explain entity set?

581

i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

1563

What are the basic features of ms access?

411

What is exporting and importing utility?

603

Is microsoft access difficult to learn?

412

Is sql server implemented as a service or an application? : Sql server database administration

505

How do I start mysql?

486

Explain table and field in sql?

576

What is difference between logical standby database and physical standby database?

285

Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it

1692

Is sql better than access?

534

Explain entity type?

627

Operators used in select statements are?

485

For More Un-Answered { Databases } Questions Click Here