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

Define cursor and its types.

1059

What is database transaction?

886

Define stored procedures.

970

Enlist some commands of dcl?

948

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

1069

Explain the terms ‘attribute’ and ‘relations’

1158

What do you understand by e-r model?

1036

What do you understand by ‘database’?

989

Enlist some commands of ddl, dml, and dcl.

991

How to improve query performance using index hunting?

1185

Explain the importance of database partitioning.

979

Define weak entity set.

1083

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

1079

What are the disadvantages of a query?

1034

Explain primary key and composite key.

990

Un-Answered Questions { Databases }

what are the two integrity rules used in DBMS?

1130

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

1059

How do I start mongodb?

What are table partitions? How is it different with ase 15.0 version?

893

How to execute stored procedure in select statement sql server?

1072

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

2088

What are the types of database management system?

1067

What is the use of the drop option in the alter table command?

603

How to create function without parameter in sql server?

1069

What are the major advantages of dbms software applications such as microsoft access?

697

How to find 3rd highest salary of an employee from the employee table in sql?

1091

How to update multiple rows with one update statement in ms sql server?

1218

How to check database size in sybase iq?

998

What do you understand by a database object?

1081

How to see the table columns used in an index?

1037

For More Un-Answered { Databases } Questions Click Here