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. For a collection - the NEXT method gets the next higher (element / index).
index
value
LOOP
v1 OUT number default 10
2. A numeric FOR loop cannot _________ by other than 1?
%ROWTYPE
return value
<> - != - ^=
increment
3. The DECLARE keyword is only required in an _______ _______.
function f (n number) return number result_cache relies_on (emps);
anonymous block
EDITION_NAME
open C(p)
4. The _____ utility turns PL/SQL source code into unreadable text.
TYPE tN IS TABLE of NUMBER
associative
Wrap
open cv for
5. A record is a group of related data items stored in fields - each with its own...
parameter
name and datatype
$IF
boolean
6. Cursors: The four cursor attributes - in alphabetical order.
WHERE CURRENT OF
.
virtual machine
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
7. In a FORALL loop - you (can / cannot) use the index variable for purposes other than indexing into the collection.
DML
associative
static boolean
cannot
8. Simple CASE statement checks for different values of a single _________
bind arguments
expression
raise_application_error
WHEN OTHERS THEN
9. Fundamental: What is the range operator?
..
raise_application_error
null string
SYS_CONTEXT
10. Which collection type is bounded?
current
does not
varray
FETCH
11. Triggers: You create a trigger with the _______ ________ statement.
FETCH
CREATE TRIGGER
elsif
set serveroutput on
12. A result-cached function caches its results in the _____ _____ ____ (SGA)
cannot
is certain
system global area
procedure P AUTHID current_user;
13. Value of a character literal with zero characters.
32 -000
invoker's
predefined
14. Fundamental: A label can only go directly before an _______ statement.
executable
definer's
OLD
anonymous
15. DynSQL: The main command for Native Dynamic SQL.
EXECUTE IMMEDIATE
bind
CHARARR
TRUE - FALSE - NULL
16. The first SQL statement in an autonomous routine begins a _______.
transaction
suspended
LOOP - END LOOP
constrained
17. What is the simplest statement for conditionally getting out of simple loop?
anonymous block
ALTER SESSION
EXIT WHEN
...
18. The EXTEND method is not used with ______ _______.
associative arrays
suspended
select
inclusive
19. Types: ______ data types are those storing values with no internal components.
scalar
fields
enabled
IN OUT
20. 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
21. Cursors: The first two keywords in a Cursor FOR loop.
is
lock
placeholders
FOR - IN
22. A PL/SQL block that is not stored.
fail
manageable
anonymous block
associative
23. Are good for logging table DML operations.
.
autonomous triggers
an enclosing block
True
24. I/O: The DBMS_OUTPUT function that writes output WITH a newline character.
static
wrap
PUT_LINE
always
25. Web: PL/SQL ______ ______ (PSPs) let you develop web pages with dynamic content.
EDITION_NAME
after insert on emps
multi-row
Server Pages
26. Give the ANSI Date literal for December 25 - 2005.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
27. The command used to populate PLSQL_CCFLAGS.
view
ALTER SESSION
5
LOOP - END LOOP
28. I/O: One of the 3 types of data that can be passed to the DBMS_OUTPUT buffer.
FETCH
DBMS_DDL
VARCHAR2
currval and nextval
29. Advantage: PL/SQL is PORTABLE to any OS where ________ runs.
lower sub-block
Oracle
SQL
v3 IN OUT NUMBER
30. Cursors: The SQL%BULK_ROWCOUNT attribute is an _________ -
query
definer's
UTL_FILE
array
31. The BETWEEN operator is (inclusive / exclusive).
block
BOOLEAN
32 -000
inclusive
32. Assignment of PLSQL_CCFLAGS (cannot / can) be included in ALTER PROCEDURE ... COMPILE ...
TYPE tN IS TABLE of NUMBER
can
inclusive
STANDARD
33. Type: An ________ subtype has all the values of its base type.
unconstrained
TRUE - FALSE and NULL
memory
statement
34. How many times are a FOR loop's index bounds evaluated?
SYS_REFCURSOR
Ordinary - Quoted.
once
35. IDs: The type of words that cannot be user-defined identifiers.
DML
Reserved words.
comments
parameter
36. Types of blocks: A pl/sql block that is not stored in the database.
anonymous
OLD
fetch C into V
INSTEAD OF
37. Subprograms are stored in __________ form.
executable
v3 IN OUT NUMBER
anonymous
bytecode
38. What is the exception that is implicitly raised in a CASE statement with no ELSE clause?
statically
%TYPE
FALSE
CASE_NOT_FOUND
39. The PL/SQL ________ evaluates compiler directives.
exception handler
same
preprocessor
run
40. Cursors: What implicit cursor attribute gives row counts for a FORALL statement?
is
%BULK_ROWCOUNT
TYPE t IS TABLE OF rPerson INDEX BY PLS_INTEGER;
1
41. Fundamental: Maximum string length of a PL/SQL variable.
statement
lock
32 -000
open C
42. Types: A ______ has the same valid operations as its base type.
increment
an autonomous routine
subtype
=
43. Cursors: A pointer to a cursor is called a ______ _______.
cursor variable
anonymous
SIMPLE_INTEGER
1
44. Fundamental: What are the 3 compound symbols for 'not equal to'?
<> - != - ^=
exception
DEFINER
open C(p)
45. Conversion: Implicit conversion can be (faster / slower) than explicit conversion.
slower
compilation
BINARY_INTEGER
national
46. The RESULT_CACHE clause has to be in both the declaration and in the ______ of the function.
definition
WHERE CURRENT OF
Abstract
FETCH
47. Packaged constants can synchronize programs through use in _______ directives.
3
name
selection
EXIT WHEN
48. Delimiters: The assignment operator.
flushed
:=
SUBTYPE n IS number not null;
cannot
49. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
DBMS_DDL
implicit
Declaration
elements
50. Types: Which type of arithmetic does NUMBER use - library or hardware?
-
library
an enclosing block
anonymous