ADVERTISEMENT
ADVERTISEMENT

Oracle Functions MCQs

Oracle Functions MCQs: This section contains multiple-choice questions and answers on functions in Oracle.
Submitted by Anushree Goswami, on June 13, 2022

1. Functions return a single value from a ____.

  1. Program
  2. Subprogram
  3. Superprogram
  4. None

Answer: B) Subprogram

Explanation:

Functions return a single value from a subprogram.


2. Before invoking a function, it must be ____.

  1. Declared
  2. Defined
  3. Both A and B
  4. None of the above

Answer: C) Both A and B

Explanation:

Before invoking a function, it must be declared and defined.


3. Defining and declaring can be done in the ____.

  1. Same block
  2. Separately
  3. Both A and B
  4. None of the above

Answer: C) Both A and B

Explanation:

Defining and declaring can be done in the same block or they can be done separately.


4. Which of the following is present in the Create function?

  1. RETURN
  2. IS
  3. END
  4. All of the above

Answer: D) All of the above

Explanation:

RETURN, IS and END are all present in the Create function.


5. Which of the following is not present in the Create function?

  1. CREATE
  2. AS
  3. BEGIN
  4. None of the above

Answer: D) None of the above

Explanation:

CREATE, AS, BEGIN are all present in the Create function.


6. Which of the following parameters are present in Oracle function?

  1. IN
  2. OUT
  3. IN OUT
  4. All of the above

Answer: D) All of the above

Explanation:

All IN, OUT, IN OUT parameters are present in Oracle function.


7. ____ can call another subprograms.

  1. Programs
  2. Subprograms
  3. Both A and B
  4. None of the above

Answer: C) Both A and B

Explanation:

Programs and subprograms can call other programs and subprograms.


8. The drop function syntax is the best way to ____ your created functions from the database.

  1. Add
  2. Remove
  3. Fetch
  4. Store

Answer: B) Remove

Explanation:

The drop function syntax is the best way to remove your created functions from the database.


9. What is the syntax to drop a function?

  1. DROP PROCEDURE function_name;
  2. DELETE PROCEDURE function_name;
  3. DROP FUNCTION function_name;
  4. DELETE FUNCTION function_name;

Answer: C) DROP FUNCTION function_name;

Explanation:

The syntax to drop a function is DROP FUNCTION function_name;.


10. Subprograms can call themselves recursively, which is known as ____.

  1. Retrieval
  2. Recall
  3. Recursion
  4. Repetition

Answer: C) Recursion

Explanation:

Subprograms can call themselves recursively, which is known as recursion.



ADVERTISEMENT
ADVERTISEMENT


Comments and Discussions!



ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT

Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

© https://www.includehelp.com some rights reserved.