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 6375

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 6688

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

4 10659

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 22468

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

3 10490

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

PreVator,

4 9454

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 19669

How the execution will be done in exceptions?

2 7251

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

3 12731

what is the forward decleration in packages?

1 5982

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 are the operators in sql?

1065

What is the difference between unique and primary key constraints?

1118

What are the qualities of 2nf?

1094

Which is better cte or subquery?

1074

What are the three forms of normalization?

1090

what is query cache in mysql? : Sql dba

1076

Why procedure is used in sql?

1082

what is a record in a database ? : Sql dba

1102

Is sql a backend language?

1143

Explain what is a field in a database and record in a database?

1175

What are different types of tables in sql?

1045

What is the use of double ampersand (&&) in sql queries? Give an example

1187

What is the difference between partition and index?

1046

What is difference between stored procedure and trigger?

1238

Can we write ddl statements in functions?

1180

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