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 10099

What is a cursor for loop ?

4 9845

What will happen after commit statement ?

2 8348

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 11406

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

2 13868

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

5 17320

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 5499

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

2 8684

What is an Exception ? What are types of Exception ?

2 7510

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 10154

What is Raise_application_error ?

1 7725

What are the return values of functions SQLCODE and SQLERRM ?

PreVator,

2 11094

Where the Pre_defined_exceptions are stored ?

2 8794

Un-Answered Questions { Databases }

What will be the maximum number of index per table?

1058

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

1005

How to retrieve error messages using mssql_get_last_message()?

1108

What is faster join or union?

1322

What is varray in pl sql?

1124

What is “asynchronous” communication in sql server service broker?

1082

Explain datetime2 data type in sal server 2008?

954

How to calculate expressions with sql statements?

1169

Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?

2563

What is the purpose of the model database?

1071

How to activate all indexes in firebird?

1128

List down some advantages of sql stored procedure?

1019

What is temporal data type?

967

What is the difference between star flake and snow flake schema?

980

What is sql exception?

1014

For More Un-Answered { Databases } Questions Click Here