10783540
Description
Flashcards by Thea Usita, updated more than 1 year ago
|
Created by Thea Usita
over 8 years ago
|
|
| Question | Answer |
| The 'g' in Oracle Database 11g stands for? | grid |
| Three Oracle's grid infrastructure | Low cost, high quality of service, and easy to manage |
| A standard body that develops standards for grid computing. | Open Grid Forum (OGF) |
| Four Oracle's Grid Computing Technology | Automatic Storage Management, Real Application Clusters, Application Server Clusters, and Enterprise Manager Grid Control |
| Rules can be defined to automatically allocate processing resources to each service both during normal operations and in response to failures. | Automatic workload management |
| When a cluster configuration changes, the mid-tier can immediately adapt to instance failover or availability of a new instance.T | Automatic event notification to the mid-tier |
| Automatic event notification to the mid-tier | Oracle WebLogic Application Grid |
| Manages gridwide operations that include managing the entire stack software, provisioning users, cloning databases, and managing patches. | Enterprise Manager Grid Control |
| Grid Infrastructure for Single-Instance contains ___ and ___. | Oracle Automatic Storage Management (ASM) and Oracle Restart |
| Provides an open, comprehensive, integrated approach to formation management. | Oracle Database |
| ____ is a database management system that provides an open, comprehensive, integrated approach to information management. | Oracle Server |
| An Oracle Server consists of ____ and _____. | Oracle instance and Oracle database |
| The instance consists of ____ and ____ associated with that instance. | Memory Structures and Background Processes |
| A "thread of control" or a mechanism in an operating system that can run a series of steps. | Process |
| Every time an instance is started, a shared memory area called the ____ is allocated and the background processes are started. | System Global Area (SGA) |
| After starting a database instance, the Oracle software associates the instance with a specific database. This is called ____. | Mounting the database |
| Three major structures in Oracle Database server architecture | Memory structures, Process structures, and Storage structures |
| A basic Oracle database system consists of _____ and _____. | Oracle database and Database instance |
| The database consists of both ___ and ____. | physical structures and logical structures |
| T or F: The physical storage of data cannot be managed without affecting access to logical storage structures. | FALSE |
| T or F: Each database instance is associated with one and only one database | TRUE |
| A ___ database usually has multiple instances on separate servers for the same shared database. | Real Applications Cluster (RAC) |
| Is a means to access an Oracle database, consists of memory and background processes, and is always opens one and only one database. | Oracle Instance |
| Communication between a user process and an instance. | Connection |
| Specific connection of a user to an instance through a user process. | Session |
| Can be created and exist concurrently for a single Oracle database user using the same username. | Multiple sessions |
| Group of shared memory structures that contain data and control information for one Oracle Database instance. | System Global Area (SGA) |
| Memory regions that contain data and control information for a server or background process. It is a nonshared memory created by Oracle Database. | Program Global Areas (PGA) |
| Used to store most recently executed SQL statement and data definitions. | Shared Pool |
| Two key performance-related memory structures of Shared Pool. | Library cache and Data Dictionary cache |
| Is a collection of database tables and views containing reference information about the database, its structures, and its users. | Data Dictionary |
| T or F: Data Dictionary cache holds data as rows instead of buffers (which hold entire blocks of data). | TRUE |
| All Oracle Database user processes share these two caches for access to data dictionary information. | Library cache |
| Stores copies of data blocks that have been retrieved from the data files. | Database Buffer Cache |
| A circular buffer that records all changes made to the database data blocks. | Redo Log Buffer |
| An optional area of memory that relieves the burden placed on the Shared Pool and can be dynamically resized. | Large Pool |
| Is used to store all session-specific Java code and data in the JVM. | Java pool memory |
| Is used exclusively by Oracle Streams to store buffered queue messages and provide memory for Oracle Streams processes. | Streams pool memory |
| Services parsing requirements for Java commands. | Java Pool |
| Is the application or tool that connects to the Oracle database. | User process |
| Contains the Server process and Background processes. | Database processes |
| Connects to the Oracle instance and is started when a user establishes a session. | Server process |
| Are started when an Oracle instance is started. | Background processes |
| Networking listeners and Grid infrastructure daemons. | Daemon/ Application processes |
| Writes modified (dirty) buffers in the database buffer cache to disk. | Database Writer Process (DBWn) |
| Writes the redo log buffer to a redo log file on disk. | Log Writer Process (LGWR) |
| T or F: A Log Writer Process writes when the redo log buffer is one-third full. | TRUE |
| How often does the Log Writer Process writes? | 3 seconds |
| Records checkpoint information in Control file and each data file header. | Checkpoint Process (CKPT) |
| Performs recovery at instance startup and cleans up unused temporary segments. | System Monitor Process (SMON) |
| Performs process recovery when a user process fails. | Process Monitor Process (PMON) |
| Removes any rows that correspond to in-doubt transactions. | Recoverer Process |
| Copy redo log files to a designated storage device after a log switch has occurred. | Archiver Processes (ARCn) |
| Oracle Grid Infrastructure is started by the ____. | OS init daemon |
| Logical Database Structures | Database, Tablespace, Segment, Extent, and Oracle data block |
| Physical Database Structure | Data file (part of the Tablespace) |
| T or F: Segments exist in a tablespace. | TRUE |
| These are collections of extents. | Segments |
| These are collections of data blocks. | Extents |
| These are mapped to disk blocks. | Data blocks (File System Storage) |
| The ___ and ___ tablespaces are mandatory tablespaces that are created at the time of database creation. They must be online. | SYSTEM and SYSAUX |
| This tablespace is used for core functionality (e.g. , data dictionary tables). | SYSTEM |
| This tablespace is used for additional database components (such as the Enterprise Manager Repository). | SYSAUX |
| T or F: The SYSTEM and SYSAUX tablespaces are recommended to be used to store application's data. | FALSE |
| Is a portable and high-performance cluster file system and manages Oracle database files. | Automatic Storage Management |
Want to create your own Flashcards for free with GoConqr? Learn more.