PLSQL Chapter 6 Quiz

Welcome to your PLSQL Chapter 6 Quiz

What does %TYPE let you do?

Nothing, it's not a valid command in PL/SQL.

It lets you declare a variable that is based on the data type of a column.

It lets you declare a variable that is based on the data type of all columns in a table.

It lets you define a variable as being entered or typed in by the user.

What's one difference between Index By Table and Nested Table?

An Index By Table lets you specify the data type of the index.

Nothing, they are both the same

A Nested Table only works with nested SQL statements

An Index By Table needs a table with an index on it.

What's wrong with this code (assuming the emp_list exists and the employee table exists)?

FORALL i IN 1 .. emp_list.count LOOP
 UPDATE employee
 SET years = years + 1
 WHERE emp_name = emp_list.emp_name;
END LOOP;

You can't run a FORALL statement on an UPDATE statement.

The FORALL keyword doesn't exist.

FORALL is not a loop so it should not have the LOOP and END LOOP statements.

Nothing, it will run successfully.

Why should you use BULK COLLECT?

To reduce the switching between PL/SQL code and SQL code.

You shouldn't use it at all as it's slow.

To get data from large tables, but not small tables.

It's required to declare collection variables.

Time's up

Post navigation

akhil sai jayavarapu
March 14, 2023 at 2:56 am

this is good and then the we want these kind of questions more .

Reply