DATABASE
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| The executable section of the procedure body requires a minimum of _____ statement. | show 🗑
|
||||
| Another way of initializing a default value for parameter is by using assignment operator. | show 🗑
|
||||
| show | False
🗑
|
||||
| show | RETURN
🗑
|
||||
| show | Data type of the returned value
🗑
|
||||
| The formal parameters can be literal values, variables, or expressions that are sent to the parameter list of a called subprogram. | show 🗑
|
||||
| What is missing in the procedure header? CREATE PROCEDURE raise_sal(p_id IN NUMBER, p_sal IN NUMBER) IS BEGIN ... END; | show 🗑
|
||||
| Which parameter mode can be assigned a default value? IN OUT IN OUT | show 🗑
|
||||
| show | All the options
🗑
|
||||
| show | Both options
🗑
|
||||
| In anonymous block, DECLARE states “this is the start of a block”. In Procedure, ____________ states “this is the start of a subprogram”. | show 🗑
|
||||
| show | True
🗑
|
||||
| show | False
🗑
|
||||
| The Positional parameter passing is the common method of passing parameters. | show 🗑
|
||||
| show |
False
🗑
|
||||
| How many private variables are there in the given code? CREATE or replace procedure raise_sal (empid my_employees.employee_id%TYPE := 1234, emp_raise number) IS BEGIN | show 🗑
|
||||
| show | IN
🗑
|
||||
| show | False
🗑
|
||||
| The DEFAULT keyword is used to assign a default value for formal parameters. | show 🗑
|
||||
| show | The named parameter
🗑
|
||||
| Using an _______ parameter mode, you can pass a value into a procedure that can be updated within the procedure. | show 🗑
|
||||
| show | POSITIONAL
🗑
|
||||
| show | OUT
🗑
|
||||
| show | x:=100; DBMS_OUTPUT.PUT_LINE(get_sal(x));
🗑
|
||||
| The DECLARE keyword is not used in a subprogram. | show 🗑
|
||||
| The actual is a special form of a variable, whose input values are initialized by the calling environment when the subprogram is called, and whose output values are returned to the calling environment when the subprogram returns control to the caller. | show 🗑
|
||||
| The IN parameters can only be read within the procedure and cannot be modified. | show 🗑
|
||||
| show | SQL statement, PL/SQL expression
🗑
|
||||
| A function can be called as a part of: Group of answer choices Both options SQL statement PL/SL expression | show 🗑
|
||||
| show | RETURN
🗑
|
||||
| Subprograms are named PL/SQL blocks that are compiled and stored in the _______. | show 🗑
|
||||
| The executable section of the procedure body requires a minimum of _____ statement. | show 🗑
|
||||
| Another way of initializing a default value for parameter is by using assignment operator. | show 🗑
|
||||
| The actual is a special form of a variable, whose input values are initialized by the calling environment when the subprogram is called, and whose output values are returned to the calling environment when the subprogram returns control to the caller. | show 🗑
|
||||
| In stored function, the ______ clause is used instead of OUT mode. | show 🗑
|
||||
| show | Data type of the returned value
🗑
|
||||
| The formal parameters can be literal values, variables, or expressions that are sent to the parameter list of a called subprogram. | show 🗑
|
||||
| What is missing in the procedure header? CREATE PROCEDURE raise_sal(p_id IN NUMBER, p_sal IN NUMBER) IS BEGIN ... END; | show 🗑
|
||||
| Which parameter mode can be assigned a default value? IN OUT IN OUT | show 🗑
|
||||
| show | All the options
🗑
|
||||
| show | Both options
🗑
|
||||
| In anonymous block, DECLARE states “this is the start of a block”. In Procedure, ____________ states “this is the start of a subprogram”. | show 🗑
|
||||
| Subprograms are explicitly shared. | show 🗑
|
||||
| The positional parameter passing uses the associate operator. Group of answer choices | show 🗑
|
||||
| The Positional parameter passing is the common method of passing parameters. | show 🗑
|
||||
| The OUT parameter mode supplies an input value, which can be returned (output) as a modified value. | show 🗑
|
||||
| How many private variables are there in the given code? CREATE or replace procedure raise_sal (empid my_employees.employee_id%TYPE := 1234, emp_raise number) IS BEGIN | show 🗑
|
||||
| In Procedure, the default parameter mode is _______. | show 🗑
|
||||
| Subprograms are implicitly shared. | show 🗑
|
||||
| The DEFAULT keyword is used to assign a default value for formal parameters. | show 🗑
|
||||
| Assuming add_dept procedure has two parameters: p_name and p_id, what is the error in the given procedure call? add_dept ('ADVERTISING', p_loc => 1400) | show 🗑
|
||||
| show | IN OUT
🗑
|
||||
| If Combination notation is used, the _______ parameters must come first. | show 🗑
|
||||
| show | OUT
🗑
|
||||
| Which of the statement below is valid? Assuming that get_sal procedure exists with one OUT parameter. | show 🗑
|
||||
| show |
True
🗑
|
||||
| show | False
🗑
|
||||
| The IN parameters can only be read within the procedure and cannot be modified. | show 🗑
|
||||
| A function can be called as a part of: | show 🗑
|
||||
| A function can be called as a part of: Group of answer choices Both options SQL statement PL/SL expression | show 🗑
|
||||
| show | RETURN
🗑
|
||||
| Subprograms are named PL/SQL blocks that are compiled and stored in the _______. | show 🗑
|
||||
| show | POSITIONAL
🗑
|
||||
| show | Positional parameter must come before named parameter
🗑
|
||||
| show | Not in the options
🗑
|
||||
| show |
=>
🗑
|
||||
| show | All the options
🗑
|
||||
| In PL/SQL ___________, the function identifier acts like a variable whose value depends on the parameters passed to it. | show 🗑
|
||||
| The _______ is added to CREATE PROCEDURE clause to overwrite an existing procedure. | show 🗑
|
||||
| In the given Procedure header, the underlined clause/keyword is mandatory. CREATE OR REPLACE PROCEDURE name [parameters] IS|AS | show 🗑
|
||||
| show |
True
🗑
|
||||
| show | False
🗑
|
||||
| Another way of initializing a default value for parameter is by using assignment operator. | show 🗑
|
||||
| We can assign a default value to parameters. | show 🗑
|
||||
| show | True
🗑
|
||||
| Three ways of passing parameters from the calling environment: | show 🗑
|
||||
| Given the procedure below, how many parameters will return a value to the calling environment? CREATE OR REPLACE PROCEDURE show_emps (p_emp_id NUMBER, p_department_id OUT number, p_hiredate IN OUT DATE) IS begin End; | show 🗑
|
||||
| A function must have a _______ clause in the header and at least one RETURN statement in the executable section. | show 🗑
|
||||
| What keyword is missing in the given function construct? CREATE [OR REPLACE] function_name [(parameter1 [mode1] datatype1, ...)] RETURN datatype IS|AS [local_variable_declarations; …] BEGIN actions; RETURN expression; END [function_name] | show 🗑
|
||||
| show | Nothing is missing
🗑
|
||||
| What follows the RETURN keyword at the function header? | show 🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
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
Created by:
pingpong00