WGU D192 2023 Completely Solved!Archived redo log file - Answer A copy of a redo log file before it is overwritten by new redo information.ARCn - Answer is the archiver process that copies the content of redo logs to archive redo log files. The archiver process can have multiple processes, which allow the archiver to write to various destinations such as D: drive, E drive or other storage.ASH (Active Session History) - Answer Refers to the data that is sampled at specified intervals from the current state of all active sessions.ASM (Automatic Storage Management) storage - Answer Designed to relieve the burden of disk and storage management and relies on Oracle to maintain the database storage.catctl.pl - Answer A script that performs the upgrade in parallel, making use of the CPU resources available.CKPT - Answer is the checkpoint process. In Oracle, data that is on disk is called block and the data which in memory is called buffer. When a block is written to the buffer and changed, the buffer becomes dirty, and it needs to be written down to the disk. This process updates the control and data file headers with checkpoint information and signals writing of dirty buffers to disk. Note that Oracle 12c allows both full and incremental checkpoints.Consumer groups - Answer Used to group user sessions together so that the different groups can be assigned different processing requirements.Control files - Answer Contain locations of other physical files, database name, database block size, database character set, and recovery information. These files are required to open the database.Data Block - Answer corresponds to a number of bytes on the disk. Oracle stores data in these. These are also referred to as logical blocks, Oracle blocks or pages.Data dictionary views - Answer Provide information about the database and its objects.Data files - Answer Physical files that actually store the data that has been inserted into each table in the database.Data Pump - Answer A high-speed mechanism for transferring data or metadata from one database to another or from operating-system files.Database buffer cache - Answer An area in SGA that caches the database data, holding blocks from the data files that have been accessed recently.DBA - Answer The most powerful role in the database. This role has all the system privileges and several administrative privileges. 1 / 2
WGU D192 2023 Completely Solved!DBCA (Database Configuration Assistant) - Answer A Java-based tool that is used to create Oracle databases.DBMS_SCHEDULER.CREATE_JOB - Answer Used to create a job, which can be executed directly or executed automatically on a scheduled basis inside the Oracle Scheduler.DBUA (Database Upgrade Assistant) - Answer A GUI tool that performs the pre- upgrade checks, the upgrade, and the post-upgrade tasks after obtaining a few inputs.DBWn - Answer is the database writer. Oracle performs every operation in memory instead of the disk because processing in memory is faster and more efficient than on disk. This process reads data from disk and writes it back to the disk. An Oracle instance has many database writers DBW0, DBW1, DBW2, and so on.DRCP (Database Resident Connection Pooling) - Answer An optional configuration of the Oracle server, enhancing middle-tier connection pools that share connections between threads in a middle-tier process.Dump files - Answer Contain data and metadata information.EXCLUSIVE lock mode - Answer Permits queries on the locked table but prohibits DML by any other users.expdp - Answer A Data Pump Export utility that unloads data and metadata to a set of OS files called dump files.Extents - Answer is a specific number of logically contiguous data blocks used to store the particular type of information.External tables - Answer Tables with data that does not reside in the database.Fast recovery area - Answer An area of the disk dedicated to the storage and management of files needed for recovering an Oracle database.impdp - Answer A Data Pump Import utility that loads data and metadata stored in an export dump file to a target database.Instance failure - Answer Occurs when the instance shuts down without synchronizing all the database files to the same system change number (SCN), requiring a recovery operation the next time the instance is started.LGWR - Answer is the log writer process which is the key to the recoverability architecture. Every change occurs in the database is written out to a file called redo log for recovery purposes. And these changes are written and logged by LGWR process. The x process first writes the changes to memory and then disk as redo logs which then can be used for recovery.
- / 2