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. To insert or update on a table that has a collection column - you have to have _______ privilege on the collection type.
associative arrays
server
procedure P AUTHID current_user;
EXECUTE

2. Exceptions: PL/SQL exceptions are of two types: internal and _________.
UTL_FILE
user-defined
an enclosing block
Keywords and predefined names.

3. An editioning view is like an ____ for a table.
autonomous transaction
API
a number := 10
cursor

4. In a cursor loop - the clause added to an INSERT or UPDATE to point at the current record.
dynamic
do not
WHERE CURRENT OF
external subprogram

5. IDs: List the two types of user-defined identifiers.
Ordinary - Quoted.
before insert or update on emps
SYS_CONTEXT
loop

6. In a collection - the internal components are called _______.
source
LOOP
a cursor
elements

7. IDs: You cannot use reserved words as ______ user-defined identifiers.
INTO
ordinary
4K
'

8. I/O: The DBMS_OUTPUT buffer will not be flushed until it is full or until the current PL/SQL block _________.
TYPE tV IS VARRAY(100) OF NUMBER
cursor c RETURN rC;
finishes
do not

9. Abbreviation of definer's rights
DR
=
EXIT WHEN
E Exception;

10. Cursors: You cannot use cursor attributes in _______ statements.
can
SQL
run
manageable

11. One good use of bind variables is to guard against SQL _______.
injection
portable
anonymous
TRUE - FALSE - NULL

12. Advantage: Performance: Storing and runnng procedures on the server minimizes ______ traffic.
IF - CASE or LOOP
IR
30
network

13. Packaged constants can synchronize programs through use in _______ directives.
cannot
invoker's
selection
ex := tbl1 MULTISET EXCEPT tbl2

14. Types of blocks: A pl/sql block that is not stored in the database.
dbms_output.put_line
definition
once
anonymous

15. Cursors: Only a _____ _____ cursor can appear in the CURRENT OF clause of an UPDATE or DELETE statement.
create
not the same
FOR UPDATE
preprocessor

16. Cursors: The value of SQL%ISOPEN is always ______.
current BEGIN-END block
Wrap
FALSE
DBMS_OUTPUT

17. For a collection - the NEXT method gets the next higher (element / index).
index
virtual machine
=
r tRec := tRec(9 - 'Jones');

18. To use a TYPE declared in the database - a PL/SQL block has to have _______ privilege on the type.
select
IS
name-value
a number := 10

19. A national character literal is composed of characters in the ________ character set.
DBMS_CRYPTO
DATE
national
transaction

20. The variable showing the user id that is automatically prepended to object names.
inquiry
CURRENT_USER
cursor
DML

21. Fundamental: What are the 3 compound symbols for 'not equal to'?
<> - != - ^=
transaction
deletions
exception

22. In PL/SQL - what the variables in DML statements are turned into.
associative

bind arguments
names

23. A subprogram defined within another subprogram is a _______ subprogram.
CLOSE
nested
cursor
quoted

24. Cursors: A session cursor that is automatically created and managed by PL/SQL.
fine-grained auditing
specification - body
CLOSE
implicit cursor

25. Cursors: The type definition of a WEAK ref cursor type has no _______ clause.
create
GET_LINE
obfuscates
RETURN

26. Exceptions: An exception in the declarations section does not go to the __________ section.
explicit
WHEN
can
exception

27. Conversion: If the specific value is suitable - ____ or _______ values can convert to almost any datatype
FETCH
TYPE tV IS VARRAY(100) OF NUMBER
quoted
CHAR - VARCHAR2

28. The three sorts of date/time types are DATE - INTERVAL and _________.
after
executable
TIMESTAMP.
manageable

29. Fundamental: Labels furnish targets for GOTO and _____ statements.
statement
EXIT
once
EXECUTE IMMEDIATE

30. Types: Which type of arithmetic does NUMBER use - library or hardware?
ALTER SESSION
LOOP
DBMS_PREPROCESSOR
library

31. Dbms_sql: The return type DBMS_SQL.open_cursor.
static
True
integer
not the same

32. Records are one of the two kinds of PL/SQL _______ data types.
deletions
composite
WHEN
REUSE SETTINGS

33. An anonymous block is a(n) ____ statement.
SQL
oname
2
SQLPlus

34. A basic PL/SQL datatype that SQL does not have.
autonomous triggers
boolean
selection
FETCH

35. Cursors: The three keywords in a full cursor declaration/definition (before the SELECT).
'
SQLPlus
name-value
CURSOR - RETURN - IS

36. Exceptions: Write the call (2 args) to associate message 'Bad' with error code -20 -100.

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

37. Command to create a procedure.
;
compiles
create procedure
close C

38. Cursors: You give an explicit cursor a name and associate it with a _______.
query
nested tables - associative arrays
return value
expression

39. Web: PL/SQL _______ enables a Web browser to invoke a PL/SQL stored subprogram through an HTTP listener.
TYPE tN IS TABLE of NUMBER
FETCH
cannot
Gateway

40. Cursors: Give the statement to fetch data from cursor C into variable V.
error code
Declaration
fetch C into V
CURSOR - RETURN

41. 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

42. Delimiters: Item separator.

nested
NDS
elements - type

43. A SELECT statement with the FOR UPDATE clause puts a ______ on the selected rows.
procedure P AUTHID definer;
FOR - IN
lock
transaction

44. In the special IF syntax - is it ELSIF - or ELSEIF?
FALSE
end
$$
elsif

45. A type of compiler directive - begins with 'e'.
execute immediate
WHERE CURRENT OF
error
single-line

46. Cursors: An implicit cursor is also called a/n ________ ________ -
SQL cursor
DBMS_DDL
API
suspended

47. Cursors: The statement where you pass the parameters to a cursor.
SUBTYPE numb IS number;
same arguments
OPEN
OUT

48. Exceptions: A GOTO statement cannot branch into an _______ ________.
names
OTHERS
exception handler
True - false or NULL.

49. Exceptions: The built-in procedure for raising an application-defined error.
raise_application_error
UTL_SMTP
END IF
cursor number

50. Cursors: A cursor FOR loop can use an explicit or an _______ cursor.
r t.%ROWTYPE;
anonymous
VARRAY - Nested table
implicit

Can you answer 50 questions in 15 minutes?

Major Subjects
Tests & Exams AP CLEP DSST GRE SAT GMAT	Certifications CISSP go to https://www.isc2.org/ PMP ITIL RHCE MCTS More...	IT Skills Android Programming Data Modeling Objective C Programming Basic Python Programming Adobe Illustrator More...	Business Skills Advertising Techniques Business Accounting Basics Business Strategy Human Resource Management Marketing Basics More...
Soft Skills Body Language People Skills Public Speaking Persuasion Job Hunting And Resumes More...	Vocabulary GRE Vocab SAT Vocab TOEFL Essential Vocab Basic English Words For All Global Words You Should Know Business English More...	Languages AP German Vocab AP Latin Vocab SAT Subject Test: French Italian Survival Norwegian Survival More...	Engineering Audio Engineering Computer Science Engineering Aerospace Engineering Chemical Engineering Structural Engineering More...
Health Sciences Basic Nursing Skills Health Science Language Fundamentals Veterinary Technology Medical Language Cardiology Clinical Surgery More...	English Grammar Fundamentals Literary And Rhetorical Vocab Elements Of Style Vocab Introduction To English Major Complete Advanced Sentences Literature Homonyms More...	Math Algebra Formulas Basic Arithmetic: Measurements Metric Conversions Geometric Properties Important Math Facts Number Sense Vocab Business Math More...	Other Major Subjects Science Economics History Law Performing-arts Cooking Logic & Reasoning Trivia

Test your basic knowledge |

Oracle PL - SQL

Can you answer 50 questions in 15 minutes?

Let me suggest you:

Browse all subjects

Browse all tests

Most popular tests

Major Subjects

Tests & Exams

Certifications

IT Skills

Business Skills

Soft Skills

Vocabulary

Languages

Engineering

Health Sciences

English

Math

Other Major Subjects

Browse all subjects

Browse all tests

Most popular tests