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

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

2 6702

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

4 10683

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

2 6692

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

2 7711

what is ref cursor in pl/sql?

3 22490

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

3 10517

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

PreVator,

4 9476

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

Fujitsu,

2 13375

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

PreVator,

7 19706

How the execution will be done in exceptions?

2 7266

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

3 12753

what is the forward decleration in packages?

1 5994

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

3 7281

what is meant by tuning and tk proof?

2 13483

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

3 11150

Un-Answered Questions { Databases }

Explain about nested stored procedure?

1084

What is the recursive stored procedure in sql server?

1081

How do you insert rows and columns?

829

What is mongodb best for?

What is the purpose of a database?

1097

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

152

What is query optimization process?

1083

Explain log shipping?

1078

What is the dynamic sql in oracle?

1137

what is a cursor? : Sql dba

1066

Name few of the dcl commands in sql?

1057

What command do we use to rename a database?

1121

How to speed up webrick?

1128

What are the execution control statements in oracle?

1134

What is ceil and floor in oracle?

1124

For More Un-Answered { Databases } Questions Click Here