READ Free Dumps For Oracle- 1z0-146

Question ID 2773	The database instance was started up with the following initialization parameter values: MEMORY_TARGET = 500M RESULT_CACHE_MODE = FORCE RESULT_CACHE_MAX_SIZE = 0 After the database startup, to enable the result cache, you issued the following command: SQL> ALTER SYSTEM SET result_cache_max_size = 2M SCOPE = MEMORY; Which is the effect of this command?
Option A	A.    The query result cache is enabled and 2 MB of the memory target is allocated to the result cache.
Option B	B.    The query result cache is enabled and 0.25% of the memory target is allocated to the result cache.
Option C	C.    The command produces an error because the database instance is started up with the RESULT_CACHE_MAX_SIZE parameter set to 0.
Option D	D.    The query result cache is not enabled because the database instance is started up with the RESULT_CACHE_MAX_SIZE parameter set to 0.
Correct Answer	D

Explanation

Question ID 2774	Examine the structure of the PRODUCTS table. Name Null? Type PRODUCT_ID NOT NULL NUMBER(6) PRODUCT_NAME VARCHAR2(50) CATEGORY_ID NUMBER(2) SUPPLIER_ID NUMBER(6) LIST_PRICE NUMBER(8,2) View the Exhibit and examine the PL/SQL block. On execution, the PL/SQL block generates the following error: ORA-01001: invalid cursor What could be the reason?
Option A	A.    Both the cursor variable arguments should have been passed in IN mode.
Option B	B.    The contents of one cursor variable cannot be assigned to another cursor variable using the := operator.
Option C	C.    The CLOSE statement closes both the cursor variables, therefore the last FETCH statement cannot execute.
Option D	D.    The name of the cursor variables defined and the name of the cursor variables passed as arguments must be the same.
Correct Answer	C

Explanation

Previous-Page 1 2. . . 18 19 20 21 22 23 24. . . 93 94 Next-Page

Send email to admin@getfreedumps for new dumps request!!!