File Info
| Exam | Oracle Database 11g: Program with PL/SQL |
| Number | 1z0-144 |
| File Name | Oracle.1z0-144.PracticeTest.2018-08-07.62q.tqb |
| Size | 3 MB |
| Posted | Aug 07, 2018 |
| Download | Oracle.1z0-144.PracticeTest.2018-08-07.62q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
The STRING_TAB table has the following structure:
View the Exhibit and examine the code.
What is the outcome on execution?
- It displaysOutput buffer not long enough.This is my test string.-.
- It displays onlyOutput buffer not long enough, and exits the anonymous block.
- It displays onlyThis is my test string. - Because EXCEPTION should have been defined in the anonymous block to get the error message.
- It does not display any of the DBMS_OUTPUT messages and gives an error because a transaction control statement cannot be used in the exception section of a procedure.
Correct answer: C
Question 2
Identify two situations where the DBMS_SQL package should be used. (Choose two.)
- The SELECT list is not known until run time.
- The dynamic SQL statement retrieves rows into records.
- You do not know how many columns a select statement will return, or what their data types will.
- You must use the % found SQL cursor attribute after issuing a dynamic SQL statement that is an insert or update statement.
Correct answer: AC
Question 3
View the Exhibit and examine the code.
Why does the code give an error on execution?
- because the WORD_LIST variable is not visible in procedure wording
- because the lexicon variable is not visible in procedure ADD_ENTRY
- because the lexicon variable is not initialized in procedure wording
- because the WORD_LIST parameter in out mode cannot be of a record data type
Correct answer: A
