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 11527

What is difference between a PROCEDURE & FUNCTION ?

Satyam,

6 12315

What are advantages of Stored Procedures?

Satyam,

3 16917

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

3 10368

What are the two parts of a procedure ?

Hi Caliber IT,

6 16468

Give the structure of the procedure ?

1 5665

Give the structure of the function ?

2 6575

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

3 10197

What is Overloading of procedures ?

2 7654

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

Symphony,

2 9391

What are two parts of package ?

Infosys,

2 17516

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 6396

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

3 11657

what is a display item?

1 3842

Un-Answered Questions { Databases }

how to convert dates to character strings? : Sql dba

1255

What is the importance of a recovery model?

1095

Explain the dml?

1051

How check triggers in sql server?

1056

What is an escape character in sql?

1078

How do sql triggers work?

1096

How can we implement rollback or commit statement in a trigger?

1086

Differences between package and loadplans?

630

How many rows can an access table hold?

949

What is database write application of database?

958

What is informix sql?

1032

What is the recommended interval at which to run statspack snapshots, and why?

2967

Why do we use functions?

961

What are tables in sql?

1121

What is Relationship set?

917

For More Un-Answered { Databases } Questions Click Here