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 8817

what is cursor procedure

iGate,

1 7424

what is global variable in package

Polaris,

3 11440

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

2 6219

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

2 13110

will function return more than one value how

Accenture,

9 24330

can i write pl/sql code in a package

2 6881

can i give user defined exception in a package

2 7400

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

3 5894

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

7 18401

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

1 4868

difference between cursor and procedure in a package

PCS,

3 29956

difference between oracle 8i and oracle 9i

8 26113

full outer join syntax

5 9138

what is called after appearing where clause

3 6684

Un-Answered Questions { Databases }

what is sql server agent? : Sql dba

1177

Can we do dml on views?

1032

Explain “row_number()” in sql server with an example?

1072

what are the advantages of sql ? : Sql dba

1137

How to export data from database and import into another?

992

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2701

Explain system functions or built-in functions? What are different types of system functions?

1060

What are different types of constraints?

995

What is a concurrency problem in dbms?

1049

What is oracle latest version?

1170

Any work done in oracle workflow builder. Did you customize or build a new workflow?

What are the different subsets of sql?

1646

Can we shrink data file in sql server?

1123

How do I find query history in sql server?

1018

Does group by remove duplicates?

1112

For More Un-Answered { Databases } Questions Click Here