Test your basic knowledge |

Oracle PL - SQL

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 BEGIN section is (optional/mandatory)
4
does not
mandatory
does not

2. The FIRST method gets the first (element / index) of a collection.
index
PLSQL_CCFLAGS
cannot
can

3. Cursors: Give the statement to open cursor C that takes parameter p.
open cv for
API
open C(p)
statement

4. Types: One of the scalar data types specific to PL/SQL: P________
function f (n number) return number result_cache relies_on (emps);
PLS_INTEGER
OPEN_CURSOR
END CASE

5. Command to create a procedure.
DBMS_SESSION
create procedure
quoted
EXIT WHEN cv%NOTFOUND

6. What word is in a function header but not in a procedure header?
RECORDS
bytecode
significant
RETURN

7. Web: mod_plsql is an _______ module.
Apache
procedure P AUTHID definer;
source
-

8. Delimiters: Statement terminator.
UTL_FILE
;
cannot
order

9. Define a collection type - tA - which is an associative array of NUMBERS - indexed with varchar2(20) values.
TYPE tA IS TABLE OF NUMBER INDEX BY VARCHAR2(20)
DBMS_SESSION
commit - rollback
L.V

10. To insert or update on a table that has a collection column - you have to have _______ privilege on the collection type.
EXECUTE
OTHERS
Double quotes.
anonymous

11. Web: The gateway that allows a web browser to invoke a PL/SQL procedure through an HTTP listener.
WHEN OTHERS THEN
implicit CASE_NOT_FOUND exception
PL/SQL Gateway
TYPE tN IS TABLE of NUMBER

12. Where an external subprogram is stored.
anonymous block
elements - type
database
in the database

13. The PL/SQL virtual machine turns bytecode into system ______.
RETURN
=>
calls
context

14. DynSQL: In EXECUTE IMMEDIATE - the statement string can use either placeholders - or string ________.
RECORD OF ARRAYS
concatenation
CURRENT_USER
reference

15. I/O: One of the 3 types of data that can be passed to the DBMS_OUTPUT buffer.
decimal
elements - type
VARCHAR2
ordinary

16. To enable result-caching for a function - use the _____________ clause.
SIMPLE_INTEGER
DATE
RESULT_CACHE
same arguments

17. Java - C or other program called directly in PL/SQL.
INSTEAD OF
With a letter.
5
external subprogram

18. Dbms_sql: This DBMS_SQL function opens a new cursor.
before insert or update on emps
EXECUTE IMMEDIATE
3
OPEN_CURSOR

19. The NOCOPY option on an OUT or IN OUT parameter - causes it to be passed by ______.
lock
object
reference
USING

20. Types: A ______ has the same valid operations as its base type.
DBMS_CRYPTO
associative
STANDARD
subtype

21. DynSQL: EXECUTE IMMEDIATE can be used for any SQL statement or PL/SQL block - except for ________ queries.
%BULK_ROWCOUNT
preprocessor
implicit
multi-row

22. Triggers: The clause to make a trigger run before inserting or updating table EMPS.
autonomous transaction
before insert or update on emps
# - $ - _
Oracle

23. Triggers: In a per-row trigger - the ____ record shows you the original state of an affected row.
FORALL i IN MyList.FIRST..MyList.LAST
LOOP
DATE
OLD

24. Web: Abbreviation of PL/SQL Server Page.
PSP
not the same
INSTEAD OF
network

25. Characters that begin a single-line comment.
True - false or NULL.
reference
pls_integer
-

26. Records are one of the two kinds of PL/SQL _______ data types.
is

composite
error code

27. With Edition-based Redefinition enabled - the unique specification of an object requires OWNER - OBJECT_NAME and ___________.
CURRENT_USER
cursor
EDITION_NAME
RECORD OF ARRAYS

28. With a result-cached function - it uses a cached value when the function is called again with the...
same arguments
r t.%ROWTYPE;
transaction
=

29. A PL/SQL block that is not stored.
PUT
run
query
anonymous block

30. DBMS_DDL.WRAP returns a string containing wrapped _____ _____.
source code
national
context
DBMS_SESSION

31. Associative arrays (do / do not) have to be initialized with a constructor.
Keywords and predefined names.
scalar
*/
do not

32. Declare a variable r whose type is that of the records in table t.
r t.%ROWTYPE;
TRUE - FALSE - NULL
nested
constrained

33. Exceptions: Associate exception E with error code -1.
system global area
for each row
follows
PRAGMA EXCEPTION_INIT (E - -1);

34. Data dictionary view giving the AUTHID values on a user's objects.
EXECUTE IMMEDIATE
USER_PROCEDURES
USER_PLSQL_OBJECT_SETTINGS
database

35. Cursors: Which cursor attribute is not meaningful for an implicit cursor?
associative
%ISOPEN.
transaction
PUT_LINE

36. Assigning values to PL/SQL variables that appear in SQL statements is called _______.
SYS_REFCURSOR
binding
iname
associative

37. A collection is an ordered group of ________ - all of the same ____
RECORDS
elements - type
cursor number
hardware

38. The DEFINITION of a cursor is the _____ that returns the records.
query
can
national
DBMS_SQL

39. The $ERROR directive is used to make compilation ____.
fail
vname CONSTANT VARCHAR2 := 'x';
DBMS_PIPE
scalable

40. I/O: This package has hypertext functions that generate HTML tags
autonomous transaction
disable
PVM
HTF

41. The lowest index of a VARRAY is ___.
..
1
optional
COUNT

42. A kind of variable used as a placeholder.
VARRAY - Nested table
cursor
CHARARR
bind

43. The valid values of the AUTHID property.
ex := tbl1 MULTISET EXCEPT tbl2
do not
CURRENT_USER - DEFINER
elements

44. IDs: You cannot use reserved words as ______ user-defined identifiers.
commit - rollback
ordinary
scalable
fields

45. Declare a number variable - A - initialized to 10.
a number := 10
execute
NDS
FGA

46. In a cursor loop - the clause added to an INSERT or UPDATE to point at the current record.
WHERE CURRENT OF
bb:true
DATE
order

47. The BETWEEN operator is (inclusive / exclusive).
predefined
variable
inclusive
literals

48. An incomplete type only has a ____.
TYPE rec IS RECORD (num NUMBER - name VARCHAR2(10));
p.v
subtype
name

49. In the special IF syntax - is it ELSIF - or ELSEIF?
constructor
implicit
elsif
after

50. Fundamental: Character used to escape a single quote inside a literal.

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183