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

How are functions and procedures called in PL/SQL?

1 1326

What are the different datatypes available in PL/SQL?

1 1163

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1 1219

What are few of the schema objects that are created using PL/SQL?

1 1089

What is PL/SQL Records?

1 1267

How is a PL/SQL code compiled?

1 1294

What are the key differences between SQL and PL SQL?

1 1295

How can we debug in PL/SQL?

1 1192

Is it possible to read/write files to-and-from PL/SQL?

1 1156

What is an exception in PL/SQL? What are the two types of exceptions?

1 1422

What is scope and visibility in PL/SQL?

1 1299

How to Declare Fixed Length String Value In PL SQL

1 1214

What are the different SQL Server Versions you have worked on?

1071

What are the different types of Indexes available in SQL Server?

1 1074

What is the difference between Clustered and Non-Clustered Index?

1 1114

Un-Answered Questions { Databases }

Can we do dml on views?

1024

Does group by remove duplicates?

1099

What is in place upgrade in sql server?

1113

Why should you use or avoid select * statements?

1094

How to export data from database and import into another?

978

What is the difference between for xml raw and for xml auto?

1095

Can we shrink data file in sql server?

1112

What is a scheduled job or what is a scheduled task?

1019

How to rebuild the master database?

1148

Is primary key clustered index?

1000

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2035

How to select all columns of all rows from a table in oracle?

1107

Can we use distinct and group by together?

1116

Where can you add custom error messages to sql server?

1190

How to enter binary string literals in ms sql server?

1231

For More Un-Answered { Databases } Questions Click Here