Chapter 8 Flashcards by Elouie Ildefonso

Facilitates the storage modification, and retrieval of this data

Database Management System (DBMS)

How well did you know this?

Not at all

Perfectly

The data consists of a set of relational objects

Relational Database Management System (RDBMS)

How well did you know this?

Not at all

Perfectly

The column or set of columns that uniquely identifies a row

Primary Key

How well did you know this?

Not at all

Perfectly

States that the data value in the column exists in the other table

Foreign Key

How well did you know this?

Not at all

Perfectly

The table where the column is a primary key

Parent Table

How well did you know this?

Not at all

Perfectly

The table where the foreign key column exists

Child Table

How well did you know this?

Not at all

Perfectly

Used by Oracle to enforce the parent-child relationship between tables

Constraints

How well did you know this?

Not at all

Perfectly

Basic from of data storage that has columns and stores rows of data

Table

How well did you know this?

Not at all

Perfectly

A stored query; no data storage space is occupied for view data

View

How well did you know this?

Not at all

Perfectly

Used to summarize and store data

Materialized view

How well did you know this?

Not at all

Perfectly

Use primary key and stores the table data in the index segment

Index-organized table

How well did you know this?

Not at all

Perfectly

A group of tables that share the same storage blocks

Cluster

How well did you know this?

Not at all

Perfectly

A stored rule to enforce data integrity

Constraint

How well did you know this?

Not at all

Perfectly

Provides a mechanism for the continuous generation of numbers

Sequence

How well did you know this?

Not at all

Perfectly

An alias for a database schema object

Synonym

How well did you know this?

Not at all

Perfectly

A PL/SQL program unit that gets executed when an event occurs

Triggers

How well did you know this?

Not at all

Perfectly

Are PL/SQL programs that can be used to create user-defined functions to return a value

Stored function

How well did you know this?

Not at all

Perfectly

PL/SQL programs to define a business process

Stored procedure

How well did you know this?

Not at all

Perfectly

A collection of procedures, functions, and other program constructs

Package

How well did you know this?

Not at all

Perfectly

Can be created in Oracle to define business processes

Java

How well did you know this?

Not at all

Perfectly

Used to communicate between databases to share data

Database link

How well did you know this?

Not at all

Perfectly

Primary tool for an Oracle DBA to administer the database using SQL commands

SQL*Plus

How well did you know this?

Not at all

Perfectly

A free GUI database-development tool; you can create and view the dtabase objects, make changes to the objects, run SQL statements, run PL/SQL programs, create and edit PL/SQL programs, and perform PL/SQL debugging

SQL Developer

How well did you know this?

Not at all

Perfectly

An optional structure that is useful for locating data faster

Index

How well did you know this?

Not at all

Perfectly

A web-based database management tool that is bundled with the Oracle 11g database

Oracle Enterprise Manager Database Control

Logical memory structures

Oracle instance

Physical file structures

Database

Key database components

Memory structures, Process structures, and storage structures

Instance and database together

Oracle server

2 types of processes that allow a user to interact with instance/database

User and Server process

Process of initiating and maintaining communication between user process and instance

Connection

Stores user-specific session information such as bind variables and session variables

Program Global Area (PGA)

The server process communicates when the user accesses the data in the database

System Global Area (SGA)

Caches the most recently used SQL statements that have been issued by database users

Shared pool (required SGA components)

Caches the data that has been most recently accessed by database users

Database buffer cache (required SGA components)

Stores transaction information for recovery purposes

Redo log buffer (required SGA components)

Caches the most recently used Java objects and application code when Oracle's JVM option is used

Java pool (optional SGA components)

Caches data for large operations such as Recovery Manager(RMAN) backup and restore activities and Shared Server components

Large pool

Caches the data associated with queued message requests when Oracle's Advanced Queuing option is used

Streams pool

This new area is introduced in Oracle 11g database and stores results of SQL queries and PL/SQL functions for better performance

Result cache

Memory in SGA is allocated in units of contiguous memory

Granules

Write the contents of the dirty buffers to the data files

Database writer process (DBWn)

Buffer blocks that need to be written to the data files

Dirty buffers

Dont contain any data or are free to be overwritten

Free buffers

Buffers that are currently being accessed or explicitly retained for future use

Pinned buffers

Writes the redo log buffer to redo log file on disk

LogWriter Process (LGWR)

Records checkpoint information in - Control file - Each data file header

Checkpoint Process (CKPT)

- Performs recovery at instance startup | - Cleans up unused temporary segments

System Monitor Process (SMON)

Performs process recovery when a user process fails

Process Monitor Process (PMON)

Recovers failed transactions that are distributed across multiple databases

Recoverer (RECO)

Copy redo log files to a designated storage device after a log switch has occurred

Archiver Processes (ARCn)

Performs manageability-related background tasks

MMON Memory Monitor

Performs frequent and lightweight manageability-related tasks

MMNL Memory Monitor Light

Performs automatic memory management tasks

MMAN Memory Manager

Runs user jobs used in batch processing

CJQ0 Job Queue Coordinator

Monitors the Streams Advanced Queuing message queues

QMNC AQ Coordinator

1. What are the benefits of using the OFA Optimal Flexible Architecture standard for installing Oracle 11g?

A. Helps eliminate fragmentation of free space in the SYSTEM tablespace C. Facilitates routine administrative tasks such as software backups

2. You are trying to install Oracle 11g and the OUI Oracle Universal Installer prerequisite check failed. What should you do?

C. Correct the underlying issue, and retry the installation

3. When installing Oracle 11g on the Linux platform, which file is created by executing the orainstRoot.sh script as root?

B. /etc/oraInst.loc

4. Which component is not part of the Oracle instance?

C. Control file

5. Which background process guarantees that committed data is saved even when the changes have not been recorded in data files?

C. LGWR

6. Hired as DBA for company. Which of the following tasks might have been included in job description?

D. Any of the above

7. Which of the following best describes RAC configuration?

A. One database, multiple instances

8. Which component of the SGA contains the parsed SQL code?

C. Library cache

9. Which are the tasks accomplished by the SMON process?

A. Performs recovery at instance startup | D. Coalesces contiguous free space in dictionary-managed tablespaces

10. Choose the best statement from the options related to segments

B. A nonpartitioned table can have only one segment

11. The Oracle Universal Installer prompts for which variable if not set?

C. ORACLE_BASE

12. Which SGA component will you increase or configure so that RMAN backups are not using area from the shared pool?

D. Large pool

13. When a user session is terminated, which processes are responsible for cleaning up and releasing locks?

D. PMON

14. The LRU algorithm is used to manage what part of the Oracle architecture?

D. The shared pool and database buffer cache portions of the SGA

15. 2 structures make up an Oracle server : an instance and db. Which of the following best describes the difference between both?

A. Instance consists of memory structures and processes | Database is composed of physical files

16. Which of the following is the proper order of Oracle's storage hierarchy from small to large?

B. Operating-system block, database block, extent, segment

17.

D. Determine which directory will be used for $ORACLE_HOME

18. Oracle's OFA model specifies a naming convention for all but which of the following?

A. Database name

Oracle Universal Installer is started by executing which program?

B. runInstaller

Script root.sh must be executed during installation process.

D. It copies files and sets permissions on files outside $ORACLE_HOME