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

1 3876

What are the database administrators utilities avaliable ?

2 4015

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

1 4013

What is a trace file and how is it created ?

2 4103

What are roles ? How can we implement roles ?

2 5560

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

1 5834

How can you enable automatic archiving ?

2 6094

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

2 7419

What is the use of ANALYZE command ?

3 7283

How can we reduce the network traffic ?

Keane India Ltd,

3 6376

What is snapshots ?

2 6252

What are the various type of snapshots ?

3 5721

Differentiate simple and complex, snapshots ?

2 5236

What dynamic data replication ?

2 6686

How can you Enforce Refrencial Integrity in snapshots ?

1 4381

Un-Answered Questions { Databases }

How do I find the sql server version?

1096

Can delete statement be rollbacked?

1038

What are the different SQL Server Versions you have worked on?

1071

how many tables will create when we create table, what are they? : Sql dba

1129

Have you used lexical parameters in reports?

Why should you use or avoid select * statements?

1094

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2174

What are the types of database explain each of them briefly?

1039

What are different types of constraints?

983

What are the kinds of subquery?

1087

What is the current version of postgresql?

1144

Why use identity in sql server?

1185

How to put more than 1000 values into an oracle in clause?

1095

what are aggregate and scalar functions? : Sql dba

1116

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1177

For More Un-Answered { Databases } Questions Click Here