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 6372

How to return multiple records from procedure?

2 9089

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

2 6687

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

4 10658

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

2 6677

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

2 7687

what is ref cursor in pl/sql?

3 22465

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

3 10488

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

PreVator,

4 9453

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

Fujitsu,

2 13358

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

PreVator,

7 19668

How the execution will be done in exceptions?

2 7250

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

3 12729

what is the forward decleration in packages?

1 5981

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

3 7269

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is type and rowtype in pl sql?

1054

What are sql queries used for?

1064

how would you get the current date in mysql? : Sql dba

1015

What is the best free sql database?

1098

How do you define a foreign key?

1059

explain mysql aggregate functions. : Sql dba

1024

what is union, minus and interact commands? : Sql dba

1249

Is a secondary key the same as a foreign key?

1110

What is pl sql in dbms?

987

what is the difference between truncate and drop statements? : Sql dba

1176

How can we solve sql error: ora-00904: invalid identifier?

1292

Explain isolation levels. : Transact sql

1102

What is the basic form of sql query?

989

What are the advantages of sql?

1098

What is the purpose of a secondary key?

1014

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