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

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

Answer: D


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

Answer: B


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

Answer: B


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
Answer: A


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
B. alert_SID.log
C. sbtio.log
D. Oracle trace file

Answer: B


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

Answer: D


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

Answer: C


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.

Answer: D


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

Answer: A


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
D. Ada programming

Answer: D

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

Answer: B

"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

Answer: D


QUESTION NO: 13

Which of the following is a sequentially control statement?

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

Answer: A


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

Answer: C


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

Answer: C


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

Answer: D


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

Answer: C


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

Answer: C


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

Answer: D


QUESTION NO: 20

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

A. Wrapper
B. Header
C. Declarer
D. Cursor

Answer: B


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.

Answer: B


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
Answer: D


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

Answer: C


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

Answer: C


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.

Answer: B


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

Answer: A


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

Answer: D


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

Answer: D


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
Answer: A


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.

Answer: A


QUESTION NO: 31

All are lexical units except which of the following?

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

Answer: B


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

Answer: A


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?

A. LPAD
B. INITCAP
C. INSTR
D. CHR

Answer: C


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

Answer: B


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.

Answer: D


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

---