先試後買

A. Operating System authentication may be used for system-privileged administrative users.

B. Password File authentication is supported for any type of database user.

C. Password authentication must be used for system-privileged administrative users.

D. REMOTE_LOGIN_PASSWORDFILE must be set to EXCLUSIVE to permit password changes for system-privileged administrative users.

E. Password File authentication must be used for system-privileged administrative users.

A. It is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.

B. Sessions may dynamically switch back and forth from DEFERRED to IMMEDIATE segment creation.

C. It is supported for SYS-owned tables contained in locally managed tablespaces.

D. It is the default behavior for tables and indexes.

E. Indexes inherit the DEFERRED or IMMEDIATE segment creation attribute from their parent table.

A. The high-water mark (HWM) of ORDERS is adjusted.

B. The SHRINK operation causes rows to be moved to empty space starting from the beginning of the ORDERS segment.

C. Queries and DML statements are allowed on ORDERS while the SHRINK is executing.

D. The SHRINK operation causes rows to be moved to empty space starting toward the end of the ORDERS segment.

E. Only queries are allowed on ORDERS while SHRINK is executing.

F. Dependent indexes become UNUSABLE.

A. FGA policies can be created by a user having the AUDIT_ADMIN privilege.

B. FGA policies can be created by a user having granted the CREATE_FGA_POLICY role.

C. FGA policies by default can be created by a schema owner on an object in their schema.

D. FGA policies can only be created by a user with SYSDBA privilege.

E. FGA policies can be created by a user having EXECUTE privilege on the DBMS_FGA package.

A. The SYS_GROUP consumer resource group policies define the resources assigned ...

B. The predefined maintenance window starts automatically with 20% of the system resources ...

C. The resources used by the predefined maintenance window can only be adjusted if you create a new resource plan in Resource Manager ...

D. By default, all predefined maintenance windows use the DEFAULT_MAINTENANCE_PLANresource plan, and automated maintenance tasks run under subplan called ORA$AUTOTASK.

A. The /u02 file system must have at least 100G space for the datafile.

B. The operating system must use a 32K block size.

C. DB_32K_CACHE_SIZE must be set to a value that can be accommodated in the SGA.

D. DB_32K_CACHE_SIZE should be set to a value greater than DB_CACHE_SIZE.

E. DB_32K_CACHE_SIZE must be less than DB_CACHE_SIZE.

A. The "TO" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.

B. Compressed objects in sales01.dbf will be uncompressed in sales02.dbf after the move.

C. Tables with one or more extents in this data file may be queried during the execution of this command.

D. It overwrites any existing file with the name sales02.dbf in /u02 by default.

E. DML may be performed on tables with one or more extents in this data file during the execution of this command.

A. Execute DML statements in the HR schema.

B. Revoke the CREATE SESSION privilege from other users.

C. Grant the CREATE SESSION privilege with ADMIN OPTION to other users.

D. Revoke the CREATE SESSION privilege from user HR.

E. Execute DDL statements in the HR schema.

F. Log in to the database instance.

A. Update statements can result in one or more chained rows.

B. Update statements can result in one or more migrated rows.

C. Row pieces of a chained row must always reside in different blocks.

D. A migrated row results in an update to any index on the table to point the row ID in the index to the row's new location.

E. Insert statements can result in a migrated row.

A. Only viewed audit records can be purged from Unified Audits.

B. Only the owner of a Unified Audit Policy can purge audit records by resetting the policy.

C. Use DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL as a privileged user to manually purge audit records.

D. Use DBMS_AUDIT_MGMT.CREATE_PURGE_JOB as a privileged user to schedule an automatic purge job.

E. Use DBMS_AUDIT_MGMT.DELETE_AUDIT_RECORDS('POLICY_NAME') as a privileged user to manually purge audit records of a specified Unified Policy.

F. Use DBMS_AUDIT_MGMT.DELETE_AUDIT_RECORDS('POLICY_NAME') as a privileged user to manually purge audit records of a specified Unified Policy.