PL/SQL has two types of subprograms, procedures and functions. Which subprogram isused to compute a value?

Related MCQs

• Aggregate functions are functions that take a                        as input and return a single value.
• An                          consists of a search-key value and pointers to one or more records with that value as their search-key value.
• An ____________ consists of a search-key value and pointers to one or more records with that value as their search-key value.
• Stored procedures are safe from SQL injection attacks
• Suppose now that R(A,B:) and S(A,B:) are two relations with r and s tuples, respectively (again, not necessarily distinct). If m is the number of (not necessarily distinct) tuples in the result of the SQL query: R intersect S; Then which of the following is the most restrictive, correct condition on the value of m?
• In a                clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers.
• In a _______ clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers.
• SQL Server has mainly how many types of views?
• Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:
• Each operation in a demand-driven pipeline can be implemented as an          that provides the following functions: open(), next(), and close().