Which of the following is true about scalar data types in PL SQL?
Answer : D. Q 11 – Which of the following is true about scalar data types in PL/SQL? … B – Examples of scalar data types are NUMBER, DATE, or BOOLEAN. C – PL/SQL provides subtypes of data types.
Which of the following is true about PL SQL cursors?
Q 24 – Which of the following is true about PL/SQL cursors? A – Explicit cursors are automatically created by Oracle. B – Implicit cursors are programmer defined cursors. C – The most recent implicit cursor is called the SQL cursor, and has the attributes like %FOUND, %ISOPEN, %NOTFOUND, and %ROWCOUNT.
Is default parameter mode in PL SQL subprograms?
You can pass a constant, literal, initialized variable, or expression as an IN parameter. IN parameters can be initialized to default values, which are used if those parameters are omitted from the subprogram call. For more information, see “Using Default Values for Subprogram Parameters”.
Which of the following is true about PL SQL index by tables?
Which of the following is true about PL/SQL index-by tables? It is a set of key-value pairs. Each key is unique and is used to locate the corresponding value. The key can be either an integer or a string.
Which data types are used in PL SQL?
PL/SQL uses the SQL character data types such as CHAR , VARCHAR2 , LONG , RAW , LONG RAW , ROWID , and UROWID .
- CHAR(n) is a fixed-length character type whose length is from 1 to 32,767 bytes.
- VARCHAR2(n) is varying length character data from 1 to 32,767 bytes.
What are the three parameter modes for procedures?
PL/SQL procedure parameters can have one of three possible modes: IN, OUT, or IN OUT. PL/SQL function parameters can only be IN.
Where are exceptions used in PL SQL?
An error occurs during the program execution is called Exception in PL/SQL. PL/SQL facilitates programmers to catch such conditions using exception block in the program and an appropriate action is taken against the error condition. There are two type of exceptions: System-defined Exceptions.
How do you write set Serveroutput?
SET SERVEROUTPUT ON DB20000I The SET SERVEROUTPUT command completed successfully. DROP PROCEDURE PROC1 DB20000I The SQL command completed successfully. CREATE PROCEDURE proc1(P1 VARCHAR(10), P2 VARCHAR(10)) BEGIN CALL DBMS_OUTPUT. PUT( ‘p1 = ‘ || p1 ); CALL DBMS_OUTPUT.
When should a close statement be used in PL SQL?
After all rows have been retrieved from the result set that is associated with a cursor, the cursor must be closed. The result set cannot be referenced after the cursor has been closed.
Which subprograms can use parameters?
The three parameter modes, IN (the default), OUT , and IN OUT , can be used with any subprogram. However, avoid using the OUT and IN OUT modes with functions.
What is trigger in PL SQL with examples?
Triggers are stored programs, which are automatically executed or fired when some events occur. Triggers are, in fact, written to be executed in response to any of the following events − A database manipulation (DML) statement (DELETE, INSERT, or UPDATE) A database definition (DDL) statement (CREATE, ALTER, or DROP).
Which type of trigger uses the old and new qualifiers?
The OLD and NEW qualifiers can be used only with row triggers. They cannot be used with statement triggers.