Examine the details of the uncompressed, non-partitioned heap table CITIES.
Name Null? Type
CITYID NOT NULL NUMBER(4)
CITY_NAME VARACHAR2(50)
Examine the command:
SQL> ALTER TABLE cities SHRINK SPACE COMPACT;
What must you do before executing it? (Choose the best answer)
A.
Ensure free space that is approximately equal to the space used by the table should be available.
B.
Ensure there are no pending transactions on the table.
C.
Enable row movement is enabled.
D.
Disable all indexes on the table.
These are new exam questions since Oracle changed their syllabus after April 15, 2017. These are 41 questions and they all came into my exam but my answers were wrong that’s why I failed :(. Guys, please help here to get the correct answers.
so now on the exam there are only questions from 1z0-062 (v.2) and 1z0-062 (v.3) ? Only these two, anything else ? 😉
ps. will have a look at questions after the weekend and send answers 😉
C. Enable row movement is enabled.
C
Cleared today almost all these questions were on it