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 6307

How to return multiple records from procedure?

2 8990

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

2 6609

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

4 10515

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

2 6594

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

2 7569

what is ref cursor in pl/sql?

3 22327

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

3 10367

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

PreVator,

4 9319

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

Fujitsu,

2 13245

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

PreVator,

7 19472

How the execution will be done in exceptions?

2 7142

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

3 12583

what is the forward decleration in packages?

1 5925

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

3 7148

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

how to check myisam tables for errors? : Sql dba

1321

Why partition by is used in sql?

1038

What is primary key sql?

1036

Why is a primary key important?

1042

what is clause? : Sql dba

1060

what are aggregate and scalar functions? : Sql dba

1057

what is online transaction processing (oltp)? : Sql dba

994

How is debugging done?

977

Explain the insert into statements in sql?

1005

What is a common use of group by in sql?

1051

what is sp_pkeys? : Transact sql

1158

What are secondary keys?

971

What is bulk collect in pl sql?

1088

Why use triggers in sql?

956

How many primary keys can a table have?

1009

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