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 is the purpose of using pl/sql?

1 1211

How do you declare a user-defined exception?

1 1106

How exception is different from error?

1 1093

What is the difference between syntax error and runtime error?

1 1213

What are pl/sql exceptions? Tell me any three.

1 1409

What will you get by the cursor attribute sql%rowcount?

1 1095

What are the two virtual tables available at the time of database trigger execution?

1 1314

What are the two different parts of the pl/sql packages?

1 1158

What are the advantages of stored procedure?

1 1073

Which command is used to delete a trigger?

1 1451

What is cursor and why it is required?

1 1281

Explain the savepoint statement.

1 1165

How many types of cursors are available in pl/sql?

1 1195

What are the most important characteristics of pl/sql?

1 1269

What happens when a trigger is associated to a view?

1 999

Un-Answered Questions { Databases }

How to rebuild the master database?

1160

Do we need to rebuild index after truncate?

1132

What kind of problems occurs if we do not implement proper locking strategy?

1495

How to provide default values to function parameters?

1251

what are all the common sql function? : Sql dba

1130

What is the latest version of postgresql?

951

How to use values from other tables in update statements using oracle?

1153

What is temporary table in sql server? Why we use temp table?

1017

What are the two main functions of queries in databases?

1525

Can we shrink data file in sql server?

1123

what is the command syntax for inserting a document?

What is clustered index

1083

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

1112

What is the current mysql version?

1099

Have you created fact table and dimension tables?

710

For More Un-Answered { Databases } Questions Click Here