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. In Native Mode - PL/SQL code is compiled into ______ ______.
..
machine code
cursor c RETURN rC;
DML
2. I/O: This package has hypertext functions that generate HTML tags
3
HTF
definition
=>
3. Nested tables can become sparse via ______.
DATE
SQL
deletions
pseudocolumn
4. Exceptions: Start of the range of error codes for RAISE_APPLICATION_ERROR.
..
-20 -000
composite
scalar
5. DynSQL: The standard package that does dynamic SQL.
DBMS_SQL
WHEN OTHERS THEN
DATE
DBMS_SESSION.RESET_PACKAGE
6. I/O: SQLPlus command for turning on buffered output.
unqualified
sql
BINARY_INTEGER
set serveroutput on
7. A CASE expression ends with _____.
1
END
drop procedure
aggregate - analytical
8. Cursors: What are the 3 possible values of SQL%FOUND and SQL%NOTFOUND?
TRUE - FALSE - NULL
finishes
elements
<<
9. Types: One of the 4 PL/SQL things that have a data type (begins with 'r').
return value
$$
cannot
plb
10. A type of compiler directive - begins with 's'.
selection
block
4
SQL
11. 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.
single-line
NESTED TABLE myColl STORE AS myCollTab
is certain
invoker's
12. Cursors: Define a ref cursor type called T.
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
boolean
type T is ref cursor
do not
13. Term for a character literal with zero characters.
IR
null string
order
Oracle
14. You (can/cannot) put a label before an END LOOP statement.
CHAR - VARCHAR2
SQL cursor
fail
cannot
15. A subprogram defined within another subprogram is a _______ subprogram.
fetch cv into myvar
FOR - IN
nested
%ROWTYPE
16. Cursors: The statement where you pass the parameters to a cursor.
calls
OPEN
autonomous transaction
information that changes infrequently
17. Triggers: You (can/cannot) explicitly invoke a trigger.
BINARY_INTEGER
CURRENT OF
can
cannot
18. How many times are a FOR loop's index bounds evaluated?
4
null string
once
SQL cursor
19. The three sorts of date/time types are DATE - INTERVAL and _________.
TIMESTAMP.
unqualified
:=
after insert on emps
20. An anonymous block is a(n) ____ statement.
SQL
END
1
PSP
21. The FIRST method gets the first (element / index) of a collection.
index
not the same
<<
'ENABLE:SEVERE' - 'ERROR:06002'
22. In the IF syntax - is if ENDIF or END IF?
value
END
END IF
current
23. Types: One of the 4 PL/SQL things that have a data type (begins with 'p').
parameter
scalar
anonymous block
slower
24. Conditional compilation is useful for compiling a program under different ______ of Oracle.
pseudocolumn
BINARY_INTEGER
after
versions
25. I/O: The PL/SQL I/O packages (can/cannot) accept input directly from the keyboard.
an AUTHID property
cannot
TRUE - FALSE and NULL
1
26. A CASE statement (can / cannot) execute more than one group of statements.
FETCH - BULK COLLECT INTO
FOR i IN REVERSE 1..10 LOOP
for update of
cannot
27. Give the statement to make a program autonomous.
OPEN
BINARY_INTEGER
PRAGMA AUTONOMOUS_TRANSACTION;
run
28. Clause added to a cursor to use it with WHERE CURRENT OF.
r t.%ROWTYPE;
for update of
source
error code
29. Triggers: In a per-row trigger - the ____ record shows you the original state of an affected row.
OLD
ADT
fail
nested
30. Exceptions: The package that defines pre-defined exceptions.
ROLLBACK
pls_integer
simple
STANDARD
31. Exceptions: PL/SQL exceptions are of two types: internal and _________.
simple
TIMESTAMP.
user-defined
...
32. From a block nested inside a procedure P - reference variable V of the outer procedure.
literals
;
p.v
statement
33. In the special IF syntax - is it ELSIF - or ELSEIF?
elsif
IR
not the same
not a number
34. Cursors: The FOR UPDATE phrase goes at the (beginning/end) of the cursor definition.
end
RETURN
a cursor
INTO
35. TCL: Create a savepoint called ab
varray
savepoint ab
/*
Reserved words.
36. The AUTHID property applies to PL/SQL objects that contain _____.
code
invoker's
query
executable
37. Triggers: By default - a trigger is created in the ______ state.
enabled
'
drop procedure
BINARY_INTEGER
38. The SET TRANSACTION statement affects only the ____________.
virtual machine
never
current transaction
cached
39. A GOTO cannot branch into an...
associative arrays
include
API
IF - CASE or LOOP
40. Cursors: Give the statement to fetch data from cursor variable CV into MyVar.
definition
r t.%ROWTYPE;
fetch cv into myvar
scalar
41. A collection is an ordered group of ________ - all of the same ____
NESTED TABLE myColl STORE AS myCollTab
elements - type
source code
Wrap
42. DynSQL: Maximum string length to pass to EXECUTE IMMEDIATE.
1 million
integrated
end
32 -000
43. Keyword for doing assignment to a variable with SELECT.
package
INTO
IS
block
44. Exceptions: When an exception is raised inside a cursor FOR loop - the cursor is _______ implicitly.
closed
literals
anonymous
base
45. Exceptions: The built-in procedure for raising an application-defined error.
exception
raise_application_error
cannot
index
46. Cursors: If an exception is raised inside a cursor loop - the cursor (is / is not) also closed automatically.
suspended
5
ADT
is
47. An $ERROR directive ends with _____.
-
Server Pages
PSP
$END
48. Fundamental: One of the 4 types of lexical units: i_____
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
CHARARR
identifiers
INTO
49. The two kinds of CASE statements are simple and ________.
v1 OUT number default 10
searched
query
lower sub-block
50. Assignment of PLSQL_CCFLAGS (cannot / can) be included in ALTER PROCEDURE ... COMPILE ...
preprocessor
can
fetch C into V
source