DATABASE

Help!

Question

Answer

The executable section of the procedure body requires a minimum of _____ statement.

ONE

🗑

Another way of initializing a default value for parameter is by using assignment operator.

True

🗑

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.

False

🗑

In stored function, the ______ clause is used instead of OUT mode.

RETURN

🗑

What is missing in the code below? create or replace function sample return is begin return 5+5; end;

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.

False

🗑

What is missing in the procedure header? CREATE PROCEDURE raise_sal(p_id IN NUMBER, p_sal IN NUMBER) IS BEGIN ... END;

Nothing is missing

🗑

Which parameter mode can be assigned a default value? IN OUT IN OUT

🗑

Which can be used to assign a default value to IN parameters? Assignment operator := DEFAULT All the options

All the options

🗑

A function can be called as a part of: Group of answer choices Both options SQL statement PL/SL expression

Both options

🗑

In anonymous block, DECLARE states “this is the start of a block”. In Procedure, ____________ states “this is the start of a subprogram”.

CREATE PROCEDURE

🗑

Subprograms are explicitly shared.

True

🗑

The positional parameter passing uses the associate operator. Group of answer choices

False

🗑

The Positional parameter passing is the common method of passing parameters.

True

🗑

The OUT parameter mode supplies an input value, which can be returned (output) as a modified value.

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

🗑

In Procedure, the default parameter mode is _______.

🗑

Subprograms are implicitly shared.

False

🗑

The DEFAULT keyword is used to assign a default value for formal parameters.

False

🗑

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)

The named parameter

🗑

Using an _______ parameter mode, you can pass a value into a procedure that can be updated within the procedure.

IN OUT

🗑

If Combination notation is used, the _______ parameters must come first.

POSITIONAL

🗑

The functions used in SQL statements cannot use _____ or IN OUT modes.

OUT

🗑

Which of the statement below is valid? Assuming that get_sal procedure exists with one OUT parameter.

x:=100; DBMS_OUTPUT.PUT_LINE(get_sal(x));

🗑

The DECLARE keyword is not used in a subprogram.

True

🗑

False

🗑

The IN parameters can only be read within the procedure and cannot be modified.

True

🗑

A function can be called as a part of:

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

Both options

🗑

A function must have a _______ clause in the header and at least one RETURN statement in the executable section.

RETURN

🗑

Subprograms are named PL/SQL blocks that are compiled and stored in the _______.

DATABASE

🗑

The executable section of the procedure body requires a minimum of _____ statement.

ONE

🗑

Another way of initializing a default value for parameter is by using assignment operator.

True

🗑

False

🗑

In stored function, the ______ clause is used instead of OUT mode.

RETURN

🗑

What is missing in the code below? create or replace function sample return is begin return 5+5; end;

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.

False

🗑

What is missing in the procedure header? CREATE PROCEDURE raise_sal(p_id IN NUMBER, p_sal IN NUMBER) IS BEGIN ... END;

Nothing is missing

🗑

Which parameter mode can be assigned a default value? IN OUT IN OUT

🗑

Which can be used to assign a default value to IN parameters? Assignment operator := DEFAULT All the options

All the options

🗑

A function can be called as a part of: Group of answer choices Both options SQL statement PL/SL expression

Both options

🗑

In anonymous block, DECLARE states “this is the start of a block”. In Procedure, ____________ states “this is the start of a subprogram”.

CREATE PROCEDURE

🗑

Subprograms are explicitly shared.

True

🗑

The positional parameter passing uses the associate operator. Group of answer choices

False

🗑

The Positional parameter passing is the common method of passing parameters.

True

🗑

The OUT parameter mode supplies an input value, which can be returned (output) as a modified value.

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

🗑

In Procedure, the default parameter mode is _______.

🗑

Subprograms are implicitly shared.

False

🗑

The DEFAULT keyword is used to assign a default value for formal parameters.

False

🗑

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)

The named parameter

🗑

Using an _______ parameter mode, you can pass a value into a procedure that can be updated within the procedure.

IN OUT

🗑

If Combination notation is used, the _______ parameters must come first.

POSITIONAL

🗑

The functions used in SQL statements cannot use _____ or IN OUT modes.

OUT

🗑

Which of the statement below is valid? Assuming that get_sal procedure exists with one OUT parameter.

x:=100; DBMS_OUTPUT.PUT_LINE(get_sal(x));

🗑

The DECLARE keyword is not used in a subprogram.

True

🗑

False

🗑

The IN parameters can only be read within the procedure and cannot be modified.

True

🗑

A function can be called as a part of:

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

Both options

🗑

A function must have a _______ clause in the header and at least one RETURN statement in the executable section.

RETURN

🗑

Subprograms are named PL/SQL blocks that are compiled and stored in the _______.

DATABASE

🗑

If Combination notation is used, the _______ parameters must come first.

POSITIONAL

🗑

What is the error of the given code? BEGIN add_dept(name =>'new dept', 'new location'); END;

Positional parameter must come before named parameter

🗑

What is missing in the given code below? CREATE or replace procedure raise_sal (empid my_employees.employee_id%TYPE := 1234emp_raise number)BEGIN update employees set salary = salary + (salary * (emp_raise/100) where employee_id = emp; END;

Not in the options

🗑

What is the symbol used for association operator?

🗑

Given the procedure below, what is the correct way of invoking the procedure? CREATE OR REPLACE PROCEDURE show_emps (p_emp_id IN NUMBER, p_department_id IN number, p_hiredate IN DATE) IS begin . . . . . . End;

All the options

🗑

In PL/SQL ___________, the function identifier acts like a variable whose value depends on the parameters passed to it.

EXPRESSION

🗑

The _______ is added to CREATE PROCEDURE clause to overwrite an existing procedure.

OR REPLACE

🗑

In the given Procedure header, the underlined clause/keyword is mandatory. CREATE OR REPLACE PROCEDURE name [parameters] IS|AS

True

🗑

A procedure is compiled and stored in the database as a schema object.

True

🗑

The Named parameter passing is the common method of passing parameters.

False

🗑

Another way of initializing a default value for parameter is by using assignment operator.

True

🗑

We can assign a default value to parameters.

False

🗑

A procedure can be invoked in another procedure.

True

🗑

Three ways of passing parameters from the calling environment:

POSITIONAL, NAMED, COMBINATION

🗑

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;

🗑

A function must have a _______ clause in the header and at least one RETURN statement in the executable section.

RETURN

🗑

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]

FUNCTION

🗑

What is missing in the code below? create or replace function sample return number is begin return 5+5; end;

Nothing is missing

🗑

What follows the RETURN keyword at the function header?

DATA TYPE

🗑

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: pingpong00