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

A. READ ONLY B. RESTRICTED WRITE ONLY C. RESTRICTED READ ONLY D. READ WRITE

A. V$TABLESPACE displays information that is contained in the control file about tablespaces. B. A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened. C. Tablespace free space can be viewed in V$TABLESPACE. D. Tablespace free space can be viewed in DBA_TABLESPACES. E. V$TABLESPACE displays information about tablespaces contained in the data dictionary.

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

A. Change the server mode from dedicated to shared, and vice versa. B. Create a template that can be used to clone the database. C. Change the character set. D. Create nonstandard block size tablespaces. E. Create an additional listener.

A. Creating a database. B. Renaming data files. C. Re-creating control files. D. Full database recovery. E. Enabling online redo log archiving.

A. Connect Time Failover requires the connect string to have two or more listener addresses configured. B. Load Balancing requires the use of a name server. C. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration. D. Source Routing requires the use of encrypted connections. E. Connect Time Failover requires the use of Transparent Application Failover (TAF).

A. FGA policies can only be created by a user with SYSDBA privilege. B. FGA policies can be created by a user having EXECUTE privilege on the DBMS_FGA package. C. FGA policies can be created by a user having granted the CREATE_FGA_POLICY role. D. FGA policies by default can be created by a schema owner on an object in their schema. E. FGA policies can be created by a user having the AUDIT_ADMIN privilege.

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

A. It skips only indexes that exist in both ORCL:SH and TESTDB:HR. B. It skips only tables that exist in ORCL:SH and ORCL:OE. C. It drops and re-creates tables that exist in both ORCL:SH and TESTDB:HR. D. It skips all indexes of ORCL:SH and in both ORCL:SH and TESTDB:HR. E. It drops and re-creates indexes that exist in both ORCL:SH and TESTDB:HR.

A. By default, all predefined maintenance windows use the DEFAULT_MAINTENANCE_PLANresource plan, and automated maintenance tasks run under subplan called ORA$AUTOTASK. B. The SYS_GROUP consumer resource group policies define the resources assigned ... C. The predefined maintenance window starts automatically with 20% of the system resources ... D. The resources used by the predefined maintenance window can only be adjusted if you create a new resource plan in Resource Manager ...