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 3786

What are the database administrators utilities avaliable ?

2 3870

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

1 3921

What is a trace file and how is it created ?

2 3991

What are roles ? How can we implement roles ?

2 5434

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

1 5750

How can you enable automatic archiving ?

2 5991

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

2 7304

What is the use of ANALYZE command ?

3 7148

How can we reduce the network traffic ?

Keane India Ltd,

3 6219

What is snapshots ?

2 6143

What are the various type of snapshots ?

3 5579

Differentiate simple and complex, snapshots ?

2 5119

What dynamic data replication ?

2 6569

How can you Enforce Refrencial Integrity in snapshots ?

1 4268

Un-Answered Questions { Databases }

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2356

How to connect a database with sql express.?

1067

Is it possible to update the views? If yes, how, if not, why?

1031

Do you know what are the steps to process a single select statement?

979

What are the different type of replication in sql server?

985

What are the parts of microsoft access?

932

How do I limit the number of rows returned by an oracle query after ordering?

1173

How do you query pgadmin?

825

Explian rowid, rownum? What are the psoducolumns we have?

1006

Can we create table in function?

969

what are the default admin accounts in Oracle 10g ?

972

What are the authentication modes in sql server? How can it be changed?

1135

Are dml statements autocommit?

1050

What is sql table?

978

What are triggers in mysql?

931

For More Un-Answered { Databases } Questions Click Here