SQL PLSQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

what is the difference between granting and creating a view?

2 6292

How to return multiple records from procedure?

2 8977

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

2 6603

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

4 10494

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

2 6583

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

2 7547

what is ref cursor in pl/sql?

3 22312

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

3 10358

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

PreVator,

4 9298

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

Fujitsu,

2 13236

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

PreVator,

7 19440

How the execution will be done in exceptions?

2 7122

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

3 12560

what is the forward decleration in packages?

1 5919

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

3 7126

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

970

how is myisam table stored? : Sql dba

1050

What is scalar and vector?

994

How bulk collect improves performance?

995

What is java sql package?

1088

How delete all data from table in sql?

1014

what is normalization? : Sql dba

1078

Is sql a dbms?

996

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1087

What is the use of index in sql?

1010

Is sql an operating system?

1016

how tsql statements can be written and submitted to the database engine? : Transact sql

978

Is ms sql is free?

1018

What schema means?

884

How can we debug in PL/SQL?

1130

For More Un-Answered { SQL PLSQL } Questions Click Here