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

What are a query and state the different types of queries and their uses?

1 1086

What are temporal data types in oracle?

1 1197

What is a relational database management system?

1 1211

What is difference between cartesian join and cross join?

1 1201

Explain the difference between a procedure and a function? What do you understand by those terms?

1 1164

Are truncate and delete commands same? If so why?

1 1227

How do we get field details of a table?

1 1052

What is varray?

1 1229

What is a cursor variable?

1 1244

Can we store pictures in the database and if so, how it can be done?

1 1116

How do we display rows from the table without duplicates?

1 1045

What are the differences between lov and list item?

1 1185

How do we represent comments in oracle?

1 1130

What do you mean by group by clause?

1 1117

What do you know about normalization? Explain in detail?

1 1036

Un-Answered Questions { Databases }

What are the properties of the transaction?

1069

What is the best sql course?

1046

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1897

What is normalization and what are the advantages of it?

1054

Does view occupy space?

1007

how many tables will create when we create table, what are they? : Sql dba

1140

What is self contained sub query?

1138

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1064

Do we need to rebuild index after truncate?

1132

Are you familiar with user exits in reports?

If a cursor is open, how can we find in a pl/sql block?

1235

How to put more than 1000 values into an oracle in clause?

1110

What is an indexed view?

1018

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1128

define sql insert statement ? : Sql dba

1094

For More Un-Answered { Databases } Questions Click Here