最新的Oracle Database 23ai Administration Associate - 1Z1-182免費考試真題

A. Automatic Backups of the database system files.

B. Automatic notification tasks.

C. Automatic Optimizer Statistics Collection.

D. Automatic SQL Plan Management advisor tasks.

E. Automatic segment and segment statistics advisor tasks.

F. Automatic error and failure log collection tasks.

A. DBA_ALL_USER_TAB_COLUMNS

B. DBA_ALL_USER_TABLES

C. DBA_ALL_USER_EXTERNAL_TABLES

D. DBA_ALL_USER_EXTERNAL_LOCATIONS

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

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

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

D. A segment might have only one extent.

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

F. Segments can span multiple tablespaces.

A. It contains only static initialization parameters.

B. It must exist for a database instance to start.

C. It can be created by SYS from an idle instance.

D. It contains initialization parameters whose values can be changed using the ALTER SYSTEM statement.

E. It can be used to create a PFILE.

A. Additional data files may not be added.

B. It will always have a 32K blocksize.

C. AUTOEXTEND is possible for the datafile.

D. It must be bigger than the largest SMALLFILE tablespace.

E. It will be a dictionary-managed tablespace by default.

A. By using the LSINVENTORY Command to query the Oracle Database Software Library.

B. By querying the DBA_UNIFIED_AUDIT_OPTION view.

C. By executing DBMS_AUDIT_MGMT PL/SQL package in Verify mode.

D. By querying V$OPTION for parameter Unified Auditing.

A. Registering services with Oracle Net listeners.

B. Reading database blocks into the buffer cache.

C. Reading database blocks into the buffer cache.

D. Writing dirty database block images from the buffer cache.

E. Writing redo to log files.

F. Creating dedicated server connections.

A. By setting the STATISTICS_LEVEL parameter to BASIC.

B. By executing the PL/SQL procedure DBMS_TIME_STATISTIC.DISABLE(TRUE).

C. By setting the TIMED_STATISTICS system parameter to FALSE.

D. By setting the TIMED_STATISTICS_LEVEL system parameter to FALSE.

E. By executing the PL/SQL procedure DBMS_TIME_STATISTIC.LEVEL(BASIC).

A. When the DBA revokes the CREATE VIEW privilege from USR1, it is neither revoked from USR2 nor USR3.

B. The DBA can revoke only ADMIN OPTION from USR1.

C. USR1 can revoke the CREATE VIEW privilege from USR3.

D. When the DBA revokes the CREATE VIEW privilege from USR2, it is revoked from USR3.

E. When the DBA revokes the CREATE VIEW privilege from USR1, it is revoked from USR2 but not USR3.

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

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

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

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