1z1-074 試験問題を無料オンラインアクセス

U1.T1 is in a tablespace TBS_UNCMP which has no default compression and U1.T2 is in a tablespace, TBS_CMP with default compression for query low.
You execute commands:

Which three statements are true? (Choose three.)

• A.T1 is in uncompressed format
• B.T1 is in the TBS_UNCMP tablespace
• C.T1 is in compressed format
• D.All indexes on T1 remain valid
• E.T1 is in the TBS_CMP tablespace
• F.The primary key constraints on T1 are dropped

The ORCL CDB has a PDB, ORCL_PDB.
Examine these parameters in ORCL:

Examine these parameters in ORCL_PDB:

You switch to ORCL_PDB and plan to execute these commands:

What will be the outcome?

• A.Altering the DB_CACHE_SIZE results in an error because SGA_TARGET should be altered to 600M first.
• B.SGA_TARGET is set to 600M.The other values remain unchanged in both ORCL and ORCL_PDB.
• C.SGA_TARGET is set to 600M and DB_CACHE_SIZE to 200M in ORCL_PDThe other values remain unchanged in both ORCL and ORCL_PD
• D.SGA_TARGET and SGA_MAX_SIZE are set to 600M and DB_CACHE_SIZE to 200M in ORCL_PDB.SGA_TARGET and SGA_MAX_SIZE are set to (1360-600)M and DB_CACHE_SIZE to
  200M in ORCL.
• E.Altering the DB_CACHE_SIZE results in an error because it cannot be altered in a PDB.SGA_TARGET size is changed to 600 M.

You create a refreshable copy PDB, PDB_COPY, from the PDB_ORG PDB by using the REFRESH MODE EVERY 5 MINUTES clause.
What happens every five minutes?

• A.An automatic refresh is done provided PDB_COPY is closed; otherwise the refresh is differed and attempted again after five minutes.
• B.An automatic refresh is done provided PDB_COPY is in read-only mode; otherwise the refresh is deferred and attempted again after five minutes.
• C.PDB_COPY'S state is automatically changed to read-only and then reopened as read-write after the refresh is complete.
• D.PDB_COPY is automatically closed provided there is no ongoing transaction in PDB_ORG and then reopened as read-only after the refresh is complete.
• E.PDB_COPY'S state is automatically changed to read-write and back to read-only after the refresh is complete.

You log in to the ORCL database as SYSTEM and successfully execute these two blocks of code:

The SCOTT user has the SELECT privilege on HR.EMP.
Which statement is true about queries by non-DBA users with the SELECT privilege on HR.EMP?

• A.Only SCOTT'S queries display the true contents of the SALARY and LAST_NAME columns.
• B.All their queries display blanks for LAST_NAME and zeroes for SALARY.
• C.All their queries display blanks for LAST_NAME and the true contents of the SALARY column.
• D.Only SCOTT'S queries display zero for SALARY and the true contents of the LAST_NAME column.
• E.Only SCOTT'S queries display the true contents of the SALARY column and blanks for LAST_NAME.

Examine these steps to create a Transparent Sensitive Data Protection (TSDP) policy with unified auditing to protect sensitive data in certain table columns:
* Create a TSDP policy and define the audit parameter for the audited columns.
* Create a TSDP sensitive type using DBMS_TSDP_MANAGE.ADD_SENSITIVE_TYPE.
* Associate the TSDP policy with the sensitive type by using
DBMS_TSDP_PROTECT.ASSOCIATE_POLICY.
* Enable the TSDP policy at the sensitive type level.
* Associate the column to be audited to the sensitive type by using
DBMS_TSDP_MANAGE.ADD_SENSITIVE_COLUMN.
Identify the steps in the correct sequence.

• A.1, 2, 3, 4, 5
• B.2, 1, 4, 5, 3
• C.2, 1, 5, 3, 4
• D.2, 5, 1, 3, 4
• E.1, 2, 4, 3, 5