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. Types: In addition to the SQL data types - PL/SQL has ___ more scalar data types.
colon
4
HTF
must
2. Dbms_sql: The integer returned by OPEN_CURSOR is a _____ _____.
versions
cursor number
scalar
aliases
3. Exceptions: When an exception is raised inside a cursor FOR loop - the cursor is _______ implicitly.
IN
closed
is certain
:=
4. Type: A __________ subtype has only a subset of the values of its base type.
LOOP
-20 -000
constrained
PRAGMA EXCEPTION_INIT (E - -1);
5. The EXCEPTION section is (optional/mandatory).
optional
SQL
IR
package
6. Kind of datatypes that support object-oriented programming in PL/SQL.
SYS_CONTEXT
Abstract
identifiers
VARCHAR2
7. A unit with AUTHID = CURRENT_USER is an ________ rights unit.
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
8. The source for wrapping begins with the word ______.
same
for each row
HTF
create
9. Cursors: What is the 'name' of the implicit cursor?
context
Double quotes.
1
SQL
10. Fundamental: Which one of these is a compound symbol: = - :=
increment
:=
associative arrays
plb
11. Conditional ______ allows backward compability with older database versions.
decimal
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
ex := tbl1 MULTISET EXCEPT tbl2
compilation
12. Exceptions: The ________ function returns the error message associated with an error code.
...
SQLERRM
STANDARD
%FOUND - %ISOPEN - %NOTFOUND - %ROWCOUNT
13. The variable showing the user id that is automatically prepended to object names.
USING
manageable
SQL
CURRENT_USER
14. You can define PL/SQL collections using TYPEs defined in the _______.
database
1
concatenation
anonymous block
15. Triggers: If two or more triggers are defined with the same timing point - then you can control the firing order using the ________ clause.
RETURN
not a number
follows
$END
16. Packaged constants can synchronize programs through use in _______ directives.
execute immediate
...
system global area
selection
17. The BEGIN section is (optional/mandatory)
integer
mandatory
-20 -000
finishes
18. Value of a character literal with zero characters.
FETCH - BULK COLLECT INTO
1
order
19. The RESULT_CACHE clause comes (before / after) the RETURN clause.
SQL
after
fine-grained auditing
session cursor
20. Characters that end a multi-line comment.
cannot
for update of
*/
SQL
21. Delimiters: The component indicator/selector.
select
3
.
boolean
22. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
composite
FETCH
implicit
invalid
23. Exceptions: The _________ package defines the PL/SQL environment.
comments
executable
TYPE tN IS TABLE of NUMBER
STANDARD
24. Exceptions: The ________ handler must always be the last handler.
null string
SQL
OTHERS
IR
25. The command used to populate PLSQL_CCFLAGS.
ALTER SESSION
PLSQL_CCFLAGS
v3 IN OUT NUMBER
same arguments
26. The collection method that tells the number of elements in the collection.
SQLCODE
anonymous
HTP
COUNT
27. Triggers: You create a trigger with the _______ ________ statement.
session cursor
<<>>
PUT_LINE
CREATE TRIGGER
28. The declaration section is (optional/mandatory).
database
optional
LOOP
SQLERRM
29. A record is a group of related data items stored in fields - each with its own...
4
native dynamic
name and datatype
compiles
30. With an sparse - integer-indexed associative array - you (can / cannot) use a regular FOR loop.
Web Toolkit
NDS
simple and compound symbols
cannot
31. DBMS_DDL.WRAP returns a string containing wrapped _____ _____.
collections - records
inclusive
source code
SQL
32. I/O: SQLPlus command for turning on buffered output.
varray
set serveroutput on
same
before insert or update on emps
33. Cursors: If no SELECT or DML statement has run - the value of SQL%ROWCOUNT is what?
type T is ref cursor
GET_LINES
cached
34. One good use of bind variables is to guard against SQL _______.
cursor c;
injection
simple
inquiry
35. Kind of comment not to put in a PL/SQL block to be processed dynamically by an Oracle Precompiler program.
current BEGIN-END block
RETURN
...
single-line
36. In a record - the internal components are called ______.
single-line
mandatory
CHARARR
fields
37. If an initialized collection has no elements - FIRST and LAST return _____.
wrap
code
=>
38. SIMPLE_INTEGER is like PLS_INTEGER - but it does not allow ____ values - and it does not raise overflow exceptions.
1
RELIES_ON
sql
39. IDs: The type of words that cannot be user-defined identifiers.
end
oname
Reserved words.
transaction
40. I/O: This package lets two or more sessions in the same instance communicate.
rollback to ab
True
DBMS_PIPE
implicit CASE_NOT_FOUND exception
41. What are the two sequence pseudo-columns?
*/
INSTEAD OF
currval and nextval
aggregate - analytical
42. An editioning view can only select a subset of the columns from the base table and provide ________ for them
associative
aliases
EXIT
END
43. Advantage: Performance: Stored subprograms are ______ in memory.
open cv for
cached
fetch C into V
a cursor
44. A basic PL/SQL datatype that SQL does not have.
bind
ROLLBACK
boolean
execute
45. For a collection - the NEXT method returns ____ when there is no next index value.
a number := 10
compiles
CREATE TRIGGER
46. When a session starts - CURRENT_SCHEMA has the value of the schema owned by ___________.
fetch C into V
SESSION_USER
fine-grained auditing
boolean
47. Exceptions: The keyword that begins an exception handler.
WHEN
STANDARD
Gateway
SESSION_USER
48. Exceptions: The maximum length of an Oracle error message is ____ characters
512
executable
@
PLS_INTEGER
49. A PL/SQL block that is not stored.
-
rollback to ab
INSTEAD OF
anonymous block
50. Types: Which type of arithmetic does NUMBER use - library or hardware?
an autonomous routine
closed
library
associative