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 6734

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

4 10749

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

2 6718

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

2 7771

what is ref cursor in pl/sql?

3 22537

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

3 10570

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

PreVator,

4 9572

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

Fujitsu,

2 13415

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

PreVator,

7 19788

How the execution will be done in exceptions?

2 7309

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

3 12807

what is the forward decleration in packages?

1 6022

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

3 7348

what is meant by tuning and tk proof?

2 13523

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

3 11200

Un-Answered Questions { Databases }

Where can you add custom error messages to sql server?

1203

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1947

How to use values from other tables in update statements using oracle?

1149

How to write a left outer join with the where clause in oracle?

1149

What are the properties of the transaction?

1069

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

1060

What is a coalesce function?

1275

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1064

What are the steps in creating a database?

1004

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1041

How to start an oracle instance?

1098

Why and when do stored procedure recompile?

1052

How to enter binary string literals in ms sql server?

1235

What is your daily office routine?

2340

Why we use the openxml clause?

1072

For More Un-Answered { Databases } Questions Click Here