This is not the document you are looking for? Use the search form below to find more!

Report

# BeITCertified Oracle Free Download Actual 1z0-147 exam questions dumps as PDF

Document Description
File Details
Submitter
• Name: jhon99
Embed Code:

Related Documents

## BeITCertified Computer Associates Free Download Actual 270-131 exam questions dumps as PDF

by: jhon99, 5 pages

BeITCertified Computer Associates Free Download Actual 270-131 exam questions dumps as PDF

## BeITCertified SAS Institute Free Download Actual A00-204 exam questions dumps as PDF

by: jhon99, 4 pages

BeITCertified SAS Institute Free Download Actual A00-204 exam questions dumps as PDF

## BeITCertified H P Free Download Actual HP2-B11 exam questions dumps as PDF

by: prepcram, 4 pages

BeITCertified H P HP2-B11 free questions dumps

## BeITCertified H P Free Download Actual HP2-B22 exam questions dumps as PDF

by: prepcram, 4 pages

BeITCertified H P HP2-B22 free questions dumps

## BeITCertified H P Free Download Actual HP2-B35 exam questions dumps as PDF

by: prepcram, 4 pages

BeITCertified H P HP2-B35 free questions dumps

## BeITCertified H P Free Download Actual HP2-B44 exam questions dumps as PDF

by: prepcram, 3 pages

BeITCertified H P HP2-B44 free questions dumps

## BeITCertified H P Free Download Actual HP2-E13 exam questions dumps as PDF

by: prepcram, 5 pages

BeITCertified H P HP2-E13 free questions dumps

## BeITCertified H P Free Download Actual HP2-E14 exam questions dumps as PDF

by: prepcram, 4 pages

BeITCertified H P HP2-E14 free questions dumps

Content Preview
Oracle 1z0-144: Practice Exam
QUESTION NO: 1

What are the two subtypes of the IF conditional statement in PL/SQL?

A. if-then-endif and if-then-else
B. if-then-else and if-then-elseif
C. if-then-else and if-then-elseif-endif
D. if-then-else and if-then-elseif-then-else

QUESTION NO: 2

What are the two variables supported by PL/SQL?

A. Explicit and implicit variables
B. Scalar and composite variables
C. Primary and default variables
D. Scalar and user-defined variables

QUESTION NO: 3

Oracle supports all of the following types of collections except for which one?

A. VARRAYS
B. Nested array
C. Nested table
D. Associative array
BeITCertified.com

QUESTION NO: 4

Which of the following identifiers can include any printable characters, including spaces?

A. Quoted identifiers
B. Predefined identifiers
C. Valid identifiers
D. Invalid identifiers

"Pass Any Exam. Any Time." - Guaranteed
2

Oracle 1z0-144: Practice Exam

QUESTION NO: 5

Which of the following types of message output contains a chronological log of errors, initialization
parameter settings, and administration operations, and also records values for overwritten control
file records?

A. RMAN messages
C. sbtio.log
D. Oracle trace file

QUESTION NO: 6

Which of the following statements is used to insert, update, or delete bulk data?

A. FOR Loop statement
B. BULK COLLECT INTO statement
C. BULK statement
D. FORALL statement

QUESTION NO: 7

BeITCertified.com
Which of the following exceptions is raised when a user tries to divide a number by zero?

A. VALUE_ERROR
B. OUT_OF_RANGE
C. ZERO_DIVIDE
D. SELF_IS_NULL

QUESTION NO: 8

All of the following can be the causes of raising an exception except for which one?
"Pass Any Exam. Any Time." - Guaranteed
3

Oracle 1z0-144: Practice Exam
A. A throw statement has executed.
B. An asynchronous exception has occurred.
C. An abnormal execution condition has been synchronously detected.
D. A catch statement has executed.

QUESTION NO: 9

Which of the following built-in packages supports dynamic SQL?

A. DBMS_SQL
B. DBMS_SCHEDULER
C. DBMS_MONITOR
D. DBMS_CRYPTO

QUESTION NO: 10

From which of the following programming languages are the features of PL/SQL programming
fetched?

A. C++ programming
B. Java programming
C. C programming

BeITCertified.com

QUESTION NO: 11

Which of the following is ideal for querying a database table or view?

A. Range FOR Loop statement
B. Cursor FOR Loop statement
C. While Loop statement
D. Simple Loop statement

"Pass Any Exam. Any Time." - Guaranteed
4

Oracle 1z0-144: Practice Exam
QUESTION NO: 12

Which of the following errors maps to the INVALID_CURSOR predefined exception in PL/SQL?

A. ORA-10100
B. ORA-10001
C. ORA-01000
D. ORA-01001

QUESTION NO: 13

Which of the following is a sequentially control statement?

A. GOTO
B. LOOP
C. EXIT
D. CASE

QUESTION NO: 14

Which of the following cannot be created and stored in the database?

A. NESTED TABLE
B. VARRAY
C. RECORD
BeITCertified.com
D. ASSOCIATIVE ARRAY

QUESTION NO: 15

In which of the following naming methods are the connect identifiers stored in a localized
configuration file named tnsnames.ora?

A. Oracle Names
B. Directory naming
C. Local naming
D. External naming
"Pass Any Exam. Any Time." - Guaranteed
5

Oracle 1z0-144: Practice Exam
E. Host naming

QUESTION NO: 16

Which of the following correctly represents floating point number literals?

A. F6.34
B. 6.34
C. 6.F34
D. 6.34F

QUESTION NO: 17

Which of the following clauses indicates that a function is cached only once in the SGA and is
available across sessions?

A. PIPELINED
B. PARALLEL_ENABLE
C. RESULT_CACHE
D. DETERMINISTIC

QUESTION NO: 18

BeITCertified.com
Which of the following is another name for bind variable?

A. User-defined variable
B. System variable
C. Session-level variable
D. Default variable

QUESTION NO: 19

"Pass Any Exam. Any Time." - Guaranteed
6

Oracle 1z0-144: Practice Exam
Which of the following exceptions is raised when the value of amount plus the offset exceeds the
maximum size of LOB allowed by the database?

A. Procedure
B. Function
C. Cursor
D. Access

QUESTION NO: 20

Which of the following terms is used for the declaration section of the named-block programs?

A. Wrapper
C. Declarer
D. Cursor

QUESTION NO: 21

All of the following statements about a named system exception are true except for which one?

A. These exceptions are caught by referencing the standard name within an exception-handling
routine.
BeITCertified.com
B. These exceptions are declared explicitly.
C. These exceptions are raised when a predefined Oracle error occurs.
D. NO_DATA_FOUND is an example of a named system exception.

QUESTION NO: 22

All of the following statements are true about an explicit cursor except for which one?

A. An explicit cursor can be declared in any declaration section of a PL/SQL block.
B. A cursor name is not a PL/SQL variable.
C. The name of an explicit cursor can be up to 30 characters in length.
D. Values can be assigned to a cursor.
"Pass Any Exam. Any Time." - Guaranteed
7

Oracle 1z0-144: Practice Exam

QUESTION NO: 23

Which of the following errors is raised when placeholders are put inside the overriding signature of
an INSERT statement?

A. ORA-01006
B. ORA-06502
C. ORA-00928
D. PLS-00049

QUESTION NO: 24

Which of the following is the first step in using a cursor?

A. Open the cursor
B. Fetch from the cursor
C. Define the cursor
D. Close the cursor

QUESTION NO: 25

BeITCertified.com
All of the following statements about the RAISE_APPLICATION_ERROR procedure are true
except for which one?

A. RAISE_APPLICATION_ERROR is used to create a unique id for a user-defined exception.
B. RAISE_APPLICATION_ERROR raises an exception and handles it.
C. RAISE_APPLICATION_ERROR is a built-in procedure in oracle which is used to display the
userdefined error messages along with the error number.
D. Whenever a message is displayed using RAISE_APPLICATION_ERROR, all previous
transactions which are not committed within the PL/SQL block are rolled back automatically.

QUESTION NO: 26
"Pass Any Exam. Any Time." - Guaranteed
8

Oracle 1z0-144: Practice Exam
Which of the following operators allows users to check whether a VARRAY or NESTED TABLE
collection is a subset of a mirrored datatype?

A. SUBMULTISET
B. MEMBER OF
C. EMPTY
D. ISA SET

QUESTION NO: 27

Which of the following correctly represents the default format mask for dates in PL/SQL
programming?

A. DD-MON-YY
B. MON-DD-YY
C. MON-DD-YYYY
D. DD-MON-YYYY

QUESTION NO: 28

What are the two types of CASE statements in PL/SQL?

A. Simple and compound
B. Simple and iterative
C. Direct and indirect
D. Simple and searched BeITCertified.com

QUESTION NO: 29

Which of the following is NOT a part of a PL/SQL exception?

A. A return value
B. A message
C. Type of exception
D. An Error Code
"Pass Any Exam. Any Time." - Guaranteed
9

Oracle 1z0-144: Practice Exam

QUESTION NO: 30

All of the following statements are true about an exception except for which one?

A. The scope of an exception declared within a block is global for the block and local for all of its
sub blocks.
B. The sub-block can refer to the global exception only when the exception name is qualified with
the block label (block_label.exception_name).
C. When a global exception is declared again within a sub-block, the local declaration takes
priority over the global declaration.
D. An exception cannot be declared more than once in a single block.

QUESTION NO: 31

All are lexical units except which of the following?

B. Variables
C. Literals
D. Identifiers
E. Delimiters

BeITCertified.com
QUESTION NO: 32

Which of the following terms is given by developers to PL/SQL 2.x programming?

A. Black Art
B. Gray Art
C. White Art
D. Blue Art

QUESTION NO: 33
"Pass Any Exam. Any Time." - Guaranteed
10

Oracle 1z0-144: Practice Exam
Which of the following PL/SQL built-in functions is used to find the position where a substring
starts in a string?

B. INITCAP
C. INSTR
D. CHR

QUESTION NO: 34

Which of the following functions is used to convert a cursor number to a weakly-typed cursor
variable?

A. DBMS_SQL.TO_OPEN_CURSOR
B. DBMS_SQL.TO_REFCURSOR
C. DBMS_SQL.TO_CURSOR
D. DBMS_SQL.OPEN_CURSOR

QUESTION NO: 35

In which of the following places is the record variable NOT allowed?

BeITCertified.com
A. In the VALUES clause of an INSERT statement.
B. In the INTO subclause of a RETURNING clause.
C. On the right side of the SET clause in an UPDATE statement.
D. In a SELECT list.

QUESTION NO: 36

Which of the following is another name for an unnamed program unit in PL/SQL?

A. Pseudonymous block
B. Eponymous block
C. Exotic block
D. Anonymous block
"Pass Any Exam. Any Time." - Guaranteed
11

Share BeITCertified Oracle Free Download Actual 1z0-147 exam questions dumps as PDF to:

example:

http://myblog.wordpress.com/
or
http://myblog.com/

Share BeITCertified Oracle Free Download Actual 1z0-147 exam questions dumps as PDF as:

From:

To:

Share BeITCertified Oracle Free Download Actual 1z0-147 exam questions dumps as PDF.

Enter two words as shown below. If you cannot read the words, click the refresh icon.

Share BeITCertified Oracle Free Download Actual 1z0-147 exam questions dumps as PDF as:

Copy html code above and paste to your web page.