1Z0-182試験無料問題集「Oracle Database 23ai Administration Associate 認定」

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

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

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

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

E. DB_32K_CACHE_SIZE must be less than DB_CACHE_SIZE.

A. If DB_RECOVERY_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_RECOVERY_FILE_DEST by default.

B. If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.

C. If DB_CREATE_ONLINE_LOG_DEST_1 is specified but DB_CREATE_FILE_DEST is not, new data files and temp files are stored in DB_CREATE_ONLINE_LOG_DEST_1 by default.

D. If only DB_CREATE_FILE_DEST is specified, only data files and temp files are Oracle managed.

E. If DB_CREATE_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, new redo logs and control files are stored in DB_CREATE_FILE_DEST by default.

F. If only DB_CREATE_ONLINE_LOG_DEST_1 is specified, only redo logs and control files are Oracle Managed.

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

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

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

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

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

A. Insert statements can result in a migrated row.

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

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

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

E. 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.

A. Analysis of all privileges used by the SYS user.

B. Analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role.

C. Analysis of privileges that a user has on other schemas' objects.

D. Analysis of privileges granted directly to a role that are then used by a user who has been granted that role.

E. Analysis of privileges that a user has on their own schema objects.

A. Register a new database with an available Enterprise Manager Management server.

B. Enable flashback database for an existing database.

C. Configure incremental backups for a new database.

D. Change the standard block size of an existing database.

E. Configure a nonstandard block size for a new database.

A. PDB1 is reverted to its default properties, which includes automatic opening after a CDB restart.

B. It should be used whenever PDB1 open mode needs to be changed.

C. PDB1 is reverted to its default properties, which includes not to automatically open after a CDB restart.

D. It is unnecessary if the PDB is in the process of being upgraded.

A. When the relocation of a PDB is finished, the source PDB must be dropped.

B. You can drop an application root along with the associated PDBs.

C. You cannot drop a source PDB of a refreshable PDB.

D. You can drop a PDB as long as it is not the PDB seed.

A. Data files are closed normally.

B. Uncommitted transactions are not rolled back by the shutdown.

C. A checkpoint is written.

D. Subsequent instance startup performs instance recovery.

E. Subsequent instance startup performs media recovery.