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. Fundamental: One of the 4 types of lexical units: c_____.
v1 OUT number default 10
cannot
explicit
comments
2. To enable result-caching for a function - use the _____________ clause.
RESULT_CACHE
<<
INSTEAD OF
enclosing
3. Delimiters: The assignment operator.
'
DECLARE - BEGIN - EXCEPTION - END
:=
DBMS_PREPROCESSOR
4. DynSQL: EXECUTE IMMEDIATE can be used for any SQL statement or PL/SQL block - except for ________ queries.
ex := tbl1 MULTISET EXCEPT tbl2
PL/SQL Gateway
array
multi-row
5. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.
optional
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
RECORDS
cursor number
6. Command to create a procedure.
a cursor
DATE '2005-12-25'
SQL
create procedure
7. Unlike the CASE statement - the CASE expression does not have the...
implicit CASE_NOT_FOUND exception
user-defined
CREATE TRIGGER
cursor c;
8. Fundamental: What are the 3 compound symbols for 'not equal to'?
-
With a letter.
<> - != - ^=
$$
9. Cursors: Give the statement to open cursor C.
open C
FOR - IN
v2 IN NUMBER default 20
NESTED TABLE myColl STORE AS myCollTab
10. The meaning of 'FGA'.
selection
fine-grained auditing
SUBTYPE n IS number not null;
Gateway
11. Cursors: The SQL%FOUND attribute has how many possible values?
system global area
array
autonomous transaction
3
12. PLS_INTEGER has its arithmetic implemented in ________ - so it is very fast.
session cursor
hardware
explicit cursor
scalar
13. I/O: If the current (outermost) PL/SQL block ends with an unhandled exception - the output buffer will not be ___________.
flushed
bind
does not
DR
14. Advantage: PL/SQL is tightly _______ with Oracle SQL.
integrated
WHERE CURRENT OF
RECORDS
cursor variable
15. Command used to execute dynamic SQL.
machine
EXECUTE IMMEDIATE
cannot
DBMS_PIPE
16. Cursors: If you use an EXIT statement to exit a cursor FOR loop prematurely - the cursor (is / is not) closed automatically.
REF CURSOR
scalar
DML
is
17. An INSTEAD OF trigger is used - e.g - when you want to insert into a complex _____.
view
cannot
autonomous transaction
<<
18. Cursors: Give the first 3 words to open a cursor variable called cv.
lock
open cv for
INTO
an autonomous routine
19. Into nested table ex - put elements of tbl1 that are not in tbl2.
ex := tbl1 MULTISET EXCEPT tbl2
*/
With a letter.
CURSOR - RETURN - IS
20. An autonomous program runs in its own __________.
transaction
query
INTO
ALTER SESSION
21. Advantage: PL/SQL is PORTABLE to any OS where ________ runs.
invoker's
$IF $THEN $ELSE $END
Oracle
PLSQL_OPTIMIZE_LEVEL
22. Cursors: What is the 'name' of the implicit cursor?
concatenation
SQL
dbms_output.put_line
Apache
23. PLSQL_CCFLAGS hold a comma-separated list of ______ pairs (hyphenated).
scalar
non-editioning views
DBMS_CRYPTO
name-value
24. Cursors: Define a ref cursor type called T.
%
must
TOO_MANY_ROWS
type T is ref cursor
25. Which two collection types are unbounded?
bind arguments
SQL
nested tables - associative arrays
:=
26. Types: One of the scalar data types specific to PL/SQL: b_____.
BOOLEAN
DML
unqualified
IS
27. Triggers: To simulate having triggers on SELECT statements - you can try ___ (3-letter acronym).
3
error code
FGA
for update of
28. Dbms_sql: The DBMS_SQL procedure that will execute a DDL or DML statement.
execute
do not
FETCH - INTO
an enclosing block
29. True encryption is done with package __________.
RELIES_ON
LOOP
EDITION_NAME
DBMS_CRYPTO
30. _________ exceptions can not be trapped with an error handler
null string
transaction
%BULK_ROWCOUNT
Declaration
31. A SELECT statement with the FOR UPDATE clause puts a ______ on the selected rows.
lock
nested tables - associative arrays
SQL
RETURN
32. %ROWTYPE gets the type of a table or _______.
FOR - IN
cursor
define
NESTED TABLE myColl STORE AS myCollTab
33. A type of compiler directive - begins with 'i'.
integer
DEFINER
alter procedure
inquiry
34. A (simple / searched) CASE statement begins with CASE <expression>.
CURSOR - RETURN - IS
PLS_INTEGER
subtype
simple
35. Triggers: By default - a trigger is created in the ______ state.
enabled
identifiers
never
raise_application_error
36. Exceptions: Some internal exceptions have ________ names.
WHEN OTHERS THEN
calls
invalid
predefined
37. In 11g you can directly reference _____________ in PL/SQL.
machine code
sequence pseudo-columns
1
EXECUTE IMMEDIATE
38. Advantage: Having procedures stored and executed on the server makes PL/SQL ________.
scalable
LOOP
single-line
iname
39. Records are one of the two kinds of PL/SQL _______ data types.
composite
pseudocolumn
library
virtual machine
40. _____ arrays cannot be used as the type of an Oracle table column.
calls
savepoint ab
once
associative
41. 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.
v1 OUT number default 10
NESTED TABLE myColl STORE AS myCollTab
;
explicit
42. The Wrap utility (does / does not) encrypt source code.
external subprogram
RESULT_CACHE
does not
STANDARD
43. Triggers: In a per-row trigger - the ____ record shows you the changed state of an affected row.
index
LOOP - END LOOP
ALTER SESSION
NEW
44. Delimiters: The association operator.
=>
cannot
RELIES_ON
BINARY_INTEGER
45. 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
46. 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
47. IDs: What a quoted user-defined identifier is enclosed in.
With a letter.
%
PSP
Double quotes.
48. To run a PIPE ROW statement in your autonomous routine - you must close any _____________.
RECORDS
RETURN
autonomous transaction
do not
49. Pkgs: The _______ package gives access to such SQL things as ALTER SESSION.
error code
cursor
IR
DBMS_SESSION
50. Command to delete a procedure.
IN
before insert or update on emps
buffer
drop procedure