Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
DS
| Question | Answer |
|---|---|
| A ________ allows us to declare a variable as a record based on a particular table’s structure. | %ROWTYPE |
| TYPE and ________ are composite structures. | RECORD |
| LINE #8 CONTAINS ERROR | TRUE |
| The closing of cursor is missing. | True |
| Error in PL/SQL is known as ____________. | EXCEPTION |
| The following statements are examples of ________________. Entering an expiration date that has passed Selecting more than one row into a single variable Receiving “no rows returned” from a select statement | EXCEPTION |
| The term ________ in exceptions is the same as handling any error by including corresponding exception handler. | trapping |
| Each ________ is consists of a WHEN clause, which specifies an exception name. | EXCEPTION |
| The __________ keyword is used in user-defined exception for error notification. | RAISE |
| The following statements are examples of exception. Entering an expiration date that has passed Selecting more than one row into a single variable Receiving “no rows returned” from a select statement | TRUE |
| The OTHERS is an optional exception-handling clause that traps any exceptions that have not been explicitly handled. Group of answer choices | TRUE |
| The following statements are examples of exception handler. Entering an expiration date that has passed Selecting more than one row into a single variablE Receiving “no rows returned” from a select statement | FALSE |
| In exception section, the WHEN clause if followed by a condition. | True |
| The EXECUTE keyword is used in user-defined exception for error notification. Group of answer choices | False |
| Non-predefined exceptions has a standard Oracle error number (ORA-#####) and error message, but not a predefined name. Group of answer choices True False | True |
| Names for predefined exceptions must be declared in the declaration section. Group of answer choices True False | False |
| The user-defined exceptions are declared within the declarative section and are raised implicitly. Group of answer choices True False | False |
| The RAISE_APPLICATION_ERROR can be used in executable and exception section. Group of answer choices True False | True |
| There are 2 parameters needed in the pragma declaration of an exception. Group of answer choices True False | True |
| The _______________ is used in non-predefined exception to tell the compiler to associate an exception name with a specific Oracle error | PRAGMA EXCEPTION_INIT |
| The oracle error number, at the PRAGMA EXCEPTION_INIT function, starts with _____. | HYPHEN |
| The NO_DATA_FOUND is a _______ exception. | PREDEFINED |
| You can use the ________________ procedure to return user-defined error messages from stored subprograms. | RAISE_APPLICATION_ERROR |
| Two methods for raising an exception: | Implicit, Explicit |
| Types and records are composite structures that can be declared anywhere that scalar variables can be declared. | True |
| Type and record declared in the outer block are visible only in the outer block. | False |
| The given syntax in declaring a user-define record is correct. | True |
| What is missing in line#11? | NOTFOUND |
| Line 5 is valid or invalid? | INVALID |
| What is missing in line 2 and 3? | IS |
| What is missing in line#3? | COUNTRIES |
| What is the counter variable? | COUNTRY_REC |
| Refer to the code below. The missing element in line 8 COUNTRY_REC. | True |
| You must include the FOR UPDATE clause in the cursor query so that the rows are unlocked on OPEN. | False |
| TYPE and Records are ________ structures. | COMPOSITE |
| What is missing in the declaration section if we want to declare v_emp_record as type record of EMPLOYEES table? __________ | EMPLOYEES%ROWTYPE |
| In explicit cursor operations, the set of rows returned by a multiple-row query is called ACTIVE SET. | True |
| The OPEN statement positions the cursor pointer at the first row. | False |
| The exception section begins with the keyword _______. | EXCEPTION |
| When an exception is raised, control immediately shifts to the _______ and the appropriate handler in the exception section is executed. | EXCEPTION SECTION |
| Always add ________ whenever there is a possibility of an error occurring. | EXCEPTION HANDLERS |
| Each ________ is consists of a WHEN clause, which specifies an exception name. | EXCEPTION HANDLER |
| Each exception handler is consists of a _____ clause, which specifies an exception name. WHEN | WHEN |
| In exception section, the WHEN clause if followed by a condition. | False |
| The term TRAP in exceptions is the same as handling any error by including corresponding exception handler. | TRUE |
| An exception handler for a particular exception must contain only one statement. | False |
| The term RAISE in exceptions is the same as handling any error by including corresponding exception handler. | FALSE |
| An exception occurs when an error is discovered during the execution of a program that disrupts the normal operation of the program. | True |
| Non-predefined errors are raised explicitly. | True |
| Pragma declaration is used in declaring user-defined exceptions. | True |
| The SQLCODE function returns the numeric value for the error code. Group of answer choices | True |
| User-defined exceptions are declared within the declarative section and are raised explicitly. | True |
| Pragma declaration is used in declaring non-predefined exceptions. Group of answer choices True False | True |
| The RAISE statement can be used to raise either ________ or predefined exception. | USER-DEFINED |
| Two methods for raising an exception: | Implicit, Explicit |
| The RAISE_APPLICATION_ERROR can be used in: | Executable and Exception section |
| The oracle error number, at the PRAGMA EXCEPTION_INIT function, starts with _____. | HYPEN |
| The ________ clause is used in user-defined exception to tell the compiler to associate an exception name with a specific Oracle error | PRAGMA EXCEPTION_INIT |
| Given the code below, EMPLOYEES%ROWTYPE is missing in the declaration section to declare v_emp_record as type record of EMPLOYEES table. | True |
| The ( ) symbol is used to enclose the elements of the TYPE structure. | True |
| Types and records are composite structures that can be declared anywhere that scalar variables can be declared. | True |
| What will cause an error in the FOR section? | cur_emps IN v_emp_record |
| The given code below declares an explicit cursor. What will cause an error in the code? | IS |
| Given the code below, assume that the cursor contains 20 rows. How many rows will be fetched from the cursor? | 5 |
| You must include the FOR UPDATE clause in the cursor query so that the rows are _____ on OPEN. | LOCKED |
| What is the counter variable? | COUNTRY_REC |
| You must include the ________ clause in the cursor query so that the rows are locked on OPEN. | FOR UPDATE |
| Refer to the code below. The missing element in in line 4 is COUNTRY_CURS. | TRUE |
| The NOWAIT keyword is mandatory in the FOR UPDATE clause. | FALSE |
| What symbol is used to enclose the elements of the TYPE structure? | () |
Created by:
user-2023457