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. The attribute used to get the type of a column or variable without knowing what it is.
E Exception;
%TYPE
1
cursor
2. Conditional ______ allows backward compability with older database versions.
32 -000
SUBTYPE n IS number not null;
compilation
static boolean
3. By default - an IN parameter is passed by ______.
reference
.
NEW
DML
4. The _____ and ____ _____ collection types can be used in database table columns.
IN OUT
cursor
VARRAY - Nested table
inclusive
5. Types: ________ data types have internal components.
implicit cursor
index
SYS_CONTEXT
composite
6. Collections are one of the two kinds of PL/SQL _______ data types.
DECLARE - BEGIN - EXCEPTION - END
aliases
nested tables - associative arrays
composite
7. Give the clause you add to a CREATE TABLE statement - when there is a collection column myColl - that you want to be stored in a table called myCollTab.
NESTED TABLE myColl STORE AS myCollTab
DML
cursor
drop procedure
8. The Wrap utility ________ the source code.
obfuscates
wrap
index
DBMS_SESSION.RESET_PACKAGE
9. Exceptions: The maximum length of an Oracle error message is ____ characters
$END
512
exception handler
1
10. How many times are a FOR loop's index bounds evaluated?
binding
once
delimiters
is certain
11. Statement to set current schema to x: _____ _____ SET CURRENT_SCHEMA = 'x';
ALTER SESSION
SESSION_USER
fields
PSP
12. Searchable CASE statement: Each WHEN has its own _______ condition.
CHAR - VARCHAR2
boolean
external subprogram
NUMBER
13. The variable showing the user id that is automatically prepended to object names.
run
CURRENT_USER
lock
closed
14. Declare a constrained subtype of NUMBER called N that is not null.
package
With a letter.
512
SUBTYPE n IS number not null;
15. Types: PL/SQL has all the _____ data types.
never
SQL
include
compile
16. Default file extension of wrap's output file.
plb
aggregate - analytical
FETCH
anonymous block
17. The $ERROR directive is used to make compilation ____.
NESTED TABLE myColl STORE AS myCollTab
cursor number
can
fail
18. NAN stands for _________.
nested
not a number
%BULK_ROWCOUNT
1
19. Default value of PLSQL_OPTIMIZE_LEVEL.
is certain
EXIT
2
API
20. The NOCOPY option on an OUT or IN OUT parameter - causes it to be passed by ______.
expression
reference
VARCHAR2
EXIT
21. IDs: You (can/cannot) use keywords as ordinary user-defined identifiers.
binding
:=
can
$$PLSQL_LINE
22. Types of blocks: A pl/sql block that is not stored in the database.
anonymous
delimiters
EXIT WHEN
dense
23. A nested table has to be initialized using a ________ - named the same as the type.
constructor
network
Web Toolkit
anonymous
24. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
512
DATE
is
OTHERS
25. Exceptions: An exception raised inside an _______ _______ propagates immediately to the enclosing block
exception handler
cursor
constructor
current BEGIN-END block
26. The EXTEND method is not used with ______ _______.
Ada
PLS_INTEGER
associative arrays
library
27. Kind of code created by the PL/SQL compiler.
bytecode
3
GET_LINE
EXECUTE IMMEDIATE
28. In a sparse collection - the indexes of defined elements (do / do not) run in consecutive order.
implicit
do not
5
ROLLBACK
29. Name the two types of FOR loop.
numeric and cursor
elements
INTO
EXTEND
30. Conversion: If the specific value is suitable - ____ or _______ values can convert to almost any datatype
CHAR - VARCHAR2
$END
implicit
1 million
31. 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
32. Fundamental: One of the 4 types of lexical units: d_____
@
same
FETCH
delimiters
33. The _____ utility turns PL/SQL source code into unreadable text.
Wrap
associative
column
34. You can put a label before any executable PL/SQL _________.
$IF $THEN $ELSE $END
Ordinary - Quoted.
statement
FETCH - INTO
35. The allowed data types of user-defined conditional compilation directives are boolean and _______.
pls_integer
cursor variable
30
lock
36. List the transaction control statements.
savepoint ab
database
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
composite
37. The BEGIN section is (optional/mandatory)
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
mandatory
bind arguments
..
38. Cursors: The statement that closes a cursor.
CLOSE
# - $ - _
USING
a number := 10
39. Cursors: A cursor with a name is an _________ cursor.
explicit
virtual machine
associative
FETCH
40. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.
DATE
HTP
IN - OUT - IN OUT
Double quotes.
41. 5 types of events that can have triggers: DML - DDL - INSTEAD OFs - database events - and ________ statements.
suspended
exception handler
current BEGIN-END block
RECORDS
42. Cursors: Opening keyword of a cursor FETCH loop.
versions
cursor c RETURN rC;
LOOP
not a number
43. Types: The only Oracle datetime type that doesn't begin with TIMESTAMP is ________.
DATE
current transaction
USER_PLSQL_OBJECT_SETTINGS
RECORD OF ARRAYS
44. The AUTHID property applies to PL/SQL objects that contain _____.
cannot
code
explicit cursor
database
45. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
NUMBER
statement
integrated
cached
46. Conversion: Just about everything will implicitly convert to _____ or _________.
CHAR - VARCHAR2
injection
p.v
DBMS_DDL
47. The DECLARE keyword is only required in an _______ _______.
anonymous block
concatenation
close C
always
48. The meaning of 'FGA'.
procedure P AUTHID definer;
manageable
fine-grained auditing
for update of
49. The RESULT_CACHE clause has to be in both the declaration and in the ______ of the function.
NUMBER
REF CURSOR
INSTEAD OF
definition
50. Types: ______ data types are those storing values with no internal components.
specification - body
open C(p)
Ada
scalar