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

What are the cursor attributes used in PL/SQL ?

4 9976

What is a cursor for loop ?

4 9675

What will happen after commit statement ?

2 8256

Explain the usage of WHERE CURRENT OF clause in cursors ?

Satyam,

4 14324

What is a database trigger ? Name some usages of database trigger ?

4 11278

How many types of database triggers can be specified on a table ? What are they ?

2 13777

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

5 17162

What are two virtual tables available during database trigger execution ?

2 12339

What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?

1 5438

Write the order of precedence for validation of a column in a table ?

2 8568

What is an Exception ? What are types of Exception ?

2 7383

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 10026

What is Raise_application_error ?

1 7666

What are the return values of functions SQLCODE and SQLERRM ?

PreVator,

2 11007

Where the Pre_defined_exceptions are stored ?

2 8706

Un-Answered Questions { Databases }

How to Set a root password if there is on root password.

1097

What information is needed to connect sql*plus an oracle server?

1038

What are policy management terms?

994

What are the different types of joins in sql?

1820

Explain how to send email from sql database?

1060

Mention what is the function that is used to transfer a pl/sql table log to a database table?

1002

Are null values same as that of zero or a blank space?

1041

What are the parts of a sql statement?

1101

What is “i_am_a_dump” flag in mysql?

1077

Why do we need unique key in a table?

965

Define identity and uniqueidentifier property of column?

1074

how to use 'mysql' to run sql statements? : Sql dba

1061

How many text indexes can a mongodb collection have?

What is dba in sql? : SQL DBA

1050

What is the password of postgres user?

834

For More Un-Answered { Databases } Questions Click Here