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 PL/SQL preprocessor passes ______ code to the compiler.
=>
END LOOP
source
array
2. Declare a cursor c with no parameters or return type.
lock
cursor c;
cannot
SYS_REFCURSOR
3. Exceptions: An exception raised inside an _______ _______ propagates immediately to the enclosing block
1
exception handler
WHERE CURRENT OF
4
4. Keyword for doing assignment to a variable with SELECT.
INTO
255
Abstract
Apache
5. Exceptions: The keyword that begins an exception handler.
WHEN
does not
unhandled
STANDARD
6. The two main parts of a package are the ____ and the _____.
label
FGA
specification - body
HTP
7. The allowed data types of user-defined conditional compilation directives are boolean and _______.
selection
SUBTYPE n IS number not null;
v3 IN OUT NUMBER
pls_integer
8. Cursors: The FOR UPDATE phrase goes at the (beginning/end) of the cursor definition.
PUT_LINE
PRAGMA EXCEPTION_INIT (E - -1);
FOR i IN REVERSE 1..10 LOOP
end
9. 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
10. To exit an active autonomous transaction without causing an exception - you must issue _____ or ______.
definition
buffer
array
commit - rollback
11. Cursors: Give the statement to open cursor C.
SESSION_USER
CURRENT OF
view
open C
12. The _____ and ____ _____ collection types can be used in database table columns.
bind arguments
EXIT
VARRAY - Nested table
calls
13. Abbreviation of definer's rights
ALTER SESSION
cannot
1 million
DR
14. The 2 characters that begin all inquiry directives.
buffer
CURRENT_USER
for each row
$$
15. Conversion: Implicit conversion can be (faster / slower) than explicit conversion.
cannot
slower
system global area
IS
16. A GOTO cannot branch into an...
r t.%ROWTYPE;
IF - CASE or LOOP
1
EXIT
17. Delimiters: Host variable indicator.
DML
...
oname
binding
18. What is the exception that is implicitly raised in a CASE statement with no ELSE clause?
CASE_NOT_FOUND
cannot
FALSE
open cv for
19. DynSQL: EXECUTE IMMEDIATE does both dynamic SQL and dynamic _______.
$IF $THEN $ELSE $END
END
PL/SQL
decimal
20. Triggers and views always have _________ rights.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
21. Declare a constrained subtype of NUMBER called N that is not null.
SUBTYPE n IS number not null;
decimal
PL/SQL
:=
22. Exceptions: If there is no handler for an exception - PL/SQL returns an ________ exception error to the invoker or host environment.
CHAR - VARCHAR2
unhandled
collections
statement
23. A (simple / searched) CASE statement begins with CASE <expression>.
error code
invalid
simple
USER_PROCEDURES
24. I/O: The PL/SQL I/O packages (can/cannot) accept input directly from the keyboard.
fine-grained auditing
cannot
CASE_NOT_FOUND
UTL_HTTP
25. Web: PL/SQL _______ enables a Web browser to invoke a PL/SQL stored subprogram through an HTTP listener.
INSTEAD OF
executable
Gateway
binding
26. A FOR loop can be indexed by numbers or by a ______.
cursor
'ENABLE:SEVERE' - 'ERROR:06002'
executable
PL/SQL
27. IDs: The 3 non-alphanumeric characters that can be in an ordinary user-defined identifier.
propagates
timing
# - $ - _
dynamic
28. By default - OUT and IN OUT parameters are passed by _____.
national
exit when cgo%NOTFOUND
SESSION_USER
value
29. Types of blocks: A pl/sql block that is not stored in the database.
ADT
anonymous
INTO
open C(p)
30. In short-circuit evaluation - IF-conditions are only evaluated up to where the outcome ___________.
EXIT
is certain
is
Wrap
31. Types: One of the scalar data types specific to PL/SQL: P________
EXIT WHEN
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
VARRAY - Nested table
PLS_INTEGER
32. Delimiters: Statement terminator.
;
error code
RECORDS
is
33. Triggers: By default - a trigger is created in the ______ state.
enabled
TRUE - FALSE - NULL
open C(p)
34. Cursors: WHERE _______ ______ makes an UPDATE or DELETE apply to the current row of a cursor.
value
CURRENT OF
finishes
..
35. Statement to exit a cursor loop on cursor cGo when there are no more records.
EDITION_NAME
simple
exit when cgo%NOTFOUND
statement
36. To use a TYPE declared in the database - a PL/SQL block has to have _______ privilege on the type.
TRUE - FALSE - NULL
execute immediate
select
system global area
37. Triggers: Unlike a stored procedure - you can enable and _____ a trigger.
open C
<<>>
disable
USER_PLSQL_OBJECT_SETTINGS
38. Type: An ________ subtype has all the values of its base type.
transaction
forward
fields
unconstrained
39. Cursors: Give the statement to close cursor C.
SQL
RETURN
close C
package
40. GOTO branches to a ________.
forward
label
Keywords and predefined names.
bb:true
41. Declare a number variable - A - initialized to 10.
<> - != - ^=
inclusive
a number := 10
memory
42. True encryption is done with package __________.
constrained
name-value
3
DBMS_CRYPTO
43. Cursors: If no SELECT or DML statement has run - the value of SQL%ROWCOUNT is what?
DBMS_PIPE
end
CURSOR - RETURN
44. Types: A ______ has the same valid operations as its base type.
raise_application_error
PRAGMA AUTONOMOUS_TRANSACTION;
expression
subtype
45. The command used to populate PLSQL_CCFLAGS.
:=
INTO
collections - records
ALTER SESSION
46. The $IF must evaluate a ______ _______ expression.
DBMS_SQL
REF_CURSOR
virtual machine
static boolean
47. Delimiters: The remote access symbol.
code
@
multi-row
comments
48. CREATE TYPE cannot be used for _______ array types.
STANDARD
vname CONSTANT VARCHAR2 := 'x';
associative
compile
49. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
ROLLBACK
implicit
boolean
Server Pages
50. By default - an IN parameter is passed by ______.
fetch cv into myvar
reference
create procedure
return value