Chapter8 Flashcards

1
Q

facilitates the storage, modification and retrieval of this data.

A

Database Management System

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

the data consists of a set of relational objects.

A

relational database management system

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Language used to interact with the Oracle

A

SQL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

primary tool for an Oracle DBA

A

SQLPlus

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

web bases database management tool that is bundled with the Oracle

A

Enterprise Manager Database Control

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Oracle server architecture can be described in three categories

A

User-related processes, Oracle instance, database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

collection of logical memory structures

A

Oracle instance

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Physical file structures

A

database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

composed of the memory structures and background processes

A

instance

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

two type of process allow to user to interact with the instance and dabatase

A

User processes and server processes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

process of initiating and maintaining communication between the user process and instance

A

connection

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

When the connection is made, the user establishes what?

A

session

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

it generally have a one-to-one relationship with user process

A

server process

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Oracle’s main memory structure and shared memory area

A

System Global Area(SGA)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Required SGA components

A

Shared pool, Database buffer cache and redo log buffer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

Shared Pool

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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

A

Database buffer cache

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Stores transaction information for recovery purposes

A

Redo log buffer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Memory in the SGA is allocated in units of contiguous memory called

A

granules

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Three kinds of Database buffer cache

A

dirty buffers, free buffers, pinned buffers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

buffer blocks that need to be written to the data files

A

Dirty buffers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

do not cotain any data or are free to be overwritten

A

Free buffers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

are the buffers that are currently being accessed or explicitly retained for future use.

A

Pinned buffers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Algorithm used to manage the contents of the shared pool and database buffer cache

A

Least Recently Used Algorithm

25
Writes the database blocks from the database buffer cache to the data files
Database Writer(DBWn)
26
A circular buffer in the SGA that holds information about the changes made to the database data.
Redo Log Buffer
27
changes made in the database are called
redo entries
28
writes the redo log information to other online redo log files
Log writer(LGWR)
29
Updates the data file headers following a checkpoint event
Checkpoint(CKPT)
30
Cleans up failed user database connections
Process Monitor
31
Performs instance recovery following an instance crash, coalesces free space in the database, and manages space used for sorting
System Monitor
32
An additional memory structure is also created for each user is called
Program Global Area(PGA)
33
Process that manages the size of each individual SGA components
Memory Manager
34
Process that gathers and analyzes statistics used by the Automatic Workload Repository feauture
Memory Monitor
35
Physical storage structures include three types of files
Control files, data files, redo log files
36
Information contained in this file are the locations of other physical files, database name, database block size, database character set, recovery information.
Control files
37
Information contained in this file are all application data and internal metadata
Data file
38
Information contained in this file are the record of all changes made to the database
Red log file
39
Main Database Architecture Components
Instance, Process, Storage, Memory
40
Database Instances:
Shutdown, NoMount, Mount, Open
41
Database instance where the instance started
NoMount
42
Database instance where the control file opened for this instance
Mount
43
Database instance where all files as describe by the control file for this instance
Open
44
Performs manageability-related background tasks
Memory Monitor(MMON)
45
Performs frequent and lightweight manageability-related tasks
Memory Monitor Light(MMNL)
46
Performs automatic memory management tasks
Memory Manager(MMAN)
47
Runs user jobs used in batch processing
Job Queue Coordinator(CJQ0)
48
Monitors the Streams Advanced Queuing message queues
AQ Coordinator(QMNC)
49
A data file can belong to one and only one tablespace. A tablespace could have more than one data file associated with it
true.
50
Smallest unit of storage in Oracle
Block
51
grouping of blocks
extent
52
it is a set of extents allocated for logical grouping
segment
53
Provides large memory allocations for: - Session memory for the shared server and the Oracle XA interface - I/O server processes - Oracle Database backup and restore operations
Large pool
54
It started when a database user or a batch process connects to Oracle Database
User process
55
Connects to the Oracle instance and is started when a user establishes a session
Server Process
56
Are started when an Oracle instance is started
Database Processes
57
- It is used with distributed databases configuration - Automatically connects to other databases involved in in-doubt distributed transactions - Automatically resolves all in-doubt transactions - Removes any rows that correspond to in-doubt trasactions
Recoverer Process
58
- Copy redo log files to a designated storage device after a log switch has occurred - Can collect transaction redo data and transmit that data to standby destinations
Archiver Processes(ARCn)
59
a ____ is a set of database structures, such as tables, indexes, user-defined attributes.
Schema