최신Oracle Database 23ai Administration Associate - 1Z0-182무료샘플문제

A. A user's session may be suspended even if the user has the UNLIMITED TABLESPACE system privilege.

B. All sessions must have the same timeout value when waiting for resumable space allocations.

C. Resumable space allocation may be enabled for some sessions and not others.

D. The AFTER SUSPEND event trigger can itself be suspended due to space conditions.

E. A user's session may be suspended and resumed multiple times.

F. Resumable space allocation is only possible with locally managed tablespaces.

A. Oracle Database Metrics are part of Oracle Enterprise Manager Cloud Control's Notification system used to email alerts.

B. Oracle Database Metrics are a set of statistics built in Oracle Enterprise Manager Cloud Control and used for automation.

C. Oracle Database Metrics are a set of measured statistics per unit of time (per second), transaction, or sessions that are used to evaluate performance.

D. Oracle Database Metrics monitor performance using thresholds to generate alerts.

E. Oracle Database Metrics are part of the Oracle Database Notification system to email information about major database events.

A. The maximum number of sessions permitted for a user before the password must be changed.

B. The ability to prevent a password from ever being reused.

C. The number of days for which an account may be inactive before it is locked.

D. The number of days for which an account may be logged in to one or more sessions before it is locked.

E. The maximum amount of CPU time allowed for a user's sessions before their account is locked.

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

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

C. DB_32K_CACHE_SIZE must be less than DB_CACHE_SIZE.

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

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

A. The PDB archive file must be copied to the target CDB.

B. PDB archive file and only the user-defined tablespaces must be copied to the target CDB.

C. The PDB manifest and all the datafiles must be copied to the target CDB.

D. The PDB manifest, the data files, and the PDB archive file must be copied to the target CDB.

A. To shrink a table it must have a PRIMARY KEY constraint.

B. It is not possible to shrink either indexes or Index Organized Tables (IOTs).

C. To shrink a table it must have a UNIQUE KEY constraint.

D. To shrink a table it must have row movement enabled.

E. It must be in a tablespace that uses Automatic Segment Space Management (ASSM).

A. The first block with enough free space to accommodate a row being inserted will always be used for that row.

B. PCTFREE defaults to 10% for all blocks in all segments for all compression methods.

C. ASSM assigns blocks to one of the four fullness categories based on what percentage of the block is allocated for rows.

D. Insert operations always insert new rows into blocks with free space appropriate to the length of the row being inserted.

E. Update operations always relocate rows into blocks with free space appropriate to the length of the row being updated.

A. Undo segments can extend when a transaction fills the last extent of the undo segment.

B. Undo segments can wrap around to the first extent when a transaction fills the last extent of the undo segment.

C. A single transaction may use multiple undo segments simultaneously.

D. Undo segments can be stored in the SYSAUX tablespace.

E. Undo segments can be stored in the SYSTEM tablespace.

A. Automatic data file extension (AUTOEXTEND).

B. Online table segment shrink.

C. Online index segment shrink.

D. Oracle Managed Files (OMF).

E. Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR).

A. It must resolve to a valid connect descriptor in the server's tnsnames.ora file.

B. It must be the name of the database to whose instance HR wishes to connect.

C. It must be the name of the server running the database to whose instance HR wishes to connect.

D. It must be the value of the SERVICE_NAMES parameter on the client side.

E. It must resolve to a valid connect descriptor in the client's tnsnames.ora file.