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

Define cursor and its types.

1131

What is database transaction?

939

Define stored procedures.

1012

Enlist some commands of dcl?

1000

Define the relationship between ‘view’ and ‘data independence’.

1120

Explain the terms ‘attribute’ and ‘relations’

1201

What do you understand by e-r model?

1093

What do you understand by ‘database’?

1021

Enlist some commands of ddl, dml, and dcl.

1034

How to improve query performance using index hunting?

1232

Explain the importance of database partitioning.

1042

Define weak entity set.

1134

What do you understand by data independence? What are its two types?

1122

What are the disadvantages of a query?

1096

Explain primary key and composite key.

1036

Un-Answered Questions { Databases }

What is the sql case statement?

1058

What is the purpose of postgresql?

835

What does the base_object_type column shows in the user.triggers data dictionary view?

1100

Where is the myisam table stored?

1012

Tell me what are the essential components of sql server service broker?

994

How do I debug a stored procedure in sql server?

1185

How do you recover a lost control file?

How do you delete a document from a collection?

How do I start and stop sql server?

1069

What are property classes?

What are schema-level triggers?

1158

How to use "in out" parameter properly?

1108

What do you understand by recursive stored procedures?

1048

What is %s in sql?

1082

How can you log an error to the server event log from a stored procedure?

1175

For More Un-Answered { Databases } Questions Click Here