Brainscape's Knowledge GenomeTM

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


See full index

CCINFOM Comprehensive > Database Environment & ANSI SPARC > Flashcards

Database Environment & ANSI SPARC Flashcards

1
Q

What is Metadata in the context of a database?

A

it is data about the database itself

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

What is a System Catalog?

A

A repository in the database system that stores metadata

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

What are the other terms of a System Catalog

A

Data Dictionary or Metadata

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

What does a System catalog do?

A

Describes the structure, organization, constraints, and relationships of a DB system. It also ensures the DBMS has the needed information

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

Enumerate the contents of a System Catalog

HINT: TIVURS

A
  1. Tables and Columns
  2. Indexes
  3. Views
  4. Users and Roles
  5. Relationships
  6. Statistics
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

This refers to hiding the complexities of data storage and management from end users

A

Data Abstraction

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

What are the 3 levels of Data Abstraction

A

Physical, Conceptual, External

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

This level of abstraction describes how data is stored in physical storage devices

A

Physical Level

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

This level of abstraction provides a unified view of the database

A

Conceptual Level

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

This level represents views with relevant data tailored for specific users and applications

A

External Level

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

What are the Components of a Database Environment
HINT: HSDPP

A
  1. Hardware
  2. Software
  3. Data
  4. Procedures
  5. People
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Servers, storage devices, and network infrastructure belong to which DB environment component?

A

Hardware

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

DBMS, OS, and applications belong to which DB environment component?

A

Software

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

Backup and recovery, Security Policies, and maintenance belong to which DB environment component?

A

Procedures

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

This is the heart of the DB environment, acting as the bridge connecting, hardware, software, and users

A

Data

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

What are the 3 types of Data?

A

User Data, Metadata, Indexes

17
Q

This data represents the actual records stored in tables

A

User Data

18
Q

This data represents info about the database structure

A

Metadata

19
Q

This data represents structures for optimizing query performance

A

Indexes

20
Q

What are Procedures in the DB environment

A

They define rules, policies, and guidelines for using and managing the DB system

21
Q

These types of Users are involved in the design, development, and maintenance of the database

A

Technical Users

22
Q

These types of Users access the database only to perform their job functions and do not need to know how the database works

A

Non-Technical Users

23
Q

What is the ANSI-SPARC architecture?

A

A conceptual framework standardizing how databases are organized and interacted with.

24
Q

What does ANSI-SPARC stand for?

A

American National Standards Institute, Standards Planning And Requirements Committee

25
Q

What are the three levels of abstraction in ANSI SPARC?

A
  1. Physical Level / Internal View
  2. Conceptual Level / View
  3. External Level / View
26
Q

This view describes how data is stored on hardware

A

Physical View

27
Q

This view defines the logical schema of the database

A

Conceptual View

28
Q

This view Represents user-specific views of data

A

External View

29
Q

This refers to a logical and user-defined abstraction of data

A

View

30
Q

This refers to the form, structure, or model in which data is organized or stored

A

Representations

31
Q

How do Representations differ from Views?

A

Representations are a broader concept and encompass all ways data is modeled, stored, or presented, regardless of user interaction

32
Q

What are the two types of representations, explain what they are.

A
  1. Physical Representation: Physical storage of data
  2. Logical Representation: How the database logically structures data
33
Q

These are dedicated machines where the DBMS and database reside

A

Servers

34
Q

This connects clients to the database server

A

Network Infrastructure

35
Q

It is the core software managing data storage, retrieval, and manipulation

A

DBMS

36
Q

Provides an interface between hardware and software

A

Operating System

CCINFOM Comprehensive (12 decks)

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