summative
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
---|---|---|---|---|---|
show | DECLARE
🗑
|
||||
show | True
🗑
|
||||
show | False
🗑
|
||||
show | False
🗑
|
||||
A procedure can be invoked in another procedure. | show 🗑
|
||||
The positional parameter passing uses the associate operator. | show 🗑
|
||||
If Combination notation is used, the positional parameters must come first before the named parameters. | show 🗑
|
||||
The Positional parameter passing is the common method of passing parameters. | show 🗑
|
||||
How many parameters are there in the given code? CREATE or replace procedure raise_sal (empid my_employees.employee_id%TYPE := 1234, emp_raise number) ISBEGINupdate employees set salary = salary + (salary * (emp_raise/100) where employee_id = emp; END; | show 🗑
|
||||
Three ways of passing parameters from the calling environment: | show 🗑
|
||||
show | Named
🗑
|
||||
show | IN OUT
🗑
|
||||
show | OUT
🗑
|
||||
show | EXPRESSION
🗑
|
||||
show | OUT
🗑
|
||||
show |
RETURN
🗑
|
||||
The _____ are named PL/SQL blocks that are compiled and stored in the database. | show 🗑
|
||||
Subprograms are named PL/SQL blocks that are compiled and stored in the _______. | show 🗑
|
||||
You cannot invoke a procedure from inside an SQL statement. | show 🗑
|
||||
Subprograms are explicitly shared. | show 🗑
|
||||
The OUT parameter mode supplies an input value, which can be returned (output) as a modified value. | show 🗑
|
||||
show | True
🗑
|
||||
The DEFAULT keyword is used to assign a default value for formal parameters. | show 🗑
|
||||
Which parameter mode can be assigned a default value? IN OUT IN OUT | show 🗑
|
||||
show | 2
🗑
|
||||
show | Positional parameter must come before named parameter
🗑
|
||||
show | False
🗑
|
||||
show | False
🗑
|
||||
A procedure can be invoked in another procedure. | show 🗑
|
||||
show | False
🗑
|
||||
If Combination notation is used, the positional parameters must come first before the named parameters. | show 🗑
|
||||
show | True
🗑
|
||||
show | 2
🗑
|
||||
show | POSITIONAL, NAMED, COMBINATION
🗑
|
||||
Which type of parameter passing uses an association operator? | show 🗑
|
||||
The functions used in SQL statements cannot use OUT or _____ modes. | show 🗑
|
||||
show | OUT
🗑
|
||||
show | EXPRESSION
🗑
|
||||
show | OUT
🗑
|
||||
show |
RETURN
🗑
|
||||
show | SUBPROGRAMS
🗑
|
||||
show | DATABASE
🗑
|
||||
show | True
🗑
|
||||
Subprograms are explicitly shared. | show 🗑
|
||||
The OUT parameter mode supplies an input value, which can be returned (output) as a modified value. | show 🗑
|
||||
False | show 🗑
|
||||
show | False
🗑
|
||||
Which parameter mode can be assigned a default value? IN OUT IN OUT | 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 🗑
|
||||
What is the error of the given code? BEGIN add_dept(name =>'new dept', 'new location'); END; | show 🗑
|
||||
show | RETURN
🗑
|
||||
show | HEADER
🗑
|
||||
show | DATA TYPE
🗑
|
||||
What is missing in the code below? create or replace function sample return number is num number(2); begin num := 5+5; end; | show 🗑
|
||||
The purpose of the OR REPLACE clause is to ______ an existing procedure. | show 🗑
|
||||
In Procedure, all parameter modes must be specified. | show 🗑
|
||||
show | True
🗑
|
||||
show | False
🗑
|
||||
To invoke a procedure from another procedure, use a direct call inside an executable section of the block. | show 🗑
|
||||
show | False
🗑
|
||||
Another way of initializing a default value for parameter is by using assignment operator. | show 🗑
|
||||
show | =>
🗑
|
||||
show | Not in the options
🗑
|
||||
The functions used in SQL statements cannot use _____ or IN OUT modes. | show 🗑
|
||||
show | DATA TYPE
🗑
|
||||
show | x:=100; DBMS_OUTPUT.PUT_LINE(get_sal(x));
🗑
|
||||
In PL/SQL ___________, the function identifier acts like a variable whose value depends on the parameters passed to it. | show 🗑
|
||||
show | VARIABLE
🗑
|
||||
A _______ triggers execute whenever a particular event occurs within an application. | show 🗑
|
||||
A row trigger fires once for each row affected by the triggering DML statement, either just BEFORE the row is processed or just AFTER. | show 🗑
|
||||
show | True
🗑
|
||||
A row trigger may SELECT from a mutating table. | show 🗑
|
||||
The ON SCHEMA cannot be used with SHUTDOWN and STARTUP events. | show 🗑
|
||||
show | OWN
🗑
|
||||
The ______ triggers can either be ON DATABASE or ON SCHEMA. | show 🗑
|
||||
show | AUTOMATICALLY
🗑
|
||||
Event determines which DML operation causes the trigger to fire. Values are DELETE, UPDATE [OF column], and ______. | show 🗑
|
||||
show | DELETING
🗑
|
||||
show | True
🗑
|
||||
A ON SCHEMA fires the trigger for DDL on all schemas in the database. | show 🗑
|
||||
The CALL is a statement is used to invoke procedure in a trigger. | show 🗑
|
||||
show | ON SCHEMA
🗑
|
||||
Trigger executes ________ whenever the associated action occurs. | show 🗑
|
||||
show | BEFORE
🗑
|
||||
You specify a row trigger using __________clause. | show 🗑
|
||||
The ________trigger is the default type of DML trigger. | show 🗑
|
||||
The Conditional Predicates keywords are automatically declared Boolean variables which are set to TRUE or FALSE by the Oracle server. These keywords maybe used in the trigger body instead of UPDATE, INSERT, DELETE. | show 🗑
|
||||
A statement-level trigger fires once for each row affected by the triggering DML statement, either just BEFORE the row is processed or just AFTER. | show 🗑
|
||||
show | False
🗑
|
||||
The database triggers are fired by non-SQL events in the database. | show 🗑
|
||||
The ON DATABASE fires the trigger only for your own sessions. | show 🗑
|
||||
The ON SCHEMA fires the trigger only for your own sessions. | show 🗑
|
||||
A row-level trigger must not query or modify a mutating table. | show 🗑
|
||||
show | ROW-LEVEL
🗑
|
||||
An ON DATABASE fires the trigger for ____ on all schemas in the database. | show 🗑
|
||||
The __________ cannot be used with SHUTDOWN and STARTUP events. | show 🗑
|
||||
A ________ table is an object that is currently being modified by a DML statement. | show 🗑
|
||||
show | ON SCHEMA
🗑
|
||||
show | QUALIFY
🗑
|
||||
show | PACKAGE SPECIFICATION
🗑
|
||||
show | False
🗑
|
||||
Variables declared in the package specification are initialized to NULL by default. | show 🗑
|
||||
show | True
🗑
|
||||
Since triggers are never explicitly invoked, they cannot receive parameters. | show 🗑
|
||||
show | DML, DDL
🗑
|
||||
show | USER_TRIGGERS
🗑
|
||||
A DML trigger is a trigger that is automatically fired (executed) whenever an SQL DML statement (INSERT, UPDATE, or DELETE) is executed. | show 🗑
|
||||
DML Trigger is classified in two ways: when they execute, how they execute. | show 🗑
|
||||
The given trigger header contains no error. CREATE OR REPLACE TRIGGER emp_del_trigg AFTER DELETE ON employees BEGIN <assume valid PL/SQL statements here> END; | show 🗑
|
||||
show | True
🗑
|
||||
The ON SCHEMA fires the trigger only for your own sessions. | show 🗑
|
||||
A ON DATABASE fires the trigger for DDL on all schemas in the database. | show 🗑
|
||||
show | The trigger fires whenever any type of object is created in your schema.
🗑
|
||||
show | Database event trigger
🗑
|
||||
show | False(DATABASE TRIGGER)
🗑
|
||||
Parameters in subprograms are optional. | show 🗑
|
||||
show | False
🗑
|
||||
show | 1
🗑
|
||||
In Procedure, the default parameter mode is IN. | show 🗑
|
||||
show | True
🗑
|
||||
The formal parameters can be literal values, variables, or expressions that are sent to the parameter list of a called subprogram. | show 🗑
|
||||
show | POSITIONAL
🗑
|
||||
show | Nothing is missing
🗑
|
||||
show | ANONYMOUS
🗑
|
||||
show | True
🗑
|
||||
The type of parameter that is declared in procedure heading is called ________. | show 🗑
|
||||
show | Nothing is missing
🗑
|
||||
show | FORMAL PARAMETER
🗑
|
||||
A function must have a _______ clause in the header and at least one RETURN statement in the executable section. | show 🗑
|
||||
show | Not in the options
🗑
|
||||
show | False
🗑
|
||||
The ____ parameters can be literal values, variables, or expressions that are sent to the parameter list of a called subprogram. | show 🗑
|
||||
show | FUNCTION
🗑
|
||||
What is missing in the code below? create or replace function sample is num number(2); begin num := 5+5; return num; end; | show 🗑
|
||||
Which of the statement below is valid? Assuming that get_sal procedure exists with one IN parameter. | 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:
Sangunius