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. Are good for logging table DML operations.
PLSQL_OPTIMIZE_LEVEL
INTO
pls_integer
autonomous triggers
2. Cursors: Only a _____ _____ cursor can appear in the CURRENT OF clause of an UPDATE or DELETE statement.
SQL cursor
VARCHAR2
FOR UPDATE
# - $ - _
3. Triggers: You create a trigger with the _______ ________ statement.
CREATE TRIGGER
significant
'
explicit cursor
4. Types: One of the scalar data types specific to PL/SQL: B_______
network
%ISOPEN.
BINARY_INTEGER
finishes
5. DynSQL: The three modes of arguments in the USING clause of EXECUTE IMMEDIATE.
explicit
statically
IN - OUT - IN OUT
error code
6. Web: PL/SQL _______ enables a Web browser to invoke a PL/SQL stored subprogram through an HTTP listener.
SIMPLE_INTEGER
flushed
never
Gateway
7. I/O: One of the 3 types of data stored in the DBMS_OUTPUT buffer.
1 million
query
error code
DATE
8. List the transaction control statements.
bind
COMMIT - ROLLBACK - SAVEPOINT - SET TRANSACTION
rollback to ab
1
9. Exceptions: The _________ package defines the PL/SQL environment.
STANDARD
ENABLE
CURRENT OF
UTL_SMTP
10. A type of compiler directive - begins with 's'.
FGA
name
selection
..
11. A SELECT statement with the FOR UPDATE clause puts a ______ on the selected rows.
collections - records
explicit
lock
EXECUTE IMMEDIATE
12. The exception raised when a SELECT INTO statement returns more than one row.
RELIES_ON
predefined
TOO_MANY_ROWS
EXCEPTION_INIT
13. The RESULT_CACHE clause comes (before / after) the RETURN clause.
explicit
after
VARRAY - Nested table
FGA
14. Data dictionary view giving the AUTHID values on a user's objects.
USER_PROCEDURES
Gateway
:=
do not
15. I/O: To make sure the DBMS_OUTPUT buffer will be flushed - put a WHEN ______ clause in the EXCEPTION section of your outer block.
select
OTHERS
production
elements
16. Give the value list in the PLSQL_WARNINGS parameter to turn on SEVERE compiler warnings and make compiler warning 06002 be an error.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
17. I/O: The DBMS_OUTPUT procedure that sets the size of the output buffer.
1
.
unhandled
ENABLE
18. To insert or update on a table that has a collection column - you have to have _______ privilege on the collection type.
name
an AUTHID property
EXECUTE
USER_PLSQL_OBJECT_SETTINGS
19. I/O: The buffered output of dbms_output.put_line is retrieved by _______.
searched
SQLPlus
E Exception;
CURSOR - RETURN
20. Cursors: An explicit cursor (can/cannot) accept parameters.
OUT
can
raise_application_error
SQLCODE
21. Cursors: The SQL%FOUND attribute has how many possible values?
non-editioning views
COUNT
3
EXTEND
22. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.
follows
comments
SIMPLE_INTEGER
DECLARE - BEGIN - EXCEPTION - END
23. Java - C or other program called directly in PL/SQL.
FETCH
a number := 10
external subprogram
v1 OUT number default 10
24. DynSQL: EXECUTE IMMEDIATE can be used for any SQL statement or PL/SQL block - except for ________ queries.
=
label
multi-row
ROLLBACK
25. Conversion: It is best to use (implicit / explicit) conversion.
elements - type
explicit
nested tables - associative arrays
Reserved words.
26. Triggers: The clause to make a trigger run before inserting or updating table EMPS.
lowest
machine
before insert or update on emps
cursor c RETURN rC;
27. 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
28. Triggers: INSTEAD OF triggers only run on ______ views.
BINARY_INTEGER
user-defined
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
non-editioning views
29. This is a CASE (expression / statement): CASE num WHEN 1 THEN goto LABEL1 WHEN 2 THEN var := 2 END CASE;
statement
PUT
propagates
searched
30. Cursors: The index variable in a cursor FOR loop (does/does not) need to be declared.
does not
aliases
sql
constant
31. In the IF syntax - is if ENDIF or END IF?
END IF
cannot
HTP
associative
32. Cursors: An implicit cursor is also called a/n ________ ________ -
define
SQL cursor
not the same
implicit
33. FOR-Looping over a collection from FIRST to LAST only works if the collection is _______.
DBMS_DDL
Server Pages
dense
4K
34. Nested tables are multisets - meaning that there is no inherent _____ of their elements.
UTL_HTTP
varray
DECLARE - BEGIN - EXCEPTION - END
order
35. Cursors: What is the 'name' of the implicit cursor?
hardware
anonymous
SQL
DBMS_SESSION.RESET_PACKAGE
36. Dbms_sql: The DBMS_SQL procedure that will execute a DDL or DML statement.
END IF
scalable
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
execute
37. Triggers and views always have _________ rights.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
38. The default value of the AUTHID property.
DEFINER
definition
%
cursor
39. Exceptions: A GOTO statement cannot branch into an _______ ________.
names
exception handler
procedure - function
value
40. Declare an output NUMBER parameter - v1 - that defaults to 10.
cannot
variable
v1 OUT number default 10
1 million
41. Delimiters: The left label delimiter.
<<
delimiters
an AUTHID property
SQL
42. Types: One of the scalar data types specific to PL/SQL: b_____.
PRAGMA AUTONOMOUS_TRANSACTION;
BOOLEAN
can
%
43. With static typing - type checking is done at ______ time.
compile
STANDARD
static boolean
will not
44. Bulk: The implicit cursor attribute that gives the number of rows affected by each DML statement in a FORALL statement.
is
invoker's
boolean
%BULK_ROWCOUNT
45. The FOR UPDATE OF clause references a (table / column).
PLS_INTEGER
column
information that changes infrequently
buffer
46. When a session starts - CURRENT_SCHEMA has the value of the schema owned by ___________.
SESSION_USER
RECORDS
FORALL i IN MyList.FIRST..MyList.LAST
compilation
47. Cursors: The first two keywords in a Cursor FOR loop.
an enclosing block
value
implicit CASE_NOT_FOUND exception
FOR - IN
48. How many types of compiler directives are there?
%BULK_ROWCOUNT
after insert on emps
3
$IF
49. Define a collection type - tV - which is a varray of 100 NUMBERs.
DML
INTO
TYPE tV IS VARRAY(100) OF NUMBER
INTO
50. With conditional compilation you can avoid compiling debug code in the _______ environment.
EXIT WHEN cv%NOTFOUND
v3 IN OUT NUMBER
anonymous
production