Un-Answered Questions { SQL PLSQL }

Write the alter statement to enable all the triggers on the t.students table.

650


Define implicit and explicit cursors.

616


Explain ttitle and btitle.

659


Can instead of triggers be used to fire once for each statement on a view?

528


Can 2 queries be executed simultaneously in a distributed database system?

633


Show the two pl/sql cursor exceptions.

600


Explain raise_application_error.

635


Show how functions and procedures are called in a pl/sql block.

575


What operators deal with null?

593


What are character functions?

618


What are the two types of exceptions.

621


What are instead of triggers?

607


What is the meaning of disabling a trigger?

630


What is the difference between database trigger and stored procedure?

540


difference between anonymous blocks and sub-programs.

608