W08 Quiz_2

docx

School

Brigham Young University, Idaho *

*We aren’t endorsed by this school

Course

325

Subject

Information Systems

Date

Nov 24, 2024

Type

docx

Pages

Uploaded by UduakSampson

Score for this attempt: 10 out of 10 Submitted Oct 30 at 4:08pm This attempt took 8 minutes. Question 1 2 / 2 pts While covered in the Oracle PL/SQL textbook, pass-by-value procedures are black boxes that perform tasks by consuming inputs while returning a result in both Oracle and PostgreSQL databases. True Correct Answer False Question 2 2 / 2 pts In Oracle PL/SQL the pipelined functions can only return a SQL or PL/SQL data type. True Correct Answer False Question 3 2 / 2 pts Assume that list is a valid variable of a SQL collection variable. The following allocates one unit of memory to which you may assign a value in the list variable: list.EXTEND; Correct! True

False Question 4 2 / 2 pts Assume that list is a valid variable of a SQL collection containing ten variable length strings. The following assigns a literal string value to the highest allocated memory element: list[list.COUNT] := 'One'; Correct Answer True False Question 5 2 / 2 pts All database engines support a default table locking schema but some databases let you change that default. Correct! True False Quiz Score: 10 out of 10

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

W08 Quiz_2

Related Documents