Brainscape's Knowledge GenomeTM

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


See full index

3910 - Database Admin & Management > Chapter 8 > Flashcards

Chapter 8 Flashcards

1
Q

Facilitates the storage modification, and retrieval of this data

A

Database Management System (DBMS)

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 (RDBMS)

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

The column or set of columns that uniquely identifies a row

A

Primary Key

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

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

A

Foreign Key

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

The table where the column is a primary key

A

Parent Table

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

The table where the foreign key column exists

A

Child Table

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

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

A

Constraints

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

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

A

Table

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

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

A

View

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

Used to summarize and store data

A

Materialized view

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

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

A

Index-organized table

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

A group of tables that share the same storage blocks

A

Cluster

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

A stored rule to enforce data integrity

A

Constraint

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

Provides a mechanism for the continuous generation of numbers

A

Sequence

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

An alias for a database schema object

A

Synonym

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

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

A

Triggers

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

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

A

Stored function

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

PL/SQL programs to define a business process

A

Stored procedure

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

A collection of procedures, functions, and other program constructs

A

Package

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

Can be created in Oracle to define business processes

A

Java

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

Used to communicate between databases to share data

A

Database link

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

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

A

SQL*Plus

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

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

A

SQL Developer

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

An optional structure that is useful for locating data faster

A

Index

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

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

A

Oracle Enterprise Manager Database Control

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

Logical memory structures

A

Oracle instance

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

Physical file structures

A

Database

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

Key database components

A

Memory structures, Process structures, and storage structures

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

Instance and database together

A

Oracle server

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

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

A

User and Server process

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

Process of initiating and maintaining communication between user process and instance

A

Connection

32
Q

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

A

Program Global Area (PGA)

33
Q

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

A

System Global Area (SGA)

34
Q

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

A

Shared pool (required SGA components)

35
Q

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

A

Database buffer cache (required SGA components)

36
Q

Stores transaction information for recovery purposes

A

Redo log buffer (required SGA components)

37
Q

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

A

Java pool (optional SGA components)

38
Q

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

A

Large pool

39
Q

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

A

Streams pool

40
Q

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

A

Result cache

41
Q

Memory in SGA is allocated in units of contiguous memory

A

Granules

42
Q

Write the contents of the dirty buffers to the data files

A

Database writer process (DBWn)

43
Q

Buffer blocks that need to be written to the data files

A

Dirty buffers

44
Q

Dont contain any data or are free to be overwritten

A

Free buffers

45
Q

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

A

Pinned buffers

46
Q

Writes the redo log buffer to redo log file on disk

A

LogWriter Process (LGWR)

47
Q

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

A

Checkpoint Process (CKPT)

48
Q
  • Performs recovery at instance startup

- Cleans up unused temporary segments

A

System Monitor Process (SMON)

49
Q

Performs process recovery when a user process fails

A

Process Monitor Process (PMON)

50
Q

Recovers failed transactions that are distributed across multiple databases

A

Recoverer (RECO)

51
Q

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

A

Archiver Processes (ARCn)

52
Q

Performs manageability-related background tasks

A

MMON Memory Monitor

53
Q

Performs frequent and lightweight manageability-related tasks

A

MMNL Memory Monitor Light

54
Q

Performs automatic memory management tasks

A

MMAN Memory Manager

55
Q

Runs user jobs used in batch processing

A

CJQ0 Job Queue Coordinator

56
Q

Monitors the Streams Advanced Queuing message queues

A

QMNC AQ Coordinator

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

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

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

C. Correct the underlying issue, and retry the installation

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

B. /etc/oraInst.loc

60
Q
  1. Which component is not part of the Oracle instance?
A

C. Control file

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

C. LGWR

62
Q
  1. Hired as DBA for company. Which of the following tasks might have been included in job description?
A

D. Any of the above

63
Q
  1. Which of the following best describes RAC configuration?
A

A. One database, multiple instances

64
Q
  1. Which component of the SGA contains the parsed SQL code?
A

C. Library cache

65
Q
  1. Which are the tasks accomplished by the SMON process?
A

A. Performs recovery at instance startup

D. Coalesces contiguous free space in dictionary-managed tablespaces

66
Q
  1. Choose the best statement from the options related to segments
A

B. A nonpartitioned table can have only one segment

67
Q
  1. The Oracle Universal Installer prompts for which variable if not set?
A

C. ORACLE_BASE

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

D. Large pool

69
Q
  1. When a user session is terminated, which processes are responsible for cleaning up and releasing locks?
A

D. PMON

70
Q
  1. The LRU algorithm is used to manage what part of the Oracle architecture?
A

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

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

A. Instance consists of memory structures and processes

Database is composed of physical files

72
Q
  1. Which of the following is the proper order of Oracle’s storage hierarchy from small to large?
A

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

73
Q

17.

A

D. Determine which directory will be used for $ORACLE_HOME

74
Q
  1. Oracle’s OFA model specifies a naming convention for all but which of the following?
A

A. Database name

75
Q

Oracle Universal Installer is started by executing which program?

A

B. runInstaller

76
Q

Script root.sh must be executed during installation process.

A

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

3910 - Database Admin & Management (3 decks)

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