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

Where do you use decode and case statements?

1047

What is the difference between a hot backup and a cold backup in oracle?

1082

Describe the types of sub query?

1060

What are the attributes of the cursor?

1061

What is raw datatype in oracle?

1216

Briefly explain what is literal? Give an example where it can be used?

1093

Explain about the analyze command in oracle?

1113

Difference between cartesian join and cross join?

1095

Point the difference between translate and replace?

1152

What are the major difference between truncate and delete?

1138

What is a sub query? Describe its types?

1075

What is the difference between count (*), count (expression), count (distinct expression)?

1050

Point out the difference between user tables and data dictionary?

1039

What do you mean by merge in oracle and how can you merge two tables?

1011

Difference between the “verify” and “feedback” command?

1433

Un-Answered Questions { Databases }

What is check constraint in sql server?

1052

How to load data files into tables with 'mysqlimport'?

1052

Does sap use sql?

1045

What is a password file in a database and why is it required when a user can be authenticated using data dictionary tables?

What is restrict in sql?

1182

What is view in sql?

955

What is difference between sql and mysql?

1205

What methods do you follow to protect from sql injection attack?

1078

How to define a variable of a specific record type?

1121

Describe mysql transaction properties.

1074

State about the security aspects of stored procedures?

1024

what are cursors? : Sql server database administration

1112

How do you know the all indexes available for a collection?

Please explain what is “asynchronous” communication in sql server service broker?

985

Where is my database stored on the hard disk in ms sql server?

1114

For More Un-Answered { Databases } Questions Click Here