SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
Search
Test your basic knowledge |
Oracle PL - SQL
Start Test
Study First
Subjects
:
oracle
,
it-skills
Instructions:
Answer 50 questions in 15 minutes.
If you are not ready to take this test, you can
study here
.
Match each statement with the correct term.
Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.
This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. Statement to set current schema to x: _____ _____ SET CURRENT_SCHEMA = 'x';
numeric and cursor
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
SQL
ALTER SESSION
2. Advantage: PL/SQL is tightly _______ with Oracle SQL.
-20 -000
optional
DBMS_PREPROCESSOR
integrated
3. Advantage: PL/SQL gives SCALABILITY because stored procedures are executed on the _______.
cursor c;
lowest
server
DATE
4. Command to create a procedure.
create procedure
cached
SUBTYPE numb IS number;
Apache
5. You can put a label before any executable PL/SQL _________.
statement
%ROWTYPE
anonymous
OTHERS
6. The source for wrapping begins with the word ______.
True - false or NULL.
EXIT WHEN
create
pseudocolumn
7. Cursors: Closing keywords of a cursor FETCH loop.
ROLLBACK
r tRec := tRec(9 - 'Jones');
ex := tbl1 MULTISET EXCEPT tbl2
END LOOP
8. Triggers: On a non-editioning view - you can only define __________ triggers.
INSTEAD OF
column
virtual machine
FOR i IN REVERSE 1..10 LOOP
9. The declaration section is (optional/mandatory).
same arguments
array
once
optional
10. An autonomous program runs in its own __________.
associative
STANDARD
transaction
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
11. For a collection - the NEXT method returns ____ when there is no next index value.
Declaration
DBMS_SQL
-
12. Give the statement to make a program autonomous.
PRAGMA AUTONOMOUS_TRANSACTION;
query
NUMBER
context
13. Web: Abbreviation of PL/SQL Server Page.
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
inquiry
PSP
unqualified
14. Advantage: Having procedures stored and executed on the server makes PL/SQL ________.
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
RECORDS
scalable
bytecode
15. Exceptions: Write the call (2 args) to associate message 'Bad' with error code -20 -100.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
16. A GOTO statement cannot branch from an exception handler back into the...
True - false or NULL.
..
current BEGIN-END block
API
17. To exit an active autonomous transaction without causing an exception - you must issue _____ or ______.
SESSION_USER
commit - rollback
DBMS_SESSION.RESET_PACKAGE
scalable
18. In a sparse collection - the indexes of defined elements (do / do not) run in consecutive order.
server
do not
create
USING
19. Declare an associative array type - t - whose elements are of type rPerson - and whose index is PLS_INTEGER.
DBMS_SESSION
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
DBMS_CRYPTO
FORALL i IN MyList.FIRST..MyList.LAST
20. I/O: The DBMS_OUTPUT buffer will not be flushed until it is full or until the current PL/SQL block _________.
EXIT
RETURN
finishes
injection
21. Types: One of the scalar data types specific to PL/SQL: B_______
current transaction
open C
L.V
BINARY_INTEGER
22. GOTO branches to a ________.
EXIT
PRAGMA AUTONOMOUS_TRANSACTION;
autonomous transaction
label
23. Triggers: In a trigger - you cannot issue a COMMIT or a ______.
elsif
error
slower
ROLLBACK
24. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
source code
NUMBER
collections
elements
25. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.
CHAR - VARCHAR2
single-line
Server Pages
NDS
26. Cursors: You can just declare a cursor at first - then _______ it later.
an AUTHID property
define
PUT
before insert or update on emps
27. The FIRST method gets the first (element / index) of a collection.
after insert on emps
index
-
DBMS_PREPROCESSOR
28. You can have many autonomous transactions in ___________.
p.v
cursor number
an autonomous routine
current transaction
29. The DEFINITION of a cursor is the _____ that returns the records.
name and datatype
BINARY_INTEGER
library
query
30. PL/SQL does not automatically create bind variables in ________ SQL.
dynamic
BINARY_INTEGER
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
scalar
31. I/O: One of the 3 types of data that can be passed to the DBMS_OUTPUT buffer.
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
non-editioning views
VARCHAR2
integrated
32. Exceptions: The _________ package defines the PL/SQL environment.
dense
do not
$IF
STANDARD
33. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.
anonymous
.
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
dense
34. Bulk: The use of FORALL statements cuts down on ______ traffic.
network
NDS
ENABLE
query
35. The meaning of 'FGA'.
BINARY_INTEGER
not a number
can
fine-grained auditing
36. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
@
Gateway
IR
DATE
37. Cursors: The second keyword of a FETCH statement.
INTO
5
native dynamic
OTHERS
38. I/O: This package has hypertext procedures that generate HTML tags
3
unqualified
HTP
is not
39. To run TCL or DDL statements - a trigger (must / must not) be autonomous .
for update of
must
timing
OPEN
40. How many times are a FOR loop's index bounds evaluated?
does not
once
literals
boolean
41. IDs: The 3 non-alphanumeric characters that can be in an ordinary user-defined identifier.
PRAGMA EXCEPTION_INIT (E - -1);
ALTER SESSION
open C
# - $ - _
42. IDs: You cannot use reserved words as ______ user-defined identifiers.
injection
Gateway
ROLLBACK
ordinary
43. I/O: Max number of bytes to pass in a call to DBMS_OUTPUT.PUT_LINE.
INSTEAD OF
OPEN
Gateway
255
44. A user-defined TYPE can have...
an AUTHID property
alter procedure
invoker's
%ROWTYPE
45. The statement that is used to execute most (native) dynamic SQL.
BOOLEAN
statically
open cv for
execute immediate
46. In the special IF syntax - is it ELSIF - or ELSEIF?
INSTEAD OF
UTL_HTTP
elsif
BINARY_INTEGER
47. Parameter that controls how much Oracle optimizes your PL/SQL code on compilation.
associative
integer
PLSQL_OPTIMIZE_LEVEL
DBMS_DDL
48. Fundamental: Character used to escape a single quote inside a literal.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
49. Fundamental: One of the 4 types of lexical units: d_____
FETCH
TIMESTAMP.
delimiters
index
50. PL/SQL is a ________ typed programming language.
bind
NDS
statically
L.V
Can you answer 50 questions in 15 minutes?
Let me suggest you:
Browse all subjects
Browse all tests
Most popular tests
Major Subjects
Tests & Exams
AP
CLEP
DSST
GRE
SAT
GMAT
Certifications
CISSP go to https://www.isc2.org/
PMP
ITIL
RHCE
MCTS
More...
IT Skills
Android Programming
Data Modeling
Objective C Programming
Basic Python Programming
Adobe Illustrator
More...
Business Skills
Advertising Techniques
Business Accounting Basics
Business Strategy
Human Resource Management
Marketing Basics
More...
Soft Skills
Body Language
People Skills
Public Speaking
Persuasion
Job Hunting And Resumes
More...
Vocabulary
GRE Vocab
SAT Vocab
TOEFL Essential Vocab
Basic English Words For All
Global Words You Should Know
Business English
More...
Languages
AP German Vocab
AP Latin Vocab
SAT Subject Test: French
Italian Survival
Norwegian Survival
More...
Engineering
Audio Engineering
Computer Science Engineering
Aerospace Engineering
Chemical Engineering
Structural Engineering
More...
Health Sciences
Basic Nursing Skills
Health Science Language Fundamentals
Veterinary Technology Medical Language
Cardiology
Clinical Surgery
More...
English
Grammar Fundamentals
Literary And Rhetorical Vocab
Elements Of Style Vocab
Introduction To English Major
Complete Advanced Sentences
Literature
Homonyms
More...
Math
Algebra Formulas
Basic Arithmetic: Measurements
Metric Conversions
Geometric Properties
Important Math Facts
Number Sense Vocab
Business Math
More...
Other Major Subjects
Science
Economics
History
Law
Performing-arts
Cooking
Logic & Reasoning
Trivia
Browse all subjects
Browse all tests
Most popular tests