Oracle Database 23ai Administration Associate - 1Z1-182 Exam Questions

A. To monitor suspicious activity. B. To monitor proper usage of the system and data by privileged users. C. To protect against data theft by a non-authorized user. D. To alert DBAs about system issues. E. To protect against data corruption.

A. The STATUS column in CDB_PDBS of the unplugged PDB will be REMOVED. B. The STATUS column in CDB_PDBS of the unplugged PDB will be UNAVAILABLE. C. The STATUS column in CDB_PDBS of the unplugged PDB will be UNPLUGGED. D. The STATUS column in CDB_PDBS of the unplugged PDB will be DISABLED.

A. The first block with enough free space to accommodate a row being inserted will always be used for that row. B. Update operations always relocate rows into blocks with free space appropriate to the length of the row being updated. C. ASSM assigns blocks to one of the four fullness categories based on what percentage of the block is allocated for rows. D. PCTFREE defaults to 10% for all blocks in all segments for all compression methods. E. Insert operations always insert new rows into blocks with free space appropriate to the length of the row being inserted.

A. Two RAC databases can share their instances. B. A RAC database can have instances on separate servers. C. A RAC database can have one instance. D. A RAC database must have three or more instances. E. A RAC database must have two or more instances.

A. UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO. B. UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unconsumed UNDO. C. Active UNDO is always retained. D. Unexpired UNDO is always retained. E. UNDO_RETENTION specifies how long all types of UNDO are retained.

A. A database link can be created only between two Oracle databases. B. A public database link can be used by any user allowing remote database instance connection for selecting schema data. C. A public database link can be created only by SYS. D. A database link created in a database allows a connection from that database's instance to the target database's instance for selecting schema data. E. Private database link creation requires the same user to exist in both the local and the remote databases.

A. It allows a user to have unlimited space in any tablespace in the database. B. By default, users have no quota on their default permanent tablespace. C. It allows a role to have unlimited space in any tablespace in the database. D. It is overridden by a space quota specified for the user. E. It allows a user to have unlimited space only in their default permanent tablespace.

A. The Automatic SQL Plan Management Evolve Advisor task, which evolves plans that have recently been added as the SQL plan baseline for statements. B. The Automatic SQL Access Advisor task, which is used to manage an application SQL load. C. The Automatic Index Advisor task, which is used to create and maintain table indexes based on the DML load and operations. D. The Automatic SQL Tuning Advisor tasks, which would examine the performance of high-load SQL statements and make recommendations for those statements. E. The Automatic SQL Performance Analyzer task, which is used to provide details about impact of database changes to application SQL batch.

A. Automatic Application Tracing used to collect High-Load SQL statements and statistics. B. Automatic capture of statistical information from the SGA and storing it in the AWR using Automatic Database Diagnostic. C. Automatic Diagnostic Collector used to capture and store database errors and hung analysis. D. Automatic Application Tracing used to collect High-Load SQL statements and statistics. E. ADDM, a server-based expert that reviews database performance statistics captured by Snapshots to identify potential problems before system performance degrades noticeably. F. Automatic population of performance views (V$ views) from statistical data stored in AWR repository and using Automatic Database Diagnostic.

A. It must be the name of the server running the database to whose instance HR wishes to connect. B. It must resolve to a valid connect descriptor in the client's tnsnames.ora file. C. It must be the name of 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 server's tnsnames.ora file.