Busy. Please wait.
Log in with Clever
or

show password
Forgot Password?

Don't have an account?  Sign up 
Sign up using Clever
or

Username is available taken
show password

Your email address is only used to allow you to reset your password. See our Privacy Policy and Terms of Service.


Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.

summative

Quiz yourself by thinking what should be in each of the black spaces below before clicking on it to display the answer.
        Help!  

Question
Answer
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.

 
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
Created by: Sangunius