Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Database > Chapter8 > Flashcards

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
Q

Writes the database blocks from the database buffer cache to the data files

A

Database Writer(DBWn)

26
Q

A circular buffer in the SGA that holds information about the changes made to the database data.

A

Redo Log Buffer

27
Q

changes made in the database are called

A

redo entries

28
Q

writes the redo log information to other online redo log files

A

Log writer(LGWR)

29
Q

Updates the data file headers following a checkpoint event

A

Checkpoint(CKPT)

30
Q

Cleans up failed user database connections

A

Process Monitor

31
Q

Performs instance recovery following an instance crash, coalesces free space in the database, and manages space used for sorting

A

System Monitor

32
Q

An additional memory structure is also created for each user is called

A

Program Global Area(PGA)

33
Q

Process that manages the size of each individual SGA components

A

Memory Manager

34
Q

Process that gathers and analyzes statistics used by the Automatic Workload Repository feauture

A

Memory Monitor

35
Q

Physical storage structures include three types of files

A

Control files, data files, redo log files

36
Q

Information contained in this file are the locations of other physical files, database name, database block size, database character set, recovery information.

A

Control files

37
Q

Information contained in this file are all application data and internal metadata

A

Data file

38
Q

Information contained in this file are the record of all changes made to the database

A

Red log file

39
Q

Main Database Architecture Components

A

Instance, Process, Storage, Memory

40
Q

Database Instances:

A

Shutdown, NoMount, Mount, Open

41
Q

Database instance where the instance started

A

NoMount

42
Q

Database instance where the control file opened for this instance

A

Mount

43
Q

Database instance where all files as describe by the control file for this instance

A

Open

44
Q

Performs manageability-related background tasks

A

Memory Monitor(MMON)

45
Q

Performs frequent and lightweight manageability-related tasks

A

Memory Monitor Light(MMNL)

46
Q

Performs automatic memory management tasks

A

Memory Manager(MMAN)

47
Q

Runs user jobs used in batch processing

A

Job Queue Coordinator(CJQ0)

48
Q

Monitors the Streams Advanced Queuing message queues

A

AQ Coordinator(QMNC)

49
Q

A data file can belong to one and only one tablespace. A tablespace could have more than one data file associated with it

A

true.

50
Q

Smallest unit of storage in Oracle

A

Block

51
Q

grouping of blocks

A

extent

52
Q

it is a set of extents allocated for logical grouping

A

segment

53
Q

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
A

Large pool

54
Q

It started when a database user or a batch process connects to Oracle Database

A

User process

55
Q

Connects to the Oracle instance and is started when a user establishes a session

A

Server Process

56
Q

Are started when an Oracle instance is started

A

Database Processes

57
Q
  • 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
A

Recoverer Process

58
Q
  • 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
A

Archiver Processes(ARCn)

59
Q

a ____ is a set of database structures, such as tables, indexes, user-defined attributes.

A

Schema

Database (6 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions