Save
Upgrade to remove ads
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


Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account. 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.
focusNode
Didn't know it?
click below
 
Knew it?
click below
Don't Know
Remaining cards (0)
Know
0:00
edit
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

FA3

DATABASE

QuestionAnswer
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. Group of answer choices True False 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. T/F 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. Group of answer choices True False 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 IN
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. Group of answer choices True False True
The positional parameter passing uses the associate operator. Group of answer choices True False False
The Positional parameter passing is the common method of passing parameters. Group of answer choices True False True
The OUT parameter mode supplies an input value, which can be returned (output) as a modified value. Group of answer choices True False 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 0
In Procedure, the default parameter mode is _______. IN
Subprograms are implicitly shared. Group of answer choices True False False
The DEFAULT keyword is used to assign a default value for formal parameters. Group of answer choices True False 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. Group of answer choices IN IN OUT All the options OUT 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. Group of answer choices True False True
The IN parameters can only be read within the procedure and cannot be modified. Group of answer choices True False 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. Group of answer choices DECLARATION EXIT PARAMETER RETURN 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
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. Group of answer choices True False 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 IN
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
The positional parameter passing uses the associate operator. Group of answer choices True False False
The OUT parameter mode supplies an input value, which can be returned (output) as a modified value. Group of answer choices True False 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 0
In Procedure, the default parameter mode is _______. IN
The DEFAULT keyword is used to assign a default value for formal parameters. Group of answer choices True False 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. Group of answer choices POSITIONAL NAMED 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. Group of answer choices True False True
The IN parameters can only be read within the procedure and cannot be modified. Group of answer choices True False 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. Group of answer choices DECLARATION EXIT PARAMETER RETURN 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 Invoking the procedure Actual parameter values Do not enclose parameter values with single quote 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. Group of answer choices SELECT PARAMETER EXPRESSION STATEMENT 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 Group of answer choices True False True
A procedure is compiled and stored in the database as a schema object. Group of answer choices True False True
The Named parameter passing is the common method of passing parameters. Group of answer choices True False False
We can assign a default value to parameters. Group of answer choices True False False (needs IN?)
A procedure can be invoked in another procedure. Group of answer choices True False 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; 2
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
The _____ are named PL/SQL blocks that are compiled and stored in the database. SUBPROGRAMS
In the given Procedure header, the ________clause is optional. CREATE OR REPLACE PROCEDURE name [parameters] IS|AS OR REPLACE
Subprograms become the building blocks of packages and triggers. Group of answer choices True False True
If Combination notation is used, the positional parameters must come first before the named parameters. Group of answer choices True False True
To invoke a procedure from another procedure, use a direct call inside an executable section of the block. Group of answer choices True False True
Which type of parameter passing uses an association operator? Group of answer choices IN OUT Positional Named Combination Named
The type of parameter that is declared in procedure heading is called ________. Group of answer choices FORMAL ACTUAL FORMAL
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
In stored function, the RETURN clause is used instead of ____ mode. OUT
The functions used in SQL statements cannot use ____ or IN OUT modes. Group of answer choices OUT IN IN *
A function can be called as a part of: Group of answer choices Not in the options SQL statement SQL statement, PL/SQL expression PL/SL expression SQL statement, PL/SQL expression
The block structure of the subprograms is similar to the structure of _____ blocks. ANONYMOUS
In the given Procedure header, the underlined clause/keyword is optional. CREATE OR REPLACE PROCEDURE name [parameters] IS|AS Group of answer choices True False 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
What keyword is missing? 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 is num number(2); begin num := 5+5; return num; end; Not in the options
The ____ parameters can be literal values, variables, or expressions that are sent to the parameter list of a called subprogram. Group of answer choices ACTUAL FORMAL Actual
# of parameter? CREATE or replace procedure raise_sal (empid my_employees.employee_id%TYPE := 1234, emp_raise number) IS BEGIN update employees set salary = salary + (salary * (emp_raise/100) where employee_id = emp; END; 2
What is missing in the code below? create or replace function sample is begin return 5+5; end; RETURN
The functions used in SQL statements cannot use OUT or _____ modes. IN OUT
What is missing in the code below? create or replace function sample is num number(2); begin num := 5+5; return num; end; Group of answer choices Formal parameter No return value Size of the returning value Not in the options Not in the options
What is missing in the code below? create or replace function sample return is begin return 5+5; end; Group of answer choices Nothing is missing Expression evaluation Data type of the returned value Formal parameter Data type of the returned value
The block structure of the subprograms is similar to the structure of anonymous blocks. Group of answer choices True False True
The symbol >> is used for association operator? Group of answer choices True False False
The code below is a correct example of passing parameters by combination notation. add_dept (p_loc=>1400, 'EDUCATION' ); Group of answer choices True False False
The parameter modes are specified in: Group of answer choices FORMAL PARAMETER ACTUAL PARAMETER FORMAL PARAMETER
What's missing? CREATE or replace procedure raise_sal (empid my_employees.employee_id%TYPE := 1234, emp_raise number) BEGIN update employees set salary = salary + (salary * (emp_raise/100) where employee_id = emp; END; Not in the options (missing parenthesis)
In stored function, the parameter mode should only be ______ . IN
Which of the statement below is valid? Assuming that get_sal function exists with no parameter. Group of answer choices get_sal + 50; get_sal() + 50; v_salary := get_sal + 50; v_salary := get_sal() + 50; v_salary := get_sal() + 50;
Created by: pingpong00
 

 



Voices

Use these flashcards to help memorize information. Look at the large card and try to recall what is on the other side. Then click the card to flip it. If you knew the answer, click the green Know box. Otherwise, click the red Don't know box.

When you've placed seven or more cards in the Don't know box, click "retry" to try those cards again.

If you've accidentally put the card in the wrong box, just click on the card to take it out of the box.

You can also use your keyboard to move the cards as follows:

If you are logged in to your account, this website will remember which cards you know and don't know so that they are in the same box the next time you log in.

When you need a break, try one of the other activities listed below the flashcards like Matching, Snowman, or Hungry Bug. Although it may feel like you're playing a game, your brain is still making more connections with the information to help you out.

To see how well you know the information, try the Quiz or Test activity.

Pass complete!
"Know" box contains:
Time elapsed:
Retries:
restart all cards