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

Whether any commands are used for months calculation? If so, what are they?

1113

What is difference between truncate and delete?

1067

What are the benefits of ordbms?

1101

What is a oracle database?

1075

What are the various oracle database objects?

1164

Explain the characteristics of oracle dba?

1143

Explain integrity constraint?

1174

In which language oracle has been developed?

1092

Difference between varchar and varchar2 data types?

1210

What is hash cluster in oracle?

1193

What is the parameter mode that can be passed to a procedure?

1069

How many memory layers are in the oracle shared pool?

1211

What are nested tables?

1184

How do we get field detail of a table?

1099

What are the roles of dba?

1097

Un-Answered Questions { Databases }

Explain materialized views and how they are used.

2461

What is use of package in pl sql?

1033

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1127

Explain what are clusters?

1131

How you can change a cross join into an inner join?

996

Given a table which contains some rows with duplicate keys, how would you remove the duplicates?

864

How does one get the view definition of fixed views/tables?

1036

Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.

1147

What is difference between delete and truncate commands?

1112

What is apply operator in sql?

1026

How to change system global area (sga) in oracle?

1033

How we get sum of column.

1028

What port does mongodb use?

How do I disconnect mysql workbench?

1087

What are different types of statements supported by sql?

1176

For More Un-Answered { Databases } Questions Click Here