최신Oracle Database 23ai Administration Associate - 1Z1-182무료샘플문제

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 an application root along with the associated PDBs.

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

A. Optimizer Statistics are collected in real-time as data is inserted, deleted, or updated.

B. Optimizer Statistics are collected automatically by Automatic Workload Repository (AWR) Snapshot.

C. Optimizer Statistics are collected automatically by an automatic maintenance job that runsduring predefined maintenance windows.

D. Optimizer Statistics are collected by the Statistics Advisor.

E. Optimizer Statistics can be manually collected at multiple levels using DBMS_STATS.GATHER_*_STATS PL/SQL procedures.

A. Renaming data files.

B. Re-creating control files.

C. Creating a database.

D. Full database recovery.

E. Enabling online redo log archiving.

A. It is held inside an Oracle database schema.

B. It supports diagnostics for Oracle Clusterware.

C. The ADR base defaults to $ORACLE_HOME/rdbms/admin if neither DIAGNOSTIC_DEST nor ORACLE_BASE is set.

D. It supports diagnostics for Automatic Storage Management (ASM).

E. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set.

A. A connection represents the state of a user's login to an instance.

B. A session represents the state of a user's login to an instance.

C. The buffer cache and the redo log buffer are held in the large pool.

D. A person or program can have more than one session with an instance by logging in with different users.

E. A person or program can have more than one session with an instance by logging in with the same user.

F. Each server process or background process has their own Program Global Area (PGA).

A. One instance on one server mounting and opening one database.

B. One instance on one server that has no database mounted.

C. One instance on one server mounting multiple databases.

D. Two or more instances on separate servers all mounting and opening the same database.

E. One instance on one server mounting and opening multiple databases.

A. READ WRITE

B. RESTRICTED WRITE ONLY

C. RESTRICTED READ ONLY

D. READ ONLY

A. AUTOEXTEND is possible for the datafile.

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

C. Additional data files may not be added.

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

E. It will always have a 32K blocksize.

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

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

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

D. If only DB_CREATE_ONLINE_LOG_DEST_1 is specified, only redo logs and control 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_FILE_DEST is specified, only data files and temp files are Oracle managed.

A. Active UNDO is always retained.

B. Unexpired UNDO is always retained.

C. UNDO_RETENTION specifies how long all types of UNDO are retained.

D. UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unconsumed UNDO.

E. UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.