Oracle/PLSQL

Which of the following is true about data types in PL/SQL?

• A - Large Object or LOB data types are pointers to large objects that are stored separately from other data items, such as text, graphic images, video clips, and sound waveforms.

• B - The composite data types have data items that have internal components that can be accessed individually. For example, collections and records.

• C - References are pointers to other data items.

• D - All of the above.

What is wrong in the following code?

DECLARE c_id := 1; c_name customers.name%type; c_addr customers.address%type; BEGIN SELECT name, address INTO c_name, c_addr FROM customers WHERE id = c_id; END;

• A - You cannot use the SELECT INTO statement of SQL to assign values to PL/SQL variables.

• B - The SELECT INTO statement here is wrong. It should be: SELECT c_name, c_address INTO name, addr

• C - The WHERE statement is wrong. It should be: WHERE id := c_id;

• D - The variable c_id should be declared as a type-compatible variable as −

  c_id customers.id%type := 1;

Which of the following is true about the following code snippet?

_{^{DECLARE a number(3) := 100;}}

_^BEGIN

_{^{IF (a = 50 ) THEN dbms_output.put_line('Value of a is 10' );}}

_{^{ELSEIF ( a = 75 ) THEN dbms_output.put_line('Value of a is 20' );}}

_{^{ELSE dbms_output.put_line('None of the values is matching');}}

_{^{END IF;}}

_{^{dbms_output.put_line('Exact value of a is: '|| a );}}

_^END;

• A - It has syntax error.

• B - It will print 'None of the values is matching'.

• C - It will print

  None of the values is matching

  Exact value of a is: 100

• D - None of the above.

Which of the following is true about the parameter modes in PL/SQL Subprograms?

• A - An IN parameter lets you pass a value to the subprogram. It is a read-only parameter.

• B - An OUT parameter returns a value to the calling program.

• C - An IN OUT parameter passes an initial value to a subprogram and returns an updated value to the caller.

• D - All of the above.

Which of the following is the correct syntax for creating an explicit cursor?

• A - CURSOR cursor_name IS select_statement;

• B - CREATE CURSOR cursor_name IS select_statement;

• C - CREATE CURSOR cursor_name AS select_statement;

• D - CURSOR cursor_name AS select_statement;

Which of the following is not true about PL/SQL package specifications?

• A - The specification is the interface to the package.

• B - It declares the types, variables, constants, exceptions, cursors, and subprograms that can be referenced from outside the package.

• C - It contains all information about the content of the package and the code for the subprograms.

• D - None of the above.

Which of the following code is the correct syntax for creating an index-by table named salary that will store integer values along with names and the name field will be the key?

• A - TYPE salary IS TABLE OF NUMBER INDEX BY VARCHAR2(20);

• B - CREATE TABLE salary OF NUMBER INDEX BY VARCHAR2(20);

• C - TYPE salary IS INDEXED TABLE OF NUMBER INDEX BY VARCHAR2(20);

• D - None of the above.

Which of the following is true about member methods?

• A - Member methods are used for manipulating the attributes of the object.

• B - Declaration of a member method is provided while declaring the object type.

• C - The object body defines the code for the member methods.

• D - All of the above.

What will be printed by the following PL/SQL block?

• A - 2

• B - 5

• C - 0

• D - Won’t print anything