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 cursor attributes used in PL/SQL ?

4 10100

What is a cursor for loop ?

4 9848

What will happen after commit statement ?

2 8349

Explain the usage of WHERE CURRENT OF clause in cursors ?

Satyam,

4 14498

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

4 11407

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

2 13869

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

5 17323

What are two virtual tables available during database trigger execution ?

2 12410

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

1 5500

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

2 8685

What is an Exception ? What are types of Exception ?

2 7513

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 10156

What is Raise_application_error ?

1 7726

What are the return values of functions SQLCODE and SQLERRM ?

PreVator,

2 11096

Where the Pre_defined_exceptions are stored ?

2 8796

Un-Answered Questions { Databases }

How to connect with firebird database in delphi using tsqlconnection?

Explain how you can import data from other sources into access database?

899

How do you know if a relationship is 2nf?

996

How do I configure the burn factor in sybase?

926

How useful is microsoft access?

927

Does view occupy space?

992

Write a SQL query in order to merge two different columns into single column?

1089

Please explain couchdb vs mongodb?

What command is used to type files to the screen?

635

What are the differences between stored procedure and view in sql server?

1323

What is the Structural difference between bitmap and b-tree index ?

1089

Can sql function call stored procedure?

1074

Write a query to fetch duplicate records from a table using mysql?

991

How much does mysql cost?

982

What is backup in Oracle?

1084

For More Un-Answered { Databases } Questions Click Here