PLSQL_Semester_1_Mid_Term_Review.pdf

Oracle Academy 1 Database Programming with PL/SQL Copyright ? 2010, Oracle. All rights reserved. Database Programming with PL/SQL Semester 1 Mid Term Review Name: _________________________________________ 1. PL/SQL stands for ____________________. 2. PL/SQL is a ______ programming language. 3. The PL/SQL language uses which of the following (circle answer): a. Variables b. Cursors c. Conditional logic d. Data definition language 4. The basic unit in a PL/SQL program is a __________. 5. PL/SQL allows you to logically combine multiple SQL statements as one unit or block. The application can send the entire block to the database instead of sending the SQL statements one at a time. This significantly reduces the number of database calls. (True or False) 6. Name the three sections of a PL/SQL block. ____________________ ____________________ ____________________ 7. The declarative section contains SQL statements and PL/SQL statements to manipulate data in the database. (True or False) 8. The three types of blocks that can make up a PL/SQL program are (circle answer): a. Anonymous b. Procedures c. Manipulative d. Functions Oracle Academy 2 Database Programming with PL/SQL Copyright ? 2010, Oracle. All rights reserved. 9. The following is what type of PL/SQL program? ____________________ DECLARE v_date DATE := SYSDATE; BEGIN DBMS_OUTPUT.PUT_LINE(v_date); END; 10. Where are subprograms stored? ____________________ 11. In the LIKE operator, which symbol is used to represent a single text character or numeric digit (circle answer)? a. _ b. / c. d. % asdf 12. Which of the following can be used in the SELECT statement to return all columns of data in a table (circle answer)? a. ALL b. Columns c. * d. DISTINCT 13. The __________ keyword is used to eliminate duplicate rows from the output of a SQL statement. 14. __________ is a general function that converts a null value to a date,