Create Next App

Exam contains 75 questions

Page 6 of 13

Question 31 🔥

Examine this code executed in the ORA1 schema:Examine this code executed by DBA_USER who has been granted the DBA role:REVOKE INHERIT PRIVILEGES ON USER dba_user FROM PUBLIC;Examine this query:SELECT return_date (1) FROM dual;What is the result of executing this query in the DBA_USER schema?

Which database solution meets these requirements?

C. It will fail with a runtime error complaining of insufficient INHERIT PRIVILEGES.

Highly voted

D. It will execute successfully, return the date and the DBA role will be granted to ORA1.

Highly voted

A. It will fail with a compile-time error.

Highly voted

B. It will execute successfully and return the date but the DBA role will not be granted to ORA1.

Highly voted

Discussion of the question

Question 32 🔥

Which three commands can be used to set PL/SQL conditional compilation inquiry directive MODE?

Which database solution meets these requirements?

A. ALTER SESSION SET PLSQL_CCFLAGS = ‘mode: FALSE’;

Highly voted

B. ALTER SESSION SET PLSQL_CCFLAGS= ‘mode: NULL’;

Highly voted

C. ALTER SESSION SET PLSQL_CCFLAGS= ‘mode: Level 1’;

Highly voted

D. ALTER SESSION SET PLSQL_CCFLAGS= ‘mode: Level1’;

Highly voted

E. ALTER SESSION SET PLSQL_CCFLAGS= ‘mode: 1’

Highly voted

Discussion of the question

Question 33 🔥

Examine this declaration section:Which two executable sections will display the message Summary is null?

Which database solution meets these requirements?

A. BEGIN 1_rec := NULL; 1_emp := emp_typ (1_rec); IF 1_emp (1).expr_summary IS EMPTY THEN DBMS_OUTPUT.PUT_LINE (Summary is null); END IF; END;

Highly voted

B. BEGIN 1_rec.emp_id :=1; 1_rec.expr_summary := NULL; 1_emp :=emp_typ (1_rec); IF 1_emp(1).expr_summary IS NULL THEN DBMS_OUTPUT.PUT_LINE (Summary is null); END IF; END;

Highly voted

C. BEGIN 1_rec.emp_id :=1; 1_rec.expr_summary := EMPTY_CLOB (); 1_emp := emp_typ (1_rec); IF 1_emp(1).expr_summary IS NULL THEN DBMS_OUTPUT.PUT_LINE (Summary is null); END IF END;

Highly voted

D. BEGIN 1_emp := emp_typ (); IF NOT 1_emp. EXISTS (1) THEN DBMS_OUTPUT.PUT_LINE (Summary is null); END IF END;

Highly voted

E. BEGIN 1_emp. EXTEND; IF NOT 1_emp. EXISTS (1) THEN DBMS_OUTPUT.PUT_LINE (Summary is null); END IF

Highly voted

Discussion of the question

Question 34 🔥

Examine this code:Which two corrections must be applied for this anonymous block to execute successfully?

Which database solution meets these requirements?

A. Change RETURN p_tab.LAST to RETURN p_tab.COUNT.

Highly voted

B. Declare the collection type inside the function.

Highly voted

C. Declare the collection type at the schema level instead of the package.

Highly voted

D. Define the function as stand-alone instead of in a package body.

Highly voted

E. Change the INDEX BY clause from VARCHAR2 to PLS_INTEGER.

Highly voted

F. Modify the function return type to return a scalar, VARCHAR2.

Highly voted

Discussion of the question

Question 35 🔥

Examine this code:The anonymous block fails this error stack:Which two changes, when separately applied, would prevent these errors from occurring?

Which database solution meets these requirements?

A. Define v2 as employees%ROWTYPE.

Highly voted

B. Initialize v1 and v2 with appropriate constructor functions.

Highly voted

C. Define v2 as pkg. rec.

Highly voted

D. Nothing because using the function TABLE (V1) is prohibited.

Highly voted

E. Define v1 as employees%ROWTYP

Highly voted

Discussion of the question

Question 36 🔥

The STUDENTS table exists in your schema.Examine the DECLARE section of a PL/SQL block:Which two blocks are valid?

Which database solution meets these requirements?

B. BEGIN OPEN stcur; cursor1 :=stcur; END;

Highly voted

A. BEGIN OPEN cursor3 FOR SELECT * FROM students; cursor1 :=cursor3; END;

Highly voted

C. BEGIN OPEN cursor1 FOR SELECT * FROM students; stcur :=cursor1; END;

Highly voted

D. BEGIN OPEN stcur; cursor3 :=stcur; END;

Highly voted

E. BEGIN OPEN cursor1 FOR SELECT * FROM students; cursor2 :=cursor1;

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