Question
Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
More SQL Questions
- Which of the following can be used to avoid duplicate entries in a column?
- In SQL, the ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW clause applies to:
- Which join returns rows from the left table even when there is no matching row in the right table, filling with NULLs for the right side?
- In normalization, which normal form removes transitive dependencies?
- What is the result of SELECT COUNT(NULL) on any table?
- SQL Injection can be prevented by all EXCEPT:
- Which SQL clause is used to filter results after a GROUP BY operation?
- What is the main function of a PL/SQL `TRIGGER`?
- Which of the following is a common use case for a PL/SQL trigger?
- Which index type is most beneficial for queries that use range predicates (e.g., WHERE age BETWEEN 20 AND 30)?
Hey! Ask a query
Please enter email id
The email must be a valid email address.
Please enter Mobile Number
Please enter valid Mobile Number
Please enter your Doubt
