Oracle Database 23ai Administration Associate - 1Z1-182 Exam Practice Test

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

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

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

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

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

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

B. DB_32K_CACHE_SIZE must be less than DB_CACHE_SIZE.

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

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

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

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

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

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

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

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

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 value of the SERVICE_NAMES parameter on the client side.

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

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

A. It is a file-based repository held outside any database.

B. It can be used for the problem diagnosis of a database when that database's instance is down.

C. The ADR base is specified in the DIAGNOSTIC_DEST database parameter.

D. It is held inside an Oracle database schema.

E. It is only used for Oracle database diagnostic information.

A. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.

B. The file is renamed and stored in the same location.

C. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.

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

E. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.

A. A segment's blocks can be of different sizes.

B. Segments can span multiple tablespaces.

C. A segment might have only one extent.

D. All tablespaces may have one or more data files.

E. A segment's blocks can be of different sizes.

F. A segment can span multiple data files in some tablespaces.

A. The Streams Pool

B. The Large Pool

C. The Java Pool

D. The Shared Pool

A. They support UPDATEs, which transparently updates records in the file system as if they were table rows.

B. They can be queried, transformed, and joined with other tables without having to load the data first.

C. The results of a complex join or aggregating function or both can be unloaded to a file for transportation to other systems.

D. They can be queried while the database is in the MOUNT state like dynamic performance views.

E. They support DELETEs, which transparently deletes records in the file system as if they were table rows.

A. It consists of a single row and single column of VARCHAR2 data type.

B. It can be used to display only constants or pseudo columns.

C. It can display multiple rows but only a single column.

D. It can be accessed only by the SYS user.

E. It can be accessed by any user who has the SELECT privilege in any schema.

F. It can display multiple rows and columns.