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

in a package one procedure is wrong package shows valid or not

4 8744

what is cursor procedure

iGate,

1 7400

what is global variable in package

Polaris,

3 11386

is it mandatory to select all the column in a view then what columns should be selected

2 6190

difference between pl/sql table and normal pl/sql table

2 13076

will function return more than one value how

Accenture,

9 24231

can i write pl/sql code in a package

2 6819

can i give user defined exception in a package

2 7377

after tell procedure whole code he asked can i write the same way in a function

3 5845

can i use dbms_output.put_line in a function u are telling as return statement

7 18332

a procedure one in two out parameters i am waiting it in a sql query can i get the output

1 4840

difference between cursor and procedure in a package

PCS,

3 29884

difference between oracle 8i and oracle 9i

8 26032

full outer join syntax

5 9005

what is called after appearing where clause

3 6611

Un-Answered Questions { Databases }

What is dense_rank?

990

What is advantages of progress actional?

980

Can you remove an open file under unix?

730

How to fetch the row which has the max value for a column?

1049

What are security principals used in sql server 2005?

1040

Explain locking. List its types.

967

How can you list all the columns in a database?

975

What is a database report?

952

Explain what is a replica set?

How many joins in sql server?

1004

What does new grouping sets enables you to do?

1088

if no size is defined while creating the database, what size will the database have? : Sql server administration

1061

What is Query evaluation engine?

1017

What are the four components of a database system?

906

How do I view a stored procedure in sql server?

1034

For More Un-Answered { Databases } Questions Click Here