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

9 11286

What is difference between a PROCEDURE & FUNCTION ?

Satyam,

6 12130

What are advantages of Stored Procedures?

Satyam,

3 16778

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

3 10244

What are the two parts of a procedure ?

Hi Caliber IT,

6 16299

Give the structure of the procedure ?

1 5614

Give the structure of the function ?

2 6471

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

3 10092

What is Overloading of procedures ?

2 7557

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

Symphony,

2 9319

What are two parts of package ?

Infosys,

2 17429

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

JDA,

2 16420

How packaged procedures and functions are called from the following?

2 6295

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

3 11577

what is a display item?

1 3772

Un-Answered Questions { Databases }

Describe sql comments?

1052

Is oracle an open source?

1090

What is the need of merge statement?

1049

What is variable and how many types of variable?

596

Write the alter statement to enable all the triggers on the t.students table.

1134

Explain neo4j index?

How do I take advantage of table partitioning with bcp in sybase?

829

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

938

How can we use ConnectorJ JDBC Driver with MS SQL?

1010

How to delete a database from mysql server.

1075

What does the update command do?

1123

What command is used to create a database in the sql server and how?

1193

Mention what is the use of function "module procedure" in pl/sql?

1058

I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage

1554

What is vacuuming in postgresql?

763

For More Un-Answered { Databases } Questions Click Here