Pass4sure 1Z0-050 Question Answer

Which statement describes the effect of table redefinition on the triggers attached to the table?

A. All triggers on the table remain valid.
B. All triggers on the table are invalidated and are automatically revalidated with the next DML execution on the table.
C. All triggers on the table are invalidated and must be manually recompiled before the next DML execution on the table.
D. Only triggers that are affected by the changes to the structure of the table are invalidated and automatically revalidated with the next DML execution on the table.

Answer: B                                                     

USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methods would you use to achieve this? (Choose all that apply.)

A. Use Data Pump to transfer the existing data to a new encrypted tablespace.
B. Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespace.
C. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace.
D. Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespace.
E. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted.

Answer: A, B, C