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 6615

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

4 10524

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

2 6600

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

2 7581

what is ref cursor in pl/sql?

3 22339

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

3 10373

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

PreVator,

4 9330

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

Fujitsu,

2 13254

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

PreVator,

7 19488

How the execution will be done in exceptions?

2 7150

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

3 12596

what is the forward decleration in packages?

1 5926

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

3 7159

what is meant by tuning and tk proof?

2 13394

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

3 11014

Un-Answered Questions { Databases }

Can excel and access work together?

829

How do you add a column?

855

How to calculate expressions with sql statements?

1119

How do I clear the command in mysql?

947

What are the differences between char and varchar2 in oracle?

1176

What is “namespace” in mongodb?

What is the purpose of update statistics and scope_identity() function?

1100

How does limit work in mysql?

910

Does index slows down insert statements?

1003

What are hotfixes and patches?

949

What is database in php mysql?

999

what is top in tsql? : Transact sql

1123

What is difference sql and mysql?

992

What is the sql case statement used for? Explain with an example?

996

What are the three tiers in a 3 tier architecture?

774

For More Un-Answered { Databases } Questions Click Here