Oracle 認証 専門家――OCP，Oracle会社が国際試験認証センターに認証資格権限を授けるのです。受験生は試験の標準によっていくつかの課程の試験（普通は3―5です）に参加することを求めて、試験が全部通した後、OCPの専門家の認証を獲得することができます
1Z0-050問題集
4.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.
Correct:B
5.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.
Correct:A B C
6.Evaluate the following block of code: BEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL ( acl
=> 'mycompany-com-permissions.xml', principal => 'ACCT_MGR', 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?
A.It produces an error because a fully qualified host name needs to be specified.
B.It produces an error because the range of ports associated with the hosts has not been specified.
C.It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and
RESOLVE privileges.
D.It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but
not the RESOLVE privilege.
Correct:C