READ Free Dumps For Oracle- 1z0-050
| Question ID 5925 | 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 | Use Data Pump to transfer the existing data to a new encrypted tablespace. |
| Option B | Use ALTER TABLE..MOVE to transfer the existing data to a new encrypted tablespace. |
| Option C | Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace. |
| Option D | Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespace. |
| Option 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 5926 | Evaluate the following block of code BEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL( acl => lmycompany-com-permissions.xmll1 principal => 'ACCTJvlGR1, is_grant => TRUE, privilege => 'connect'); DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL( acl => 'mycompany-com-permissions.xml', host => ".mycompany.com'); END; What is the outcome of the above code? |
| Option A | t produces an error because a fully qualified host name needs to be specified. |
| Option B | It produces an error because the range of ports associated with the hosts has not been specified. |
| Option C | It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges |
| Option 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 |