QUIZ: PL/SQL
[HDquiz quiz = 324]
- A Cursor is handler or pointer to context area -TRUE
- A Trigger is handler or pointer to context area -FALSE
- Two kind of cursors used in oracle are Implicit and Explicit -True
- A variable is name associated with values – True
- PL/SQL stands for Procedural Language / Structured Query Language – True
- PL/SQL is not Procedural Language – False
- PL/SQL is superset of SQL – TRUE
- Cursor can take parameter – True
- cursor can no take parameter – False
- Trigger can not take parameter – True
- Error Handling in PL/SQL is called Exception – True
- PL/SQL supports error handling routine -True
- SQL does not have procedural Capabilities – True
- Delete command is used to delete a table in PL/SQL – FALSE
- Oracle does not support PL/SQL-FALSE
- Scalar data type does not have any internal component – True
- BEGIN section in PL/SQL is optional- false
- PL/SQL block consist of upto Six section – false
- An error in PL/SQL is called Exception – True
- a cursor can display information from a single table only- False
- Trigger can not take parameter – True
- A trigger is a handle or pointer to the context area – False
- Two kind of cursor is used are Implicit and Explicit – True
- When you drop Triger , its table drops – FALSE