SQL PLSQL Interview Questions
Questions Answers Views Company eMail

Does pl/sql support create command?

657

How to disable a trigger name update_salary?

785

What is the purpose of using pl/sql?

740

How do you declare a user-defined exception?

629

How exception is different from error?

648

What is the difference between syntax error and runtime error?

691

What are pl/sql exceptions? Tell me any three.

1 773

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

645

What are the two virtual tables available at the time of database trigger execution?

753

What are the two different parts of the pl/sql packages?

674

What are the advantages of stored procedure?

637

Which command is used to delete a trigger?

875

What is cursor and why it is required?

679

Explain the savepoint statement.

688

How many types of cursors are available in pl/sql?

673


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what are the types of join and explain each? : Sql dba

609


What are the usages of sql?

661


what is the command line end user interface - mysql? : Sql dba

594


What is the use of <> sql?

644


What does the acronym acid stand for in database management?

666






What is information schema in sql?

671


What is trigger in pl sql with examples?

615


Does inner join remove duplicates?

619


what is online transaction processing (oltp)? : Sql dba

623


How do I save a sql query?

627


what is sub-query? : Transact sql

699


What jobs use sql?

611


Do stored procedures prevent sql injection?

648


what are the advantages of using stored procedures? : Sql dba

704


Why is sql*loader direct path so fast?

690