Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Jan Oracle Official New Released 1z0-144
100% Free Download! 100% Pass Guaranteed!
http://www.Dumps4cert.com/1z0-144.html
Oracle Database 11g: Program with PL/SQL
Question No: 1
Identify two features of obfuscation. (Choose two.)
-
The Import and Export utilities accept wrapped files.
-
SQL#39; Plus cannot process the obfuscated source files.
-
Only the wrap utility can obfuscate multiple programs at a time.
-
Both the DBMS_DDL package and the Wrap utility can obfuscate multiple programs at a time.
-
The source code is visible only through the DBA_SOURCE view and not through the USER_SOURCE or ALL_SOURCE View
Answer: A,C
Question No: 2
Which two statements are true about anonymous blocks and named subprograms? (Choose two)
-
Subprograms are by default executed with definer#39;s rights.
-
The declare section is optional for both anonymous blocks and subprograms.
-
Both anonymous blocks and subprograms execute by default with invoker#39;s rights.
-
The declare section is mandatory for anonymous blocks and optional for subprograms.
Answer: A,B
Question No: 3
Which two statements are true about the instead of triggers? (Choose two.)
-
Delete operations cannot be performed using the instead of triggers.
-
The instead or triggers must be created to add or modify data through any view.
-
The instead of triggers can be written only for views, and the before and after timing options are not valid.
-
The check option for views is not enforced when Insertions or updates to the view are performed by using the instead of trigger.
Answer: B,C
Question No: 4
Which two statements are correct about PL/SQL package components? (Choose two)
-
A package must have both specification and body.
-
A package body can exist without the package specification.
-
A package specification can exist without the package body.
-
When a packaged public variable is called for the first time in a session, the entire package is loaded into memory.
Answer: C,D
Question No: 5
View the Exhibit and examine the structure of the AUDIR_CUST table. Exhibit Missing
CUST_ID and CUST_LIMIT are existing columns in the CUSTOMER table. Examine the following trigger code:
Which statement is true about the above trigger?
-
It gives an error on compilation because it should be a statement-level trigger.
-
It compiles and fires successfully when the credit limit is updated in the customer table.
-
It gives an error on compilation because of the commit command in the trigger code
-
It compiles successfully, but gives an error when the credit limit is updated in the CUSTOMER table because the PRAGMA AUTONOMOUS_TRANSACTION statement should be introduced in the trigger.
Answer: D
Question No: 6
Examine the following block of code:
Which line in the above code would result in errors upon execution?
-
line 5
-
line 8
-
line 2
-
line 7
Answer: B
Question No: 7
View the Exhibit to examine the PL/SQL code.
SERVEROUTPUT is on for the session.
Which statement is true about the execution of the code?
-
The execution fails because of the misplaced else clause.
-
The execution is successful even if there is no employee with EMPLOYEE_ID 115.
-
The execution falls and throws exceptions if no employee with EMPLOYEE_ID us is found.
-
The execution is successful, but it displays an incorrect output if no employee with EMPLOYEE_ID 115 is found.
Answer: C
Question No: 8
View Exhibit1 and examine the structure of the employees table.
View Exhibit2 and examine the code.
What would be the outcome when the code is executed?
-
It executes successfully.
-
It gives an error because the SAL variable is not visible in the increase function.
-
It gives an error because the increase function cannot be called from the
RAISE_SALARY procedure.
-
It gives an error because the increase function and the RAISE_SALARY procedure should be declared at the beginning of the declare section before all the other declarations.
Answer: A
Question No: 9
View the Exhibit and examine the structure of the employees table.
Execute the following block of code:
What is the outcome?
-
It gives an error because group functions cannot be used in anonymous blocks
-
It executes successfully and correctly gives the result of the sum of salaries in department 60.
-
It executes successfully and incorrectly gives the result of the sum of salaries in department 60.
-
It gives an error because the variable name and column name are the same in the where clause of the select statement.
Answer: C
Question No: 10
Which two statements are true about the continue statement? (Choose two.)
-
The PL/SQL block execution terminates immediately.
-
The CONTINUE statement cannot appear outside a loop.
-
The loop completes immediately and control passes to the statement after end loop.
-
The statements after the continue statement in the iteration are executed before terminating the LOOP.
-
The current iteration of the loop completes immediately and control passes to the next iteration of the loop
Answer: B,E
100% Dumps4cert Free Download!
–Download Free Demo:1z0-144 Demo PDF
100% Dumps4cert Free Guaranteed!
–1z0-144 Dumps
Dumps4cert | ExamCollection | Testking | |
---|---|---|---|
Lowest Price Guarantee | Yes | No | No |
Up-to-Dated | Yes | No | No |
Real Questions | Yes | No | No |
Explanation | Yes | No | No |
PDF VCE | Yes | No | No |
Free VCE Simulator | Yes | No | No |
Instant Download | Yes | No | No |
100-105 Dumps VCE PDF
200-105 Dumps VCE PDF
300-101 Dumps VCE PDF
300-115 Dumps VCE PDF
300-135 Dumps VCE PDF
300-320 Dumps VCE PDF
400-101 Dumps VCE PDF
640-911 Dumps VCE PDF
640-916 Dumps VCE PDF
70-410 Dumps VCE PDF
70-411 Dumps VCE PDF
70-412 Dumps VCE PDF
70-413 Dumps VCE PDF
70-414 Dumps VCE PDF
70-417 Dumps VCE PDF
70-461 Dumps VCE PDF
70-462 Dumps VCE PDF
70-463 Dumps VCE PDF
70-464 Dumps VCE PDF
70-465 Dumps VCE PDF
70-480 Dumps VCE PDF
70-483 Dumps VCE PDF
70-486 Dumps VCE PDF
70-487 Dumps VCE PDF
220-901 Dumps VCE PDF
220-902 Dumps VCE PDF
N10-006 Dumps VCE PDF
SY0-401 Dumps VCE PDF