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

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

4 8599

what is cursor procedure

iGate,

1 7336

what is global variable in package

Polaris,

3 11306

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

2 6120

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

2 13008

will function return more than one value how

Accenture,

9 24012

can i write pl/sql code in a package

2 6748

can i give user defined exception in a package

2 7300

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

3 5738

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

7 18150

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

1 4772

difference between cursor and procedure in a package

PCS,

3 29760

difference between oracle 8i and oracle 9i

8 25825

full outer join syntax

5 8837

what is called after appearing where clause

3 6487

Un-Answered Questions { Databases }

For synchronizing the logins from lower version to higher version, just take the 11.9.2 syslogins structure, go to 12.5 higher version server?

831

What is meant by query optimization?

871

How can you fix a poorly performing query?

1205

What is latest version of sql?

1060

What is primary key in dbms?

923

What are the types of locks in database?

631

what is column? : Sql dba

1020

Define outer join in sql server joins?

948

How do I find mysql database?

929

What is constant in pl sql?

1035

What is postgis and postgresql?

895

How do you update a table in sql?

1000

Who has the largest database?

990

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2089

What is the difference between commit and rollback?

958

For More Un-Answered { Databases } Questions Click Here