READ Free Dumps For Oracle- 1z0-146

Question ID 2813	Which two statements are true about the migration of BasicFile to the SecureFile format by using the DBMS_REDEFINITION package? (Choose two.)
Option A	A.    It can be performed only on tables with a single LOB column.
Option B	B.    It automatically creates an interim table during the migration process.
Option C	C.    It allows the table that is migrated to be accessed throughout the migration process.
Option D	D.    It requires free space that is at least equal to the space used by the table that is migrated.
Option E	E.    It requires all constraints defined on the original table to be re-created manually after the migration.
Correct Answer	C,D

Explanation

Question ID 2814	Examine the structure of the EMPLOYEES table that exists in your schema. Name Null? Type                  EMPLOYEE_ID NOT NULL NUMBER(6) FIRST_NAME VARCHAR2(20) LAST_NAME NOT NULL VARCHAR2(25) JOB_ID NOT NULL VARCHAR2(10) SALARY NUMBER(8,2) COMMISSION_PCT NUMBER(2,2) DEPARTMENT_ID NUMBER(4) You successfully create a GET_MAX procedure to find the maximum salary in the department of a specified employee. You then code a PL/SQL block to display the maximum salary in the departments of the first five employees in the EMPLOYEES table. View the Exhibit. Examine the procedure and the block of PL/SQL code. What is the outcome of executing the block of PL/SQL code?
Option A	A.    It executes successfully and gives the required output.
Option B	B.    It gives an error because ROWNUM cannot be used in cursor definitions.
Option C	C.    It gives an error because usage of the %ROWCOUNT attribute is not valid.
Option D	D.    It executes successfully, but does not give the required output because the procedure call resets the %ROWCOUNT value.
Correct Answer	A

Explanation

Previous-Page 1 2. . . 38 39 40 41 42 43 44. . . 93 94 Next-Page

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