Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

IS230 > Chapter 1 > Flashcards

Chapter 1 Flashcards

1
Q

what types of databases does traditional applications have?

A

numeric and textual databases.

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

stock administration is an example of….

A

numeric and textual databases used in traditional databases

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

spotify and youtube are examples of ___________ databases.

A

multimedia

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

GIS stands for….

A

Geographic Information Systems

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

Name 3 types of databases used in recent applications:

A
  • multimedia databases
  • geographical information systems
  • biological and genome databases
  • data warehouses
  • mobile databases
  • real-time and active databases
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Data that resides on the “cloud” means

A

it is in huge data centers using thousands of machines

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

a collection of related data.

A

database

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

known facts that can be recorded and have an implicit meaning.

A

data

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

a software package/system to facilitate the creation and maintenance of a computerized database.

A

Database Management System (DBMS)

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

the DMBS software together with the data itself. (Sometimes, the applications are also included.

A

Database System

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

A database system is composed of ________ and _________.

A

the DBMS, the data itself.

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

T/F: Student grades and transcripts at a university is an example of a mini-world

A

true.

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

some part of the real world about which data is stored in a database.

A

mini-world

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

A database has a ______, a ______, and an __________ as its implicit properties.

A

source, form, audience.

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

T/F: Changes to the miniworld are reflected in the database.

A

true.

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

T/F: A random assortment of data can be referred to as a database.

A

false, it cannot be referred to as a database.

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

T/F: A database is a logically coherent collection of data with some inherent meaning.

A

true.

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

T/F: A database does not have an intended group of users.

A

false, it has an intended group of users

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

T/F: A database is designed, built, and populated with data for a general purpose.

A

false, for a specific purpose

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

T/F: A database has a specific size and complexity.

A

false, it can be of any size and complexity.

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

A simplified database system environment includes the ______, and the ____________.

A

database system, DBMS software.

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

The DBMS software includes two kind of software one to _____________, and one to ___________.

A

process queries/programs, access stored data.

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

What are the two kinds of databases that the DBMS software accesses?

A

the stored database, and the stored database definition (Meta-Data)

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

T/F: the DBMS doesn’t have to deal with the authorization of users to allow them access to data.

A

false, DBMS must not allow unauthorized users to access data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
T/F: the DBMS must keep up with changing user requirements against the database.
true
26
T/F: Defining a particular database in terms of its data types, structures, and constraints is one of the typical DBMS functions.
true
27
_______ or ________ the initial database contents on a secondary storage medium is one of the typical DBMS functions.
Constructing, loading
28
T/F: Manipulating the database, one of the typical DBMS functions, includes retrieval, modification, and accessing the database through web applications.
true.
29
_______ and ________ by a set of concurrent users and applications programs, is one of the typical functions of the DBMS.
Processing, sharing.
30
The data that is being processing and shared in a DBMS by concurrent users and application programs must all be ______ and _______.
valid, consistent.
31
Applications interact with a database by generating ________ and ___________.
queries, transcations.
32
an executing program that forms a logical unit of database processing.
transcations
33
T/F: transcations include *only one* of database access operations including insertion, deletion, modification or retrieval operations.
false, one or more.
34
transcations need to be ________ or _______.
committed, aborted.
34
T/F: DBMS may additionally provide protection or security measures to prevent unauthorized access.
true.
34
DBMS Protection includes: ________ against hardware or software malfunction (or crashes), and ___________ against unauthorized or malicious access.
System protection, security protection
34
Other DBMS functions includes: Presentation and visualization of _______, and "_____" processing to take internal actions on data.
data, "active".
34
the maintenance of the database and associated programs over the lifetime of the database application. By allowing the system to evolve as requirements change overtime.
database, software, and system maintenance
34
database manipulation involves _________ and _______.
querying, updating.
34
Retrieving the transcript- a list of all courses and grades- of 'Smith' (in university database example in slides) is an example of a ________.
query
34
T/F: Listing the prequisities of the 'database' course (in university database example in slides) is an example of a query.
true
34
Changing the class of 'Smith' to sophomore (in the university database example in slides) is an example of a (query/update).
update
34
T/F: Creating a new section for the 'Database' course for this semester (in university database example in slides) is an example of a query.
false, update
34
Entering a grade of 'A' for 'Smith' in the 'Database' section of last semester (in university database example in slides) is an example of a (query/update).
update
34
insulation between programs and data is a one of the main characteristics of ___________.
the database approach to data management.
34
T/F: A self-describing nature of a database system is one of the main characteristics of the database approach.
true
34
T/F: Program-data independence is not one the main characteristics of the database approach to data management.
false, it is.
34
the insulation between programs and data is called
Program-data independence
35
T/F: Program-data independence allows changing data structures and storage organization without having to change the DBMS access programs.
true
36
T/F: There exists no database systems without a need for meta-data.
false, some newer systems such as a few NOSQL systems need no meta-data, they store the data definition within its structure making it self describing.
37
A DBMS ________ stores the description of a particular database. (e.g. data structures, types, and constraints.)
catalog
38
the description that the DBMS catalog stores is called
meta-data
39
T/F: The DBMS catalog allows the DBMS software to work with different database applications.
true.
40
T/F: Data Abstraction is one of the main characterstistics of the database approach.
true
41
A data model is used to hide storage details and present the users with a conceptual view of the database.
data abstraction
42
T/F: Programs refer to the data model constructs rather than data storage details in data abstraction.
true
43
T/F: Support of multiple views of the data is one of the main characteristics of the database approach.
true
44
T/F: In a database approach, Each user may see a different view of the database, which describes ONLY the data of interest to that user.
true
45
T/F: Sharing of data and multi-user transaction processing is one of the main characteristics of the database approach.
true
46
In a database approach, a set of ____ users are allowed to retrieve from and to update the database.
concurrent
47
__________ within the DBMS guarantees that each transcation is correctly executed or aborted.
concurreny control
48
_________ subsystem ensures each completed transaction has its effect permanently recorded in the database.
recovery
49
______ is a major part of database applications. this allows hundeds of concurrent transactions to execute per second.
OLTP
50
Database Users can be divided into those who ___________ and those who ___________.
those who actually use and control the database content, and those who design, develop and maintain database applications
51
T/F: Those who design and develop the DBMS software and related tools, and the computer systems are called actors on the scene
false, workers behind the scene
52
Those who actually use and control the database content, and design, develop and maintain database applications are called
Actors on the Scene
53
Actors on the Scene include the Database _________, and Database __________.
adminstrators, designers
54
(Database administrators/Database Designers) Responsible for authorizing access to the database, for coordinating and monitoring its use, acquiring software and hardware resources, controlling its use and monitoring efficiency of operations.
Databse administrators
55
(Database administrators/Database Designers) Responsible to define the content, the structure, the constraints, and functions or transactions against the database. They must communicate with the end-users and understand their needs.
database designers
56
they use the data for queries, reports, and some of them update the database content.
end-users
57
End-users can be catagorized into: ________, , ___________, _________, and ________.
casual, naive (or parametric), sophisticated, stand-alone.
58
(casual/naive or parametric) end users access database occasionally when needed, typically middle- or high-level managers.
casual
59
(casual/naive or parametric) end users make up a large section of the end-user population.
naive or parametric
60
(casual/naive or parametric) end users use previously well-defined functions in the form of "canned transcations" against the database.
naive or parametric
61
users of mobile apps mostly fall in the category of (casual/naive or parametric) end users.
naive or parametric
62
T/F: Bank-tellers or reservation clerks are parametric users who do this activity for an entire shift of operations.
true
63
(Sophisticated/Stand-alone) end users include business analysts, scientists, engineers, and others thoroughly familiar with the DBMS capabilities.
sophisticated end users
64
T/F: Many Stand-Alone end users use tools in the form of software packages that work closely with the stored database, in order to implement their own applications to meet their complex requirements
false, sophisticated end users.
65
(Sophisticated/Stand-alone) end users Mostly maintain personal databases using ready-to-use packaged applications.
Stand-Alone
66
T/F: An example of a Stand-Alone End user is the user of a tax program that creates its own internal database.
true
67
T/F: An Example of a Sophisticated end-user is a user that maintains a database of personal photos and videos.
false, Stand-Alone.
68
List 3 points: When not to use a DBMS?
- When a DBMS may be unnecessary - When no DBMS may suffice - When a DBMS may be infeasible - Main inhibitors (costs) of using a DBMS
69
T/F: System Analysts and Application Developers, Application Programmers, Business Analysts are examples of actors behind the scene.
false, actors on the scene.
70
T/F: System Analysts understand the user requirements of naïve *AND* sophisticated users and design applications including canned transactions to meet those requirements.
true
71
T/F: DBMS System Designers and Implementors, Tool Developers, Operators and Maintenance Personnel are examples of actors behind the scene.
true

IS230 (13 decks)

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