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

Differentiate between ‘delete’, ‘truncate’ and ‘drop’ commands.

1164

What do you understand by data independence?

1110

What do you understand by ‘atomicity’ and ‘aggregation’?

916

Enlist the advantages of dbms.

979

What are the advantages and disadvantages of views in the database?

1079

What do you understand by functional dependency?

924

Define dml compiler.

1039

Define database lock?

920

Explain the terms ‘record’, ‘field’ and ‘table’ in terms of database.

1031

What do you understand by unique key?

1004

Define checkpoint.

1022

When is functional dependency said to be the fully functional dependency?

1124

Name the different data models that are available for database systems.

912

What do you understand by data redundancy?

936

What do you understand by b-trees?

1059

Un-Answered Questions { Databases }

Write a program to fetch first 10 records from a file?

1026

Briefly describe an outer join.

972

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4615

What are the uses of merge?

1182

Explain relational algebra?

944

How do I completely remove mysql from windows?

986

Explain update statistics.

867

What is flashback in Oracle?

1034

Can we call stored procedure in view in sql server?

908

Name and describe few console utilities for ssrs?

288

Explain how can you save or place your msg in a table?

1041

What can be done with microsoft access?

785

What is the purpose of queries in a database?

1065

What is the most common trace flags used with sql server?

1065

how to include comments in sql statements? : Sql dba

962

For More Un-Answered { Databases } Questions Click Here