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. I/O: Max number of bytes to pass in a call to DBMS_OUTPUT.PUT_LINE.
composite
ALTER SESSION
255
HTF
2. The statement that is used to execute most (native) dynamic SQL.
RECORD OF ARRAYS
execute immediate
implicit
FALSE
3. Cursors: The SQL%BULK_ROWCOUNT attribute is an _________ -
array
OLD
GET_LINE
information that changes infrequently
4. DBMS_DDL.WRAP returns a string containing wrapped _____ _____.
source code
production
reference
obfuscates
5. The three possible values of a BOOLEAN literal.
REUSE SETTINGS
nested tables - associative arrays
True - false or NULL.
Server Pages
6. A ___________ behaves like a table column - but it is not stored in the table.
procedure P AUTHID current_user;
not the same
pseudocolumn
index
7. Default file extension of wrap's output file.
drop procedure
plb
database
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
8. Conversion: Implicit conversion can be (faster / slower) than explicit conversion.
column
order
1
slower
9. Cursors: What are the 3 possible values of SQL%FOUND and SQL%NOTFOUND?
TRUE - FALSE - NULL
invalid
RETURN
always
10. DynSQL: EXECUTE IMMEDIATE can be used for any SQL statement or PL/SQL block - except for ________ queries.
multi-row
Abstract
is certain
name-value
11. Fundamental: Maximum string length of a PL/SQL variable.
REF_CURSOR
inquiry
32 -000
FETCH
12. A type of compiler directive - begins with 's'.
FGA
bytecode
integrated
selection
13. Abbreviation of definer's rights
binding
DR
FORALL i IN MyList.FIRST..MyList.LAST
PVM
14. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
after
PRAGMA EXCEPTION_INIT (E - -1);
obfuscates
EXECUTE
15. DynSQL: The clause that receives single-row query output from EXECUTE IMMEDIATE.
1 million
literals
obfuscates
INTO
16. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.
1
block
IN - OUT - IN OUT
EXIT WHEN
17. A national character literal is composed of characters in the ________ character set.
package
national
define
plb
18. The compiler directive governing conditional compilation.
memory
definer's
$IF
Apache
19. Nested tables are multisets - meaning that there is no inherent _____ of their elements.
associative
cannot
is certain
order
20. Clause added to a cursor to use it with WHERE CURRENT OF.
%
for update of
USING
dynamic
21. Types: In addition to the SQL data types - PL/SQL has ___ more scalar data types.
do not
PSP
$$
4
22. Declare a cursor c with no parameters - and return type rC.
cursor c RETURN rC;
p.v
<<
exit when cgo%NOTFOUND
23. PLSQL_CCFLAGS hold a comma-separated list of ______ pairs (hyphenated).
name-value
3
colon
savepoint ab
24. Fundamental: What is the exponentiation operator?
numeric and cursor
30
**
/*
25. The PL/SQL virtual machine turns bytecode into system ______.
memory
calls
do not
EXIT
26. You can put a label before any executable PL/SQL _________.
v2 IN NUMBER default 20
function f (n number) return number result_cache relies_on (emps);
statement
closed
27. Dbms_sql: This DBMS_SQL function opens a new cursor.
TOO_MANY_ROWS
always
statement
OPEN_CURSOR
28. Declare an input NUMBER parameter - v2 - that defaults to 20.
block
implicit
for each row
v2 IN NUMBER default 20
29. IDs: You cannot use reserved words as ______ user-defined identifiers.
SIMPLE_INTEGER
ordinary
BOOLEAN
Server Pages
30. Command used to execute dynamic SQL.
specification - body
reference
HTF
EXECUTE IMMEDIATE
31. Triggers: The clause to make a trigger run once for every affected row.
for each row
exception
an enclosing block
searched
32. A GOTO cannot branch into a...
4K
lower sub-block
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
END IF
33. Cursors: If you use an EXIT statement to exit a cursor FOR loop prematurely - the cursor (is / is not) closed automatically.
loop
is certain
is
always
34. The variable showing the user id that is automatically prepended to object names.
DECLARE - BEGIN - EXCEPTION - END
=
CURRENT_USER
a cursor
35. Give the first line of the FOR loop with index i going from 1 to 10 in reverse.
FOR i IN REVERSE 1..10 LOOP
API
constrained
END LOOP
36. Exceptions: Type ______ to re-raise the current exception.
SYS_REFCURSOR
PSP
RAISE
INSTEAD OF
37. An anonymous block always has _________ rights.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
38. Statement to set current schema to x: _____ _____ SET CURRENT_SCHEMA = 'x';
ALTER SESSION
dynamic
COUNT
finishes
39. You can define PL/SQL collections using TYPEs defined in the _______.
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
database
USER_PROCEDURES
EXIT WHEN cv%NOTFOUND
40. Make a FOR loop that executes NULL 10 times counting in reverse - using index i.
anonymous block
never
deletions
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
41. The method to add one or more elements to a nested table or VARRAY is ______.
literal
OUT
cursor c RETURN rC;
EXTEND
42. Types: One of the 4 PL/SQL things that have a data type (begins with 'r').
searched
ROLLBACK
compilation
return value
43. Language that PL/SQL is derived from.
value
SQLCODE
statement
Ada
44. Triggers: By default - a trigger is created in the ______ state.
set serveroutput on
enabled
3
DATE
45. Exceptions: An unhandled exception ________ to the enclosing block.
propagates
raise_application_error(-20 -100 - 'Bad');
IN OUT
cursor
46. DynSQL: Native Dynamic SQL
sequence pseudo-columns
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
NDS
%BULK_ROWCOUNT
47. 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
48. You can have many autonomous transactions in ___________.
UTL_HTTP
WHERE CURRENT OF
an autonomous routine
invoker's
49. What clause makes a compilation default to the PLSQL_CCFLAGS settings from the last compilation?
L.V
PSP
name
REUSE SETTINGS
50. 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