Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
28 Cards in this Set
- Front
- Back
|
Which of the following statements is true? a. you can embed PL/SQL statements within SQL code c. you can embed procedural constructs within SQL code D. none |
b. You can embed SQL statements within PL/SQL code |
|
|
PL/SQL stands for |
Procedural language extension in SQL |
|
|
Which of the following statements about SQL is true? A) SQL is an Oracle proprietary, nonprocedural, 4GL programming language. B) SQL is an Oracle proprietary, procedural, 3GL programming language. C) SQL is an ANSI-compliant, nonprocedural, 4GL programming language D) SQL is an ANSI-compliant, procedural, 4GL programming language. |
C) SQL is an ANSI-compliant, nonprocedural, 4GL programming language |
|
|
Nonprocedural languages allow the programmer to produce a result when a series of steps are followed. True or False? |
False |
|
|
In which three ways does PL/SQL extend the SQL programming language? (Choose 3) A) By adding procedural constructs. B) By adding compound constructs. C) By adding iterative control. D) By adding conditional control. |
A) By adding procedural constructs. C) By adding iterative control.D) By adding conditional control. |
|
|
Which of the following statements is true?A) PL/SQL is an Oracle proprietary, procedural, 3GL programming language. B) PL/SQL is an Oracle proprietary, procedural, 4GL programming language. C) PL/SQL is an Oracle proprietary, nonprocedural, 3GL programming language. D) PL/SQL is an ANSI-compliant, procedural programming languag |
A |
|
|
Oracle corporations standard procedural language for relational databases which allows basic program logic and control flow to be combined with SQL statements |
PL/SQL |
|
|
PL/SQL criteria |
3GL,Procedural, proprietary to Oracle Corporation |
|
|
SQL criteria |
4GL, non-procedural, ansi-complianT |
|
|
Why is a procedural language like PL/SQL needed |
PL/SQL is usedto create the steps in the non-procedural SQL code. It will shorten, what wouldbe many statements in order to create the correct output, to just a few linesof code. |
|
|
Whatis a procedural construct?s |
ProceduralConstruct is when procedural code is written and SQL data-accessing statementsare embedded within the PL/SQL code. It produces a result when a series ofinstructions are followed. |
|
|
Listsome examples of proceduralconstructs in PL/SQL |
Variable, Constants, types, controlstructures such as loops and reusable program units that are written once andexecuted many times. |
|
|
You can create a web site application written entirely in PL/SQL. true or false? |
True |
|
|
PL/SQL differs from C and Java in which of the following ways? (Choose two.) A) It requires an Oracle database or tool. B) It does not support object-oriented programming. C) It is the most efficient language to use with an Oracle database. D) It is the most complex programming language to learn. E) It is not portable to other operating systems. |
A,C |
|
|
Which of the following can be compiled as a standalone program outside the database? A) A program developed in PL/SQL B) A program developed in Java C) A program developed in C D) All the aboveE) Programs developed in Java or C, but not in PL/SQL. |
E |
|
|
When multiple SQL statements are combined into PL/SQL blocks, performance improves. True or False? |
True |
|
|
Which of the following can be done using PL/SQL? A) Create complex applications. B) Retrieve and modify data in Oracle database tables. C) Manage database tasks such as security. D) Manage database tasks such as security. E) All of the above |
E |
|
|
Procedural constructs give you better control of your SQL statements and their execution |
True |
|
|
The ability for PL/SQL programs to run anywhere an Oracle server runs |
Portability |
|
|
The basic unit of PL/SQL programs also known as modules |
Block |
|
|
An error that occurs in the database in a user's program during runtime |
exception |
|
|
Why is it more efficientto combine SQL statements into PL/SQLblocks? |
Combining SQL statements into PL/SQLshortens the code that actually has to be written. You are more efficient bywriting one block of code instead of multiple SQL statements. You have bettercontrol over the code and the execution. You can had control and conditionalstatements in order to gain this control. --> |
|
|
Why is it beneficial to use PL/SQL with an Oracledatabase? List atleastthree reasons. |
Portability,which allows for the program to run anywhere an Oracle Server runs regardlessof operating system and platform. There is no need to tailor the program.Exception handling, with PL/SQL you can write exception handle code to preparefor errors or exceptions that may occur. These exception handle codes tell theprogram what to do in the event of an exception or error.Integrationof procedural construct with SQL, allows you to have better control of the SQLstatement and execution. |
|
|
How is PL/SQL different from C and Java? List three differences. |
PL/SQL requires an Oracle database ortool and C and Java do not. PL/SQL is object-oriented on some features where Cis not and Java is all the time. PL/SQL is more very efficient in comparison inthe performance against an Oracle database. PL/SQl and Jave are both portableto different operating systems and C is only somewhat portable. Lastly, PL/SQLis relatively easy compared to C and Java. |
|
|
List three examplesof what you can build with PL/SQL code. |
WithPL/SQL code you can write the following:Oracledatabase 11g, you can write PL/SQL to manage application data or to manage theoracle database itself. OracleApplication Server 10g, you can create database-centric web applications thatare written entirely or partially of PL/SQL using the using the web applicationtoolkit.OracleApplication Express, You can develop web application that includes PL/SQL usinga web browser. |
|
|
Which lines of code will correctly display the message "Hello World" ? (Choose two.) A) DBMS_OUTPUT('Hello World'); B) DBMS_OUTPUT.PUT_LINE('Hello World'); C) DBMS_OUTPUT.PUT_LINE('Hello' || 'World'); D) DBMS_OUTPUT.PUT_LINE('Hello' || ' ' || 'World'); |
B,D |
|
|
How can you display results to check that a PL/SQL block is working correctly? A) You don't need to do anything, the results will display automatically. B) Use an Exception section C) Use DBMS_OUTPUT.PUT_LINED) D)Write a C or Java program to display the results |
C |
|
|
What are the characteristics of a PL/SQL stored subprogram? (Choose two.) A) Named B) Not stored in the database C) Can be invoked at any time D) Do not exist after they are executed |
A,B |
