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
SA1 DATABASE
| 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 |
| hat 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? | () |
| Use the ISOPEN cursor attribute before performing a fetch to test whether the cursor is open. | TRUE |
| In explicit cursor, you need to fetch each row one at a time. | TRUE |
| Error in PL/SQL is known as ____________. | EXCEPTION |
| The _______ is an optional exception-handling clause that traps any exceptions that have not been explicitly handled. | OTHERS |
| The ___________ contains the exceptions handlers. | EXCEPTION SECTION |
| A block always terminates when PL/SQL raises an exception. Group of answer choices True False | FALSE |
| The EXECUTE keyword is used in user-defined exception for error notification. Group of answer choices True False | FALSE |
| The RAISE keyword is used by non-predefined exception. | TRUE |
| The PRAGMA clause is used in predefined exception to tell the compiler to associate an exception name with a specific Oracle error number. | FALSE |
| he ______ returns character data containing the message associated with the error number. | SQLERRM |
| What are/is the type of exception can be raised using the RAISE statement? Group of answer choices Non-predefined, User-defined User-defined Pre-defined, Non-predefined NON-PREDEFINED Pre-defined, User-defined | Pre-defined, User-defined |
| In non-predefined exception, you must reference the ________ within a WHEN clause in the exception-handling section. Group of answer choices All the options are possible Oracle associated error# Declared exception name Exception name | DECLARED EXCEPTION NAME |
| The given syntax in declaring a user-define record is incorrect. TYPE type_name IS RECORD (field_declaration[,field_declaration]...); identifier type_name ; | FALSE |
| PL/SQL record is a composite data type, you can refer to the whole record by its name and/or to individual fields by their names. Group of answer choices True False | TRUE |
| The %ROWTYPE cannot be used to declare a record based on another record. Group of answer choices True False | TRUE |
| What is the error in line 5? | Counter variable |
| What is Missing in Line #8: | COUNTRY_REC |
| How many parameter is needed to be passed from the calling environment? _____ | 1 |
| When we declare a cursor FOR UPDATE, each row is locked as we open the cursor and prevent other users from reading the rows. Group of answer choices True False | false |
| The missing element in in line 6 is Region_id. | false |
| What symbol is used to terminate the TYPE statement? | ; |
| In explicit cursor operations, the set of rows returned by a multiple-row query is called RECORD SET. Group of answer choices True False | FALSE |
| The OPEN will populate the cursor’s active set with the result of the SELECT statement in the cursor’s definition? | TRUE |
| Handle named exceptions whenever possible, instead of using ______ in exception handlers. | OTHERS |
| Code that defines the recovery actions to be performed when execution-time errors occur. | EXCEPTION HANDLER |
| Exception handlers are code that defines the recovery actions to be performed when execution-time errors occur. Group of answer choices True False | TRUE |
| Exception section is mandatory in PL/SQL block. | FALSE |
| You can use the RAISE_APPLICATION_ERROR procedure to return user-defined error messages from stored subprograms. | TRUE |
| The RAISE statement can be used to raise either user-defined or predefined exception. Group of answer choices True False | TRUE |
| The RAISE statement can be used to raise either user-defined or non-predefined exception. | TRUE |
| The NO_DATA_FOUND is an example of: Group of answer choices Non-predefined exception Predefined exception | Predefined exception |
| In trapping a user-defined exception, these steps must be followed: DECLARE -> RAISE -> __________. | EXCEPTION HANDLING |
| The declared non-predefined exception is raised ____________. | EXPLICITLY |
| A user-defined PL/SQL record contains one or more fields of scalar data type. | FALSE |
| In explicit cursor operations, the set of rows returned by a multiple-row query is called ________. Group of answer choices Record set Active Cursor Active set Cursor | Active set |
| What is missing in line 8? | Cur_emps |
| What is missing in line#9? ______ | COUNTRY_CURS |
| If you omit the ______ keyword, then the Oracle server waits indefinitely until the rows are available. | NOWAIT |
| The missing element in in line 6 is 5. | TRUE |
Created by:
user-1918311