A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition?()
A. It remains valid.
B. It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.
C. It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.
D. It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.
An administrator can create logical volumes and then add file systems to them, or create the file system directly. What is an dvantage of the two-step approach instead of the one-step approach()
A. The number of bytes per inode can be specified.
B. Placement of the filesystem on the disk can be specified.
C. The jfslog can be specified on creation of the filesystem.
D. Either a JFS or JFS2 filesystem can be created on the logical volume.