READ Free Dumps For Oracle- 1z0-050
Question ID 1774 | 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.) |
Option A | A. Use Data Pump to transfer the existing data to a new encrypted tablespace. |
Option B | B. Use ALTER TABLE..MOVE to transfer the existing data to a new encrypted tablespace. |
Option C | C. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace. |
Option D | D. Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespace. |
Option E | E. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted. |
Correct Answer | A,B,C |
Question ID 1775 | Evaluate the following block of code |
Option A | A. It produces an error because a fully qualified host name needs to be specified. |
Option B | B. It produces an error because the range of ports associated with the hosts has not been specified. |
Option C | C. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges |
Option D | D. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege. |
Correct Answer | C |