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

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

1230

What do you understand by data independence?

1172

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

963

Enlist the advantages of dbms.

1022

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

1121

What do you understand by functional dependency?

970

Define dml compiler.

1086

Define database lock?

968

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

1067

What do you understand by unique key?

1028

Define checkpoint.

1088

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

1168

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

956

What do you understand by data redundancy?

981

What do you understand by b-trees?

1105

Un-Answered Questions { Databases }

Does postgresql have a gui?

859

How to execute stored procedure and set temp table in sql server?

1101

Differentiate between etl testing and manual testing.

What are the different ways you can create databases in sql server?

1159

Mention the differences between having and where clause.

1122

What do you understand by physical_only option in dbcc checkdb?

1026

did u received a single file or multiple files

2063

How to define Data Block size in Oracle?

1172

i have windows-xp processor with P4 system. whenever I tried to download foxpro for windows 2.6 on windows XP, my operating system failed to install foxpro for windows 2.6.please. how could i download , install & run foxpro for windows 2.6 easily on windows XP ?

2087

What is the difference between a query and a report?

1064

What is dbcc?

1181

How many sectors are in a partition?

1121

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

1109

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1793

What is a result set object returned by odbc_exec()?

1079

For More Un-Answered { Databases } Questions Click Here