|
|
Criado por Thea Usita
mais de 8 anos atrás
|
|
The 'g' in Oracle Database 11g stands for?
Three Oracle's grid infrastructure
A standard body that develops standards for grid computing.
Four Oracle's Grid Computing Technology
Rules can be defined to automatically allocate processing resources to each service both during normal operations and in response to failures.
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
Manages gridwide
operations that include managing the entire stack software, provisioning users, cloning databases, and managing patches.
Grid Infrastructure for Single-Instance contains ___ and ___.
Provides an open, comprehensive, integrated approach to formation management.
____ is a database management system that provides an open, comprehensive, integrated approach to information management.
An Oracle Server consists of ____ and _____.
The instance consists of ____ and ____ associated with that instance.
A "thread of control" or a mechanism in an operating system that can run a series of steps.
Every time an instance is started, a shared memory area called the ____ is allocated and the background processes are started.
After starting a database instance, the Oracle software associates the instance with a specific database. This is called ____.
Three major structures in Oracle Database server architecture
A basic Oracle database system consists of _____ and _____.
The database consists of both ___ and ____.
T or F: The physical storage of data cannot be managed without affecting access to logical storage structures.
T or F: Each database instance is associated with one and only one database
A ___ database usually has multiple
instances on separate servers for the same shared database.
Is a means to access an Oracle database, consists of memory and background processes, and is always opens one and only one database.
Communication between a user process and an instance.
Specific connection of a user to an instance through a user process.
Can be created and exist concurrently for a
single Oracle database user using the same username.
Group of shared memory structures that contain data and control information for one Oracle Database instance.
Memory regions that contain data
and control information for a server or background process. It is a nonshared memory created by Oracle Database.
Used to store most recently executed SQL statement and data definitions.
Two key performance-related memory structures of Shared Pool.
Is a collection of database tables and views containing reference information about the database, its structures, and its users.
T or F: Data Dictionary cache holds data as rows instead of buffers (which hold entire blocks of data).
All Oracle Database user processes share these two caches for access to data dictionary information.
Stores copies of data blocks that have been retrieved from the data files.
A circular buffer that records all changes made to the database data blocks.
An optional area of memory that relieves the burden placed on the Shared Pool and can be dynamically resized.
Is used to store all session-specific Java code and data in the JVM.
Is used exclusively by Oracle Streams to store buffered queue messages and provide memory for Oracle Streams processes.
Services parsing requirements for Java commands.
Is the application or tool that connects to the Oracle database.
Contains the Server process and Background processes.
Connects to the Oracle instance and is started when a user establishes a session.
Are started when an Oracle instance is started.
Networking listeners and Grid infrastructure daemons.
Writes modified (dirty) buffers in the database buffer cache to disk.
Writes the redo log buffer to a redo log file on disk.
T or F: A Log Writer Process writes when the redo log buffer is one-third full.
How often does the Log Writer Process writes?
Records checkpoint information in Control file and each data file header.
Performs recovery at instance startup and cleans up unused temporary segments.
Performs process recovery when a user process fails.
Removes any rows that correspond to in-doubt transactions.
Copy redo log files to a designated storage device after a log switch has occurred.
Oracle Grid Infrastructure is started by the ____.
Logical Database Structures
Physical Database Structure
T or F: Segments exist in a tablespace.
These are collections of extents.
These are collections of data blocks.
These are mapped to disk blocks.
The ___ and ___ tablespaces are mandatory tablespaces that are created at the time of database creation. They must be online.
This tablespace is used for core functionality (e.g. , data dictionary tables).
This tablespace is used for additional database components (such as the Enterprise Manager Repository).
T or F: The SYSTEM and SYSAUX tablespaces are recommended to be used to store application's data.
Is a portable and high-performance cluster file system and manages Oracle database files.
Ocultar acertos