1. Categories >> Software >> Databases
  2. Suggest New Category


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 5710

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

 4 9036

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

2 5706

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

2 6604

what is ref cursor in pl/sql?

 3 20987

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

 3 9170

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

PreVator,

4 7796

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

Fujitsu,

2 12171

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

PreVator,

7 17444

How the execution will be done in exceptions?

 2 6032

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

 3 11353

what is the forward decleration in packages?

 1 5179

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

 3 5851

what is meant by tuning and tk proof?

 2 12368

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

 3 9740

Un-Answered Questions { Databases }

What are distinctive joins find as a part of sql?

560

What is postmaster pid file in postgres?

519

What is use of except clause? How does it differ from not in clause?

560

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1132

What is on delete set null?

572




Oracle

1863

Explain query editor regions

625

Explain what are indexes in mongodb?

1

How to set up sql*plus output format in oracle?

602

What are the examples of database?

483

How to revise and re-run the last sql command?

654

Can we use views in stored procedure?

522

Is foreign key mandatory?

560

What is the variable?

334

What is the difference between couchdb and mongodb?

1

For More Un-Answered { Databases } Questions Click Here