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 8985

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 10514

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

2 6591

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

2 7566

what is ref cursor in pl/sql?

3 22326

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

3 10365

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

PreVator,

4 9315

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 19470

How the execution will be done in exceptions?

2 7140

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

3 12578

what is the forward decleration in packages?

1 5923

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

3 7147

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is the main reason behind using an index?

1017

What is the sql*loader? : aql loader

1051

What is the need of a partition key?

986

Can %notfound return null after a fetch?

1060

how to get a list of indexes of an existing table? : Sql dba

957

What are all ddl commands?

1083

How do I view a procedure in sql?

969

Is nosql faster than sql?

1023

Why do we create stored procedures & functions in pl/sql and how are they different?

945

Is sql a microsoft product?

951

does sql support programming? : Sql dba

1041

What is pl sql in oracle?

1041

How can I speed up sql query?

962

What are schema-level triggers?

1101

How to run sql functions in pl/sql?

1052

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