1z1-067 무료 덤프문제 온라인 액세스

Which three statements are true about compression of backup sets?

• A.It works only for locally managed tablespaces.
• B.Unused blocks below the high-water mark are not backed up.
• C.Compressed backups can only be written to media.
• D.Binary compression creates performance overhead during a backup operation.
• E.Compressed backups cannot have section size defined during a backup operation

Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:
1. Create a policy to capture the privileges used by a user for privilege analysis.
2. Generate a report with the data captured for a specified privilege capture.
3. Start analyzing the data captured by the policy.
4. Revoke the unused privileges.
5. Compare the used and unused privileges' lists.
6. Stop analyzing the data.
Identify the correct sequence of steps.

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

Which two statements are true when row-archival management is enabled?

• A.Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.
• B.The row archival visibility session parameter defaults to all rows.
• C.The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.
• D.The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.
• E.The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.

In a database supporting an OLTP workload, tables are frequently updated on both key and non-keycolumns.
Reports are also generated by joining multiple tables.
Which table organization or type would provide the best performance for this hybrid workload?

• A.heap table with a primary key index
• B.global temporary table
• C.external table
• D.index clustered table
• E.hash clustered table

You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as the sys user. You execute the commands:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orcll23;
SQL> CREATE ROLE C##CONNECT;
SQL> GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT; SQL> GRANT C##CONNECT to C##ADMIN CONTAINER=ALL; Which statement is true about the c##connect role?

• A.It is created only in cdb$root and cannot be granted to the c##admin user with the container=all clause.
• B.It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a PDB.
• C.It is granted to the c##admin user only in the CDB.
• D.It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB.