Create Next App

Exam contains 75 questions

Page 10 of 13

Question 55 🔥

You execute this PL/SQL block:What will be the outcome?

Which database solution meets these requirements?

A. It will fail compile because of errors at lines 11 and 12.

Highly voted

B. It will fail compile because of errors at lines 6 and 12.

Highly voted

C. It will fail compile because of error at line 7.

Highly voted

D. It will fail compile and execute successfully.

Highly voted

E. It will fail compile because of errors at lines 5 and 6.

Highly voted

Discussion of the question

Question 56 🔥

Examine the structure of the DEPT table which exists in both BRANCH1 and BRANCH2 schemas:Examine this code:Which three modifications must be done to endure the anonymous block displays the output form the BRANCH2.DEF DEPT table?

Which database solution meets these requirements?

A. Change the IF condition in the anonymous block to 1_dept IS EMPTY.

Highly voted

B. Change the IF condition in the anonymous block to CARDINALITY (1_dept) IS NULL.

Highly voted

C. Add BEQUEATH DEFINER to the EMP_COUNT_VW view.

Highly voted

D. Add BEQUEATH CURRENT_USER to the EMP_COUNTS_VW view.

Highly voted

E. IN BRANCH2 execute GRANT INHERIT PRIVILEGES ON USER branch2 TO branch1;

Highly voted

F. Add AUTHID CURRENT_USER to the EMP_COUNT function.

Highly voted

Discussion of the question

Question 57 🔥

Consider a function totalEmp () which takes a number as an input parameter and returns the total number of employees who have a salary higher than that parameter.Examine this PL/SQL package AS -Which two definitions of totalEmp () result in an implicit conversion by Oracle Database on executing this PL/SQL block?

Which database solution meets these requirements?

A. CREATE FUNCTION totalEmp (sal IN NUMBER) RETURN NUMBER IS total NUMBER :=0; BEGIN RETUNRN total; END; /

Highly voted

B. CREATE FUNCTION totalEmp (sal IN NUMBER) RETURN NUMBER IS total NUMBER :=0; BEGIN RETUNRN total; END; /

Highly voted

C. CREATE FUNCTION totalEmp (sal IN PLS_INTEGER) RETURN NUMBER IS total NUMBER :=0; BEGIN RETUNRN total; END; /

Highly voted

D. CREATE FUNCTION totalEmp (sal IN BINARY_FLOAT) RETURN NUMBER IS total NUMBER :=0; BEGIN RETUNRN total; END; /

Highly voted

E. CREATE FUNCTION totalEmp (sal IN POSITIVEN) RETURN NUMBER IS total NUMBER :=0; BEGIN RETUNRN total; END;

Highly voted

Discussion of the question

Question 58 🔥

Which two statements are true about PL/SQL AOIs for SecureFiles?

Which database solution meets these requirements?

A. DBMS_LOB can be used to compress SecureFiles columns.

Highly voted

B. When using DBMS_DATAPUMP, if SecureFiles LOB data needs to be encrypted then ENCRYPTION=ALL must be specified.

Highly voted

C. If a BasicFiles LOB locator is passed to DBMS_LOB.ISSECUREFILE, an exception will be raised.

Highly voted

D. An online redefinition of SecureFiles by DBMS_REDEFINIITON can be performed with PDML (Parallel DML).

Highly voted

Discussion of the question

Question 59 🔥

Which two can be used to find details of parameters for overloaded PL/SQL routines?

Which database solution meets these requirements?

Discussion of the question

Question 60 🔥

Examine the test_tbl table and its contents:Examine this code:What is the outcome of this anonymous PL/SQL block?

Which database solution meets these requirements?

A. "It was updated" is displayed.

Highly voted

B. Successful completion without printing "It was updated".

Highly voted

C. A NO_DATA_FOUND exception is thrown.

Highly voted

D. ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified

Highly voted

E. ORA-22920: row containing the LOB value is not locked

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_148

Exam contains 75 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us