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

How to come back in normal stage in Mutating Table if mutating table is locked or update data?

2 6639

Can we relate two different tables from two different users in ORACLE,PL/SQL?

4 10549

How to get the procedure's, function's name from a package if it is wrapped(both spec & body).

2 6616

If records are inserted into table without committing.How to refer to these values in a procedure?

2 7608

what is ref cursor in pl/sql?

3 22368

How to fetch the rows by dynamicaly passing table name through cursor?

3 10403

what is difference between "Primary key" and "Unique key"?

PreVator,

4 9368

can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures?

Fujitsu,

2 13285

Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ?

PreVator,

7 19531

How the execution will be done in exceptions?

2 7170

What is the difference between sql/pl-sql/embeded sql?

3 12631

what is the forward decleration in packages?

1 5947

In packages the source code is compiled into p code ? how do we describe the p code

3 7184

what is meant by tuning and tk proof?

2 13416

How would you hide a table in sql. ie the table can be only visible to its maker?

3 11039

Un-Answered Questions { Databases }

Why is the use of dbms recommended? Explain by listing some of its major advantages.

1706

How do I start postgresql in linux?

913

How is data stored in dbms?

974

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1933

What is a super key? How is it different from a candidate key?

824

What are the various constraints used in oracle?

1065

What is the difference between clustered index and primary key?

934

What is resultset concur_updatable?

1037

What is toast in postgres?

949

What is the current mysql version?

1031

How do I run mysql on a mac?

977

What can you do with mysql?

1025

Could you please provide oca (oracle 10g) dumps for my certification ?

5187

How to download oracle database 10g xe?

1031

Explain what are page splits? : SQL Server Architecture

1079

For More Un-Answered { Databases } Questions Click Here