Create Next App

Exam contains 75 questions

Page 8 of 13

Question 43 🔥

Examine this query executed as SYS and its output:Which two observations are true based on the output?

Which database solution meets these requirements?

A. The client-side result cache and the server-side result cache are enabled.

Highly voted

B. All distinct query results are cached for the duration of a SYS user session.

Highly voted

C. Repetitive SQL queries and PL/SQL function results are cached and automatically used from the cache across all SYS user sessions.

Highly voted

D. The result cache exists but which SQL queries are cached depends on the value of the RESULT_CACHE_MODE parameter.

Highly voted

E. Repetitive SQL queries executed on permanent non-dictionary objects may have faster response times.

Highly voted

Discussion of the question

Question 44 🔥

Examine this function:Execute the query:SELECT remap_schema FROM dual;Which is the correct output from the query?

Which database solution meets these requirements?

A. CREATE TABLE "EMP" ("EMPNO" NUMBER (4,0), "ENAME" VARCHAR2 (10), "JOB" VARCHAR2 (9), "MGR" NUMBER (4,0), "HIREDATE" DATE, "SAL" NUMBER (7,2) , "COMM" NUMBER (7,2), "DEPTNO" NUMBER (2,0), CONSTRAINT "PK_EMP" PRIMARY KEY ("EMPNO") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2417483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CHACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE, CONSTRAINT "FK_DEPTNO" FOREIGN KEY ("DEPTNO") REFERENCES "DEPT" ("DEPTNO") ENABLE ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE (INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS"

Highly voted

B. CREATE TABLE "EMP" ("EMPNO" NUMBER (4, 0), "ENAME" VARCHAR2 (10), "JOB" VARCHAR2 (9), "MGR" NUMBER (4, 0), "HIREDATE" DATE, "SAL" NUMBER (7, 2), "COMM" NUMBER (7, 2), "DEPTNO" NUMBER (2, 0), CONSTRAINT "PK_EMP" PRIMARY KEY ("EMPNO") USING INDEX ENABLE, CONSTRAINT "FK_DEPTNO" FOREIGN KEY ("DEPTNO") REFERENCES "DEPT" ("DEPTNO") ENABLE)

Highly voted

C. CREATE TABLE "SCOTT". "EMP" ("EMPNO" NUMBER (4, 0), "ENAME" VARCHAR2 (10), "JOB" VARCHAR2 (9), "MGR" NUMBER (4, 0), "HIREDATE" DATE, "SAL" NUMBER (7, 2), "COMM" NUMBER (7, 2), "DEPTNO" NUMBER (2, 0), CONSTRAINT "PK_EMP" PRIMARY KEY ("EMPNO") USING INDEX ENABLE, CONSTRAINT "FK_DEPTNO" FOREIGN KEY ("DEPTNO") REFERENCES "DEPT" ("DEPTNO") ENABLE)

Highly voted

D. CREATE TABLE "EMP" ("EMPNO" NUMBER (4,0), "ENAME" VARCHAR2 (10), "JOB" VARCHAR2 (9), "MGR" NUMBER (4,0), "HIREDATE" DATE, "SAL" NUMBER (7, 2) , "COMM" NUMBER (7, 2), "DEPTNO" NUMBER (2,0), CONSTRAINT "PK_EMP" PRIMARY KEY ("EMPNO") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2417483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CHACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "SYSAUX" ENABLE, CONSTRAINT "FK_DEPTNO" FOREIGN KEY ("DEPTNO") REFERENCES "DEPT" ("DEPTNO") ENABLE ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE (INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

Highly voted

Discussion of the question

Question 45 🔥

Examine this code:The anonymous block fails with:ERROR at line 1:ORA-01403: no data found -ORA-06512: at line 5 -Which two are valid options to prevent this error from occurring?

Which database solution meets these requirements?

A. Line 5 should be replaced with: DBMS_LOB.CREATETEMPORARY (pdatabuf (1), TRUE, DBMS_LOB.CALL);

Highly voted

B. Line 5 should be replaced with: DBMS_LOCREATETEMPORARY (pdatabuf (1), FALSE, DBMS_LOSESSION);

Highly voted

C. Rewrite the block as: DECLARE TYPE databuf_arr IS TABLE OF CLOB INDEX BY BINATY_INTEGER; pdatabuf databuf_arr; PROCEDURE mytemplob (x OUT CLOB) IS BEGIN DBMS_LOB.CREATETEMPORARY (x, TRUE, DBMS_LOB, SESSION); END; BEGIN mytemplob (pdatabuf (1)); END; /

Highly voted

D. pdatabuf (1) := NULL; should be added after line 4.

Highly voted

E. Line 5 should be replaced with:

Highly voted

Discussion of the question

Question 46 🔥

Examine this block of code used to calculate the price increase for all the productivity by 1% and then by 2%.What will be the outcome on execution?

Which database solution meets these requirements?

A. It will give an error because the calculated column in the cursor is not using a column alias in this block.

Highly voted

B. It will go into an endless loop because the loop exist condition is missing.

Highly voted

C. It will display the price increase by 1% only for all the products.

Highly voted

D. It will display the price increase by 1% only for the first product.

Highly voted

E. It will give an error because PDT_REC is not declared.

Highly voted

Discussion of the question

Question 47 🔥

You created a PL/SQL function with the RESULT_CACHE clause, which calculates a percentage of total marks for each student by querying the MARKS table.Under which two circumstances will the cache for this function not be used and the function body be executed instead?

Which database solution meets these requirements?

A. When a user fixes incorrect marks for a student, with an update to the MARKS table, and then executes the function in the same session

Highly voted

B. When the amount of memory allocated for the result cache is increased

Highly voted

C. When the function is executed in a session frequently with the same parameter value

Highly voted

D. When the database administrator disables the result cache during ongoing application patching

Highly voted

E. When the maximum amount of server result cache memory that can be used for a single result is set to 0.

Highly voted

Discussion of the question

Question 48 🔥

Examine these program units:Which two blocks will execute successfully?

Which database solution meets these requirements?

A. BEGIN My_proc; END;

Highly voted

B. BEGIN pkg2.proc3; END;

Highly voted

C. BEGIN pkg2.proc2; END;

Highly voted

D. BEGIN pkg1.proc1a; END;

Highly voted

E. BEGIN pkg1.proc1b;

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