The pre-defined exception NO_DATA_FOUND is raised when.... 1. A SELECT INTO statement returns no rows. 2.PL/SQL...

Transcribed Image Text:

The pre-defined exception NO_DATA_FOUND is raised when.... 1. A SELECT INTO statement returns no rows. 2.PL/SQL ran out of memory or memory was corrupted. 3. PL/SQL has an internal problem. 4. A null object is automatically assigned a value. QUESTION 6 Which of the following is not true about the exception handling section of a PL/SQL? 1. This section starts with the EXCEPTION keyword. 2. It is a mandatory section. 3. It contains exception (s) that handle errors in the program. 4. None of the above. QUESTION 7 Which of the following is not true about PL/SQL cursors? 1. None of the above. 2. A cursor is a view on a table. 3. The set of rows the cursor holds is referred to as the active set. 4. A cursor holds the rows (one or more) returned by a SQL statement. QUESTION 8 lpad(rpad('ITIS411', 8, ¹*'), 9, **') would return ITIS411* True False QUESTION 13 When you execute a SELECT statement in a PL/SQL program that returns exactly one row, you must use an explicit cursor. True False QUESTION 14 Which of the following is true about the following PL/SQL CASE statement syntax? CASE selector WHEN 'valuel' THEN S1; WHEN 'value2' THEN S2; WHEN 'value3' THEN S3; ELSE Sn; END CASE; Page 3 default case 1. None of the above is true 2. All the expressions like the selector, the value and the returns values, need not be of the same data type. 3. It is perfectly written. 4. It is wrongly written. QUESTION 16 Which of the following is not true about the declaration section of a PL/SQL block? 01. Non Page 1 above. 2. This section starts with the DECLARE keyword. 3. It defines all variables, cursors, subprograms, and other elements to be used in the program. 4. It is a mandatory section. QUESTION 20 Which of the following is true about the execution section of a PL/SQL block? 1. It is enclosed between the keywords BEGIN and END. 2. It is a mandatory section. 3. It consists of the executable PL/SQL statements. O4. All of the above. The pre-defined exception NO_DATA_FOUND is raised when.... 1. A SELECT INTO statement returns no rows. 2.PL/SQL ran out of memory or memory was corrupted. 3. PL/SQL has an internal problem. 4. A null object is automatically assigned a value. QUESTION 6 Which of the following is not true about the exception handling section of a PL/SQL? 1. This section starts with the EXCEPTION keyword. 2. It is a mandatory section. 3. It contains exception (s) that handle errors in the program. 4. None of the above. QUESTION 7 Which of the following is not true about PL/SQL cursors? 1. None of the above. 2. A cursor is a view on a table. 3. The set of rows the cursor holds is referred to as the active set. 4. A cursor holds the rows (one or more) returned by a SQL statement. QUESTION 8 lpad(rpad('ITIS411', 8, ¹*'), 9, **') would return ITIS411* True False QUESTION 13 When you execute a SELECT statement in a PL/SQL program that returns exactly one row, you must use an explicit cursor. True False QUESTION 14 Which of the following is true about the following PL/SQL CASE statement syntax? CASE selector WHEN 'valuel' THEN S1; WHEN 'value2' THEN S2; WHEN 'value3' THEN S3; ELSE Sn; END CASE; Page 3 default case 1. None of the above is true 2. All the expressions like the selector, the value and the returns values, need not be of the same data type. 3. It is perfectly written. 4. It is wrongly written. QUESTION 16 Which of the following is not true about the declaration section of a PL/SQL block? 01. Non Page 1 above. 2. This section starts with the DECLARE keyword. 3. It defines all variables, cursors, subprograms, and other elements to be used in the program. 4. It is a mandatory section. QUESTION 20 Which of the following is true about the execution section of a PL/SQL block? 1. It is enclosed between the keywords BEGIN and END. 2. It is a mandatory section. 3. It consists of the executable PL/SQL statements. O4. All of the above.

Answer rating: 100% (QA)

The detailed answer for the above question is provided below 1 A SELECT INTO statement returns no rows The predefined exception NODATAFOUND is specifi... View the full answer