SQL PLSQL Interview Questions
Questions Answers Views Company eMail

What are the most important characteristics of pl/sql?

671

What happens when a trigger is associated to a view?

589

What will you get by the cursor attribute sql%notfound?

688

What is the use of pl/sql table?

652

What is pl/sql table? Why it is used?

654

What is the difference between the implicit and explicit cursors?

634

Write a unique difference between a function and a stored procedure.

617

What is the usage of when clause in trigger?

652

Which command is used to delete a package?

658

What is a trigger in pl/sql?

1 785

What are the different schemas objects that can be created using pl/sql?

624

What is the maximum number of triggers, you can apply on a single table?

634

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

731

What is the main reason behind using an index?

636

Explain the commit statement.

686


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

650


Is join same as left join?

631


What are sql functions? Describe in brief different types of sql functions?

571


How do I create an index in word?

626


What is recursive join in sql?

650






How do I pipe the output of one isql to another?

620


What is scalar data type in pl sql?

669


What are inner and outer joins examples of both?

576


How do you optimize a stored procedure query?

648


What is sql prepared statement?

648


how can we know the count/number of elements of an array? : Sql dba

661


What are triggers and its uses?

685


How do you pronounce sql?

639


Is microsoft sql free?

699


Is sql a backend language?

741