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. Cursors: Give the first 3 words to open a cursor variable called cv.
CURRENT_USER
open cv for
COUNT
30
2. Advantage: Caching of programs and sharing among users lowers _______ requirements.
$IF
memory
source code
TOO_MANY_ROWS
3. Cursors: Give the statement for getting out of a FETCH loop for cursor CV.
NDS
collections - records
EXIT WHEN cv%NOTFOUND
FETCH
4. A kind of variable used as a placeholder.
DBMS_DDL
cannot
True - false or NULL.
bind
5. Internally - the NUMBER type is stored as ______. Therefore - decimal numbers (such as prices) are stored exactly - with no rounding.
definition
executable
decimal
invoker's
6. Cursors: WHERE _______ ______ makes an UPDATE or DELETE apply to the current row of a cursor.
composite
CURRENT OF
E Exception;
1
7. Mode designation for an input/output parameter.
IN OUT
NEW
boolean
multi-row
8. A nested table has to be initialized using a ________ - named the same as the type.
cached
constructor
expression
invoker's
9. Conversion: Just about everything will implicitly convert to _____ or _________.
FETCH
bytecode
CHAR - VARCHAR2
3
10. Types: A data type family consists of a ______ type and its subtypes.
block
suspended
SIMPLE_INTEGER
base
11. Bytecode is _______ _______ code.
DBMS_SESSION.RESET_PACKAGE
preprocessor
network
virtual machine
12. I/O: The output from DBMS_OUTPUT will display (during/after) program execution.
fetch cv into myvar
after
...
cannot
13. DynSQL: In EXECUTE IMMEDIATE - the statement string can use either placeholders - or string ________.
binding
FALSE
concatenation
invalid
14. Advantage: PL/SQL is PORTABLE to any OS where ________ runs.
constrained
Oracle
pls_integer
elsif
15. The collection method that tells the number of elements in the collection.
1 million
COUNT
FGA
cursor variable
16. What are the two sequence pseudo-columns?
manageable
database
selection
currval and nextval
17. Declare a package procedure P with no arguments - and give it invoker's rights.
True
1
procedure P AUTHID current_user;
nested tables - associative arrays
18. Command to make a no-op (omit semicolon).
<<
lock
is
19. Cursors: Opening keyword of a cursor FETCH loop.
object
can
PSP
LOOP
20. Types: One of the 4 PL/SQL things that have a data type (begins with 'p').
finishes
create
portable
parameter
21. Advantage: Performance: Stored subprograms are ______ in memory.
ADT
null string
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
cached
22. I/O: The DBMS_OUTPUT buffer will not be flushed until it is full or until the current PL/SQL block _________.
value
%ISOPEN.
statically
finishes
23. Kind of comment not to put in a PL/SQL block to be processed dynamically by an Oracle Precompiler program.
bind
executable
single-line
constructor
24. Two types of stored subprograms.
procedure - function
lock
vname CONSTANT VARCHAR2 := 'x';
implicit
25. How many PL/SQL collection types are there?
3
2
DATE
upper - coalesce
26. Types: The only Oracle datetime type that doesn't begin with TIMESTAMP is ________.
DATE
elements
ROLLBACK
nested
27. The FIRST method gets the first (element / index) of a collection.
index
PSP
SQL
cannot
28. What word is in a function header but not in a procedure header?
RETURN
32 -000
an autonomous routine
parameter
29. DynSQL: The main command for Native Dynamic SQL.
EXECUTE IMMEDIATE
can
UTL_FILE
strong
30. Which two collection types are unbounded?
CREATE TRIGGER
user-defined
nested tables - associative arrays
IS
31. Give the statement to make a program autonomous.
loop
# - $ - _
virtual machine
PRAGMA AUTONOMOUS_TRANSACTION;
32. Exceptions: The ________ function returns the error message associated with an error code.
SIMPLE_INTEGER
HTP
autonomous transaction
SQLERRM
33. A unit with AUTHID = DEFINER is a ________ rights unit.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
34. _______ arrays can be sparse or dense - depending on how you fill them.
database
associative
native dynamic
bytecode
35. Dbms_sql: The return type DBMS_SQL.open_cursor.
r t.%ROWTYPE;
same
integrated
integer
36. CREATE TYPE cannot be used for _______ array types.
Wrap
create
-
associative
37. Dbms_sql: The DBMS_SQL procedure that will execute a DDL or DML statement.
specification - body
fields
execute
currval and nextval
38. The _____ utility turns PL/SQL source code into unreadable text.
cursor c RETURN rC;
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
Wrap
...
39. Cursors: Only a _____ _____ cursor can appear in the CURRENT OF clause of an UPDATE or DELETE statement.
can
SQLERRM
Gateway
FOR UPDATE
40. Searchable CASE statement: Each WHEN has its own _______ condition.
predefined
context
boolean
colon
41. Give the first line of the FOR loop with index i going from 1 to 10 in reverse.
FOR i IN REVERSE 1..10 LOOP
# - $ - _
FORALL and BULK COLLECT
static boolean
42. A user-defined TYPE can have...
null string
CHAR - VARCHAR2
an AUTHID property
NUMBER
43. Exceptions: You can pass an ______ ________ to SQLERRM.
5
r t.%ROWTYPE;
source code
error code
44. A record is a group of related data items stored in fields - each with its own...
FOR i IN REVERSE 1..10 - LOOP - NULL; END LOOP;
EXIT
name and datatype
1
45. An INSTEAD OF trigger is used - e.g - when you want to insert into a complex _____.
WHEN
raise_application_error(-20 -100 - 'Bad');
PLSQL_CCFLAGS
view
46. To create a collection type - use the TYPE command in PL/SQL and the ______ _____ command in SQL.
national
'ENABLE:SEVERE' - 'ERROR:06002'
CREATE TYPE
# - $ - _
47. Triggers: You create a trigger with the _______ ________ statement.
index
CREATE TRIGGER
end
savepoint ab
48. Where an external subprogram is stored.
define
in the database
1
elements - type
49. Dbms_sql: This DBMS_SQL function opens a new cursor.
anonymous
TYPE tV IS VARRAY(100) OF NUMBER
OPEN_CURSOR
FETCH - BULK COLLECT INTO
50. Fundamental: What are the 3 compound symbols for 'not equal to'?
<> - != - ^=
WHEN
REF CURSOR
SQL cursor