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 the advantages of sql?

1108

What is difference between pls_integer and integer?

1015

How do you declare a constant?

1019

Which data type is a composite type?

1043

How do you bind variables in pl sql?

1172

How many types of literals are available in pl sql?

1184

What is difference between cursor and ref cursor?

1 1505

Does execute immediate commit?

1296

What is delimiter in pl sql?

1107

What is forward declaration in pl sql?

1149

Explain the uses of a database trigger?

1096

How do you run a query?

1060

Why do we need cursor in pl sql?

1192

What is a pragma statement?

1345

What are the main features of cursor?

1119

Un-Answered Questions { Databases }

Can we use commit inside the trigger? If not then how can we save the transaction made by the trigger?

910

How do you determine the current isolation level? : Transact sql

1218

What is serializable?

1097

What is called dbms?

1159

What are the different types of data tables?

959

What do you mean by denormalization?

1105

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2794

What is database migration?

1017

What is a node in neo4j?

What is the difference between a delete command and truncate command?

1043

How to include numeric values in sql statements?

1070

What is materialized view in sql?

963

Define left outer join in sql server joins?

1015

What is the cartesian product of table?

1081

What happens when converting big values to integers?

1069

For More Un-Answered { Databases } Questions Click Here