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. Package for getting the postprocessed source of a program.
same
DBMS_PREPROCESSOR
dynamic
5
2. The four keywords that define a PL/SQL block.
network
do not
$$PLSQL_LINE
DECLARE - BEGIN - EXCEPTION - END
3. PL/SQL lets you define two kinds of composite data types: _______ and _______
name
collections - records
Abstract
PL/SQL
4. Default file extension of wrap's output file.
plb
portable
open C(p)
rollback to ab
5. Cursors: You give an explicit cursor a name and associate it with a _______.
dynamic
IF - CASE or LOOP
IN OUT
query
6. A kind of variable used as a placeholder.
virtual machine
collections - records
once
bind
7. To get the current value of CURRENT_SCHEMA - CURRENT_USER - or SESSION_USER - use the ____ function.
PRAGMA AUTONOMOUS_TRANSACTION;
SYS_CONTEXT
CHAR - VARCHAR2
value
8. I/O: This package has hypertext procedures that generate HTML tags
vname CONSTANT VARCHAR2 := 'x';
is certain
HTP
suspended
9. Data dictionary view giving the AUTHID values on a user's objects.
USER_PROCEDURES
'
manageable
1
10. Delimiters: The association operator.
database
EXIT WHEN
=>
compiles
11. List the transaction control statements.
TIMESTAMP.
dbms_output.put_line
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
transaction
12. Triggers and views always have _________ rights.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
13. Delimiters: Item separator.
invoker's
p.v
CURSOR - RETURN
14. A large OUT or IN OUT parameter will waste a lot of space and CPU if it is passed by _____.
invoker's
obfuscates
value
PLSQL_OPTIMIZE_LEVEL
15. Triggers: In a per-row trigger - the ____ record shows you the changed state of an affected row.
NEW
unconstrained
USING
CHAR - VARCHAR2
16. A numeric FOR loop cannot _________ by other than 1?
concatenation
increment
SESSION_USER
17. IDs: Maximum number of bytes in a user-defined identifier.
after
NDS
30
aggregate - analytical
18. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.
CURRENT_USER
name and datatype
4K
OTHERS
19. IDs: What a quoted user-defined identifier is enclosed in.
can
cannot
never
Double quotes.
20. Kind of datatypes that support object-oriented programming in PL/SQL.
machine
Web Toolkit
Abstract
INTO
21. Cursors: The second keyword of a FETCH statement.
compilation
HTF
INTO
4
22. Types: One of the scalar data types specific to PL/SQL: R_________.
OPEN_CURSOR
invoker's
constant
REF_CURSOR
23. The attribute used to get the type of a row without knowing what it is.
block
dynamic
%ROWTYPE
RETURN
24. Abbreviation for Abstract Data Type.
ADT
base
cursor
comments
25. Mode designation for an input/output parameter.
information that changes infrequently
commit - rollback
EDITION_NAME
IN OUT
26. Conversion: It is best to use (implicit / explicit) conversion.
Web Toolkit
TYPE tV IS VARRAY(100) OF NUMBER
vname CONSTANT VARCHAR2 := 'x';
explicit
27. The BETWEEN operator is (inclusive / exclusive).
OUT
collections - records
SQL cursor
inclusive
28. How many types of compiler directives are there?
TYPE tV IS VARRAY(100) OF NUMBER
commit - rollback
3
IS
29. Nested tables can become sparse via ______.
deletions
savepoint ab
simple and compound symbols
currval and nextval
30. Command to assign to variables from a cursor.
BINARY_INTEGER
timing
FETCH
v3 IN OUT NUMBER
31. PLS_INTEGER has its arithmetic implemented in ________ - so it is very fast.
PVM
execute immediate
hardware
preprocessor
32. I/O: The buffered output of dbms_output.put_line is retrieved by _______.
SQLPlus
pseudocolumn
aggregate - analytical
EXIT WHEN cv%NOTFOUND
33. A FOR-loop counter is defined only within the _____.
anonymous block
loop
statement
exit when cgo%NOTFOUND
34. A CASE statement (can / cannot) execute more than one group of statements.
virtual machine
cannot
server
Keywords and predefined names.
35. Dbms_sql: DBMS_SQL package is compiled with _______ rights.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
36. You can have many autonomous transactions in ___________.
SQLERRM
IS
Server Pages
an autonomous routine
37. A nested table has to be initialized using a ________ - named the same as the type.
32 -000
unconstrained
source
constructor
38. If a result-cached function's data source (based on the RELIES_ON clause) is updated - any cached results become _______.
invalid
OLD
DBMS_SESSION
cursor variable
39. The attribute used to get the type of a column or variable without knowing what it is.
%TYPE
pseudocolumn
selection
INSTEAD OF
40. Which two collection types are unbounded?
cursor variable
4K
integrated
nested tables - associative arrays
41. What are the two sequence pseudo-columns?
comments
nested
finishes
currval and nextval
42. The variable showing the user id that is automatically prepended to object names.
<<>>
bind
CURRENT_USER
network
43. Types: ______ data types are those storing values with no internal components.
scalar
SQLCODE
SQLPlus
production
44. The DEFINITION of a cursor is the _____ that returns the records.
TRUE - FALSE and NULL
query
PLSQL_OPTIMIZE_LEVEL
OPEN_CURSOR
45. Cursors: A cursor with a name is an _________ cursor.
%ROWTYPE
explicit
an AUTHID property
IS
46. DynSQL: The main command for Native Dynamic SQL.
EXIT WHEN
VARRAYs
EXECUTE IMMEDIATE
NEW
47. I/O: The DBMS_OUTPUT function that writes output without a newline character.
executable
PUT
composite
buffer
48. An $ERROR directive ends with _____.
$END
4
statement
placeholders
49. Delimiters: the attribute indicator.
index
1
SESSION_USER
%
50. Fundamental: One of the 4 types of lexical units: d_____
CURSOR - RETURN
STANDARD
delimiters
loop