Blog

The RAISE statement is used to trigger an exception manually.

PL/SQL supports both procedural and SQL statements in the same block.

Which of the following examples declares an INDEX BY table of record?

Which constraint(s) can be defined at the table level?

Package Specification dept_pack was created by the following code: CREATE OR REPLACE PACKAGE dept_pack IS        PROCEDURE ins_dept(p_deptno IN NUMBER);       FUNCTION get_dept(p_deptno IN NUMBER) RETURN VARCHAR2;END dept_pack; Which of the following is incorrect syntax for invoking the package subprograms?

You can only have one exception handler in a PL/SQL block.

What is the parameter mode for p_name in the query_demo procedure in the following PL/SQL block? DECLARE  p_name  persons.name%TYPE;    p_sal   persons.salary%TYPE;BEGIN  query_demo(178, p_name, p_sal);  DBMS_OUTPUT.PUT_LINE(‘Name: ‘ || p_name);  DBMS_OUTPUT.PUT_LINE(‘Salary: ‘ || p_sal);END;

In PL/SQL, which type of SQL statement requires the use of a cursor or loop to fetch multiple rows?

Define Data visualization, Responsive web design, Web 2.0 technologies, Ajax, and XML

Which user interface elements are commonly used to change data with a continuous range of values? (select only one)