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 a stored procedure ?

9 11530

What is difference between a PROCEDURE & FUNCTION ?

Satyam,

6 12318

What are advantages of Stored Procedures?

Satyam,

3 16919

What are the modes of parameters that can be passed to a procedure ?

3 10370

What are the two parts of a procedure ?

Hi Caliber IT,

6 16474

Give the structure of the procedure ?

1 5666

Give the structure of the function ?

2 6577

Explain how procedures and functions are called in a PL/SQL block ?

3 10200

What is Overloading of procedures ?

2 7656

What is a package ? What are the advantages of packages ?

Symphony,

2 9392

What are two parts of package ?

Infosys,

2 17517

What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

JDA,

2 16536

How packaged procedures and functions are called from the following?

2 6400

Name the tables where characteristics of Package, procedure and functions are stored ?

3 11658

what is a display item?

1 3844

Un-Answered Questions { Databases }

State the difference between local and global temporary tables?

1175

What is meant by datasource?

988

What is tuple in rdbms?

1200

How to delete multiple rows with one delete statement in ms sql server?

1077

Does db2 use sql?

1011

Is mysql better than sql server?

1112

What is a not null constraint?

1092

Is mysql free software?

1022

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4483

Is edb postgres free?

842

What are the new features are introduced in sql server 2012 reporting services?

160

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1120

What do you mean by merge in oracle and how can we merge two tables?

1098

How do I install the latest mysql on ubuntu?

1042

Is postgres a database?

862

For More Un-Answered { Databases } Questions Click Here