Programming > QUESTIONS & ANSWERS > Quiz: Using Variables in PL/SQL _ Oakland Community College CIS 2616 (All)
Quiz: Using Variables in PL/SQL _ Oakland Community College CIS 2616
Document Content and Description Below
Quiz: Using Variables in PL/SQL 1. Evaluate the following declaration. Determine whether or not it is lega l. DECLARE test NUMBER(5); Mark for Review (1) Points legal (*) illegal 2. Evaluate th ... e following declaration. Determine whether or not it is lega l. DECLARE name,dept VARCHAR2(14); Mark for Review (1) Points legal illegal (*) Incorrect. Refer to Section 2 Lesson 1. 3. After they are declared, variables can be used only once in an applicat ion. True or False? Mark for Review (1) Points True False (*) Correct 4. A function called FORMAT_TODAYS_DATE accepts no parameters and returns today's date in the format: Month DD, YYYY The following anonymous block invokes the function: DECLARE v_today DATE; BEGIN -- invoke the function here Which of the following statements correctly assigns the date variable v_today to the value returned by the format_todays_date function? Mark for Review (1) Points format_todays_date := v_today('Month DD, YYYY'); [Show More]
Last updated: 2 years ago
Preview 1 out of 3 pages
-1.png)
Buy this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
Reviews( 0 )
$3.00
Can't find what you want? Try our AI powered Search
Document information
Connected school, study & course
About the document
Uploaded On
Jan 14, 2023
Number of pages
3
Written in
All
Additional information
This document has been written for:
Uploaded
Jan 14, 2023
Downloads
0
Views
51
