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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

Explain the rollback statement?

1069

What is exception? What are the types of exceptions?

1112

How to execute a stored procedure?

1148

What is mutating table error?

1234

Explain ddl statements in pl/sql?

1041

How to return multiple rows from the stored procedure?

1012

What is the life of an sql statement?

1072

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1058

What steps server process has to take to execute an update statement?

1014

Can %notfound return null after a fetch?

1098

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1256

Determine if oracle date is on a weekend?

1087

How to create a menu in sqlplus or pl/sql?

1161

How to use boolean type in select statement?

1133

How to check if a column is nullable before setting to nullable?

1173

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What are dml commands?

1069

What is schema in sql?

996

What does sign mean sql?

1173

What problem one might face while writing log information to a data-base table in pl/sql?

1238

Could you please provide oca (oracle 10g) dumps for my certification ?

5237

what is datawarehouse? : Sql dba

1058

what is the difference between a having clause and a where clause? : Sql dba

1154

What is substitution variable in pl sql?

1098

Is grant a ddl statement?

936

What is a trigger in sql?

1229

What is the syntax and use of the coalesce function?

1207

How does postgresql compare to mysql?

1075

What is sql integrity?

1233

what is 'mysqlshow'? : Sql dba

1068

Can a trigger call a stored procedure?

1125

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