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. IDs: The two types of words that can - but should not - be used as user-defined identifiers.
anonymous
invalid
VARRAYs
Keywords and predefined names.
2. Which two of these built-in SQL functions can be used in procedural (PL/SQL) statements: DECODE - CORR - UPPER - SUM - COALESCE - DEREF.
comments
order
raise_application_error(-20 -100 - 'Bad');
upper - coalesce
3. The allowed data types of user-defined conditional compilation directives are boolean and _______.
pls_integer
exception
selection
buffer
4. I/O: This package handles HTTP.
stored
UTL_HTTP
EXIT WHEN
transaction
5. IDs: The type of words that cannot be user-defined identifiers.
procedure P AUTHID definer;
Reserved words.
DBMS_DDL
INTO
6. Nested tables are multisets - meaning that there is no inherent _____ of their elements.
is
DEFINER
order
1
7. Wrapped code (is / is not) not backward compatible.
quoted
UTL_SMTP
is not
Reserved words.
8. A kind of variable used as a placeholder.
multi-row
DML
bind
With a letter.
9. Delimiters: The left label delimiter.
associative
<<
obfuscates
do not
10. Exceptions: A GOTO statement CAN branch from an exception handler into an ________ block.
DML
nested tables - associative arrays
after
enclosing
11. Declare an associative array type - t - whose elements are of type rPerson - and whose index is PLS_INTEGER.
# - $ - _
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
currval and nextval
user-defined
12. Default file extension of wrap's output file.
PLS_INTEGER
anonymous
%ISOPEN.
plb
13. Cursors: WHERE _______ ______ makes an UPDATE or DELETE apply to the current row of a cursor.
cannot
external subprogram
CURRENT OF
stored
14. You have to use _______ SQL to run DDL statements n PL/SQL.
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
loop
dynamic
cannot
15. An $ERROR directive ends with _____.
expression
SQL
constrained
$END
16. Clause added to a cursor to use it with WHERE CURRENT OF.
EXECUTE IMMEDIATE
for update of
..
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
17. The NOCOPY option on an OUT or IN OUT parameter - causes it to be passed by ______.
reference
source
elsif
session cursor
18. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.
subtype
after
suspended
DBMS_CRYPTO
19. INSTEAD OF triggers are alternatives to ___ triggers
fail
name-value
DML
DECLARE - BEGIN - EXCEPTION - END
20. Cursors: You cannot use cursor attributes in _______ statements.
significant
SQL
raise_application_error
searched
21. Statement to exit a cursor loop on cursor cGo when there are no more records.
exit when cgo%NOTFOUND
single-line
procedure P AUTHID definer;
NESTED TABLE myColl STORE AS myCollTab
22. I/O: The DBMS_OUTPUT function that writes output WITH a newline character.
varray
obfuscates
lower sub-block
PUT_LINE
23. IDs: How an ordinary user-defined identifier must begin.
DML
composite
With a letter.
/*
24. Cursors: You can just declare a cursor at first - then _______ it later.
define
numeric and cursor
CURRENT_USER
unhandled
25. With a result-cached function - it uses a cached value when the function is called again with the...
iname
Gateway
OLD
same arguments
26. Web: PL/SQL _______ enables a Web browser to invoke a PL/SQL stored subprogram through an HTTP listener.
DBMS_PREPROCESSOR
Gateway
TRUE - FALSE - NULL
RELIES_ON
27. Exceptions: Pragma that links an exception to an Oracle error code.
EXCEPTION_INIT
%BULK_ROWCOUNT
FETCH
explicit cursor
28. Wrapping can be done with the ____ executable.
wrap
cannot
RETURN
searched
29. The BETWEEN operator is (inclusive / exclusive).
EXIT
ROLLBACK
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
inclusive
30. Cursors: A Cursor FOR loop does not use a ______ statement.
Keywords and predefined names.
FETCH
OTHERS
dynamic
31. Fundamental: Maximum string length of a PL/SQL variable.
32 -000
BOOLEAN
session cursor
loop
32. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
SESSION_USER
implicit
enclosing
significant
33. I/O: The PL/SQL I/O packages (can/cannot) accept input directly from the keyboard.
currval and nextval
cannot
1 million
strong
34. Fundamental: One of the 4 types of lexical units: L_____
executable
executable
RESULT_CACHE
literals
35. Triggers: The clause to make a trigger run after inserting into table EMPS.
anonymous block
DBMS_DDL
query
after insert on emps
36. Cursors: A session cursor that is automatically created and managed by PL/SQL.
implicit cursor
WHERE CURRENT OF
FETCH
UTL_FILE
37. Bulk: The use of FORALL statements cuts down on ______ traffic.
network
can
a number := 10
FORALL i IN MyList.FIRST..MyList.LAST
38. Cursors: The first two keywords in a Cursor FOR loop.
base
%ISOPEN.
EXECUTE
FOR - IN
39. Cursors: The three keywords in a full cursor declaration/definition (before the SELECT).
package
CURSOR - RETURN - IS
exit when cgo%NOTFOUND
binding
40. Give the ANSI Date literal for December 25 - 2005.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
41. Statement to set current schema to x: _____ _____ SET CURRENT_SCHEMA = 'x';
wrap
concatenation
finishes
ALTER SESSION
42. Triggers and views always have _________ rights.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
43. Fundamental: Delimiters are _____ and _____ symbols.
concatenation
simple and compound symbols
current
32 -000
44. Records are one of the two kinds of PL/SQL _______ data types.
does not
external subprogram
must
composite
45. Cursors: The Oracle predefined REF CURSOR type.
run
scalar
SYS_REFCURSOR
value
46. Abbreviation of definer's rights
flushed
EXTEND
network
DR
47. What are two categories of SQL functions that cannot be used in procedural statements?
boolean
EDITION_NAME
USING
aggregate - analytical
48. Fundamental: One of the 4 types of lexical units: d_____
define
delimiters
current BEGIN-END block
4K
49. Declaration of a varchar2 constant - called vname - with value 'x'.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
50. Types: ________ data types have no internal components.
r t.%ROWTYPE;
scalar
STANDARD
CURRENT_USER - DEFINER