6038125
Beschreibung
Quiz von Angel Perez, aktualisiert more than 1 year ago
|
|
Erstellt von Angel Perez
vor mehr als 7 Jahre
|
|
Frage 1
Frage
It is the job of a program called a(n) [blank_start]database management system[blank_end] to store and retrieve data in database tables.
Antworten
-
database management system
Frage 2
Frage
A single-user database that is used by only one person at a time is called a(n) [blank_start]personal[blank_end] database.
Antworten
-
personal
Frage 3
Frage
A database that is used by more than one person at a time is called a(n) [blank_start]multi-user[blank_end] database.
Antworten
-
multi-user
Frage 4
Frage
[blank_start]Organizational[blank_end] databases were the first applications of database technology.
Antworten
-
Organizational
Frage 5
Frage
A(n) [blank_start]workgroup[blank_end] database is characterized by having 25 or fewer concurrent users and 100 megabytes or less data.
Antworten
-
workgroup
Frage 6
Frage
In database processing systems, the data is directly accessed only by the [blank_start]database management system[blank_end].
Antworten
-
database management system
Frage 7
Frage
In database application processing systems, the user interacts directly with the [blank_start]database application programs[blank_end].
Antworten
-
database application programs
Frage 8
Frage
The first business information systems stored groups of records in separate files and were called [blank_start]file-processing systems[blank_end].
Antworten
-
file-processing systems
Frage 9
Frage
The most serious problem with data duplication concerns [blank_start]data integrity[blank_end].
Antworten
-
data integrity
Frage 10
Frage
A collection of data has [blank_start]integrity[blank_end] if it is logically consistent.
Antworten
-
integrity
Frage 11
Frage
In file-processing systems, the [blank_start]physical format[blank_end] of files and records are part of the application code.
Antworten
-
physical format
Frage 12
Frage
A(n) [blank_start]database[blank_end] is a self-describing collection of integrated records.
Antworten
-
database
Frage 13
Frage
The description of the structure of a database is stored in the [blank_start]metadata[blank_end] , also known as the data dictionary or the data directory.
Antworten
-
metadata
Frage 14
Frage
In the standard data hierarchy, a byte, or character, is composed of [blank_start]bits[blank_end] .
Antworten
-
bits
Frage 15
Frage
In the standard data hierarchy, a field is composed of [blank_start]bytes[blank_end] .
Antworten
-
bytes
Frage 16
Frage
In the standard data hierarchy, a record is composed of [blank_start]fields[blank_end] .
Antworten
-
fields
Frage 17
Frage
In the standard data hierarchy, a file is composed of [blank_start]records[blank_end] .
Antworten
-
records
Frage 18
Frage
A(n) [blank_start]index[blank_end] is used to represent relationships among the data and to improve the performance of database applications.
Antworten
-
index
Frage 19
Frage
When the structure of a form or report is part of the database it is called [blank_start]application metadata[blank_end] .
Antworten
-
application metadata
Frage 20
Frage
The database is a(n) [blank_start]dynamic[blank_end] model because businesses change.
Antworten
-
dynamic
Frage 21
Frage
[blank_start]Transactions[blank_end] are representations of events that must be processed against the database.
Antworten
-
Transactions
Frage 22
Frage
A database is a model of the [blank_start]users’[blank_end] model or view of the business.
Antworten
-
users’
Frage 23
Frage
The [blank_start]relational[blank_end] database model stores data as tables, with rows and columns.
Antworten
-
relational
Frage 24
Frage
In the relational model, the process of [blank_start]normalization[blank_end] is used to change an undesirable table into two or more desirable tables.
Antworten
-
normalization
Frage 25
Frage
Originally, it was thought that the relational model would allow [blank_start]users[blank_end] to obtain their own information from databases.
Antworten
-
users
Frage 26
Frage
One impact of the movement of database technology from mainframes to microcomputers was the dramatic improvement in DBMS [blank_start]user interfaces[blank_end] .
Antworten
-
user interfaces
Frage 27
Frage
The use of multiple CPUs in processing database applications in LAN-based multi-user database architecture produced greater [blank_start]performance[blank_end] .
Antworten
-
performance
Frage 28
Frage
Of the two types of LAN-based multi-user database processing, [blank_start]client-server database architecture[blank_end] is the more complex and robust.
Antworten
-
client-server database architecture
Frage 29
Frage
Of the two types of LAN-based multi-user database processing, [blank_start]file-sharing architecture[blank_end] is the simpler and less robust.
Antworten
-
file-sharing architecture
Frage 30
Frage
A(n) [blank_start]distributed[blank_end] database is logically integrated but physically located in more than one place.
Antworten
-
distributed
Frage 31
Frage
Object-oriented database systems developed to handle the structures processed by [blank_start]object-oriented programming[blank_end] .
Antworten
-
object-oriented programming
Frage 32
Frage
The database is processed by the [blank_start]Database Management System[blank_end] , which is used by both users and developers.
Antworten
-
Database Management System
Frage 33
Frage
Today, most databases represent user data in [blank_start]relations[blank_end] , which are tables of data.
Antworten
-
relations
Frage 34
Frage
In a table of users’ data, the columns contain [blank_start]fields[blank_end].
Antworten
-
fields
Frage 35
Frage
The process of [blank_start]normalization[blank_end] is used to change poorly structured tables into well-structured ones.
Antworten
-
normalization
Frage 36
Frage
Most DBMS products store metadata in tables, sometimes called [blank_start]system tables[blank_end] .
Antworten
-
system tables
Frage 37
Frage
One advantage to storing metadata in tables is that [blank_start]developers[blank_end] can use the same tools to query the metadata as they do to query the users’ data.
Antworten
-
developers
Frage 38
Frage
A type of database data that consists primarily of indexes is called [blank_start]overhead data[blank_end] .
Antworten
-
overhead data
Frage 39
Frage
Overhead data typically includes indexes and sometimes [blank_start]linked lists[blank_end] .
Antworten
-
linked lists
Frage 40
Frage
Indexes are useful for [blank_start]sorting[blank_end] and search operations.
Antworten
-
sorting
Frage 41
Frage
The structure and format of user forms, reports, and other application components are stored in the database as [blank_start]application metadata[blank_end] .
Antworten
-
application metadata
Frage 42
Frage
The [blank_start]design tools[blank_end] subsystem contains tools to facilitate the creation of the database.
Antworten
-
design tools
Frage 43
Frage
The [blank_start]run-time[blank_end] subsystem processes the application components created using the design tools
Antworten
-
run-time
Frage 44
Frage
The DBMS engine is the intermediary between the other DBMS components and the [blank_start]data[blank_end] .
Antworten
-
data
Frage 45
Frage
The DBMS engine receives requests from the other DBMS components and translates them into commands for the [blank_start]operating system[blank_end] to read or write data from the physical media.
Antworten
-
operating system
Frage 46
Frage
A database [blank_start]schema[blank_end] defines a database’s structure – its tables, relationships, domains, and business rules.
Antworten
-
schema
Frage 47
Frage
A database schema is a(n) [blank_start]design[blank_end] .
Antworten
-
design
Frage 48
Frage
A(n) [blank_start]domain[blank_end] is a set of values that a column may have.
Antworten
-
domain
Frage 49
Frage
[blank_start]Business rules[blank_end] are restrictions on the business’s activities that need to be reflected in the database and database applications.
Antworten
-
Business rules
Frage 50
Frage
A primary key from one table that is placed into another table to declare a relationship is called a(n) [blank_start]foreign key[blank_end] in the second table.
Antworten
-
foreign key
Frage 51
Frage
[blank_start]Surrogate keys[blank_end] are identifiers that are created only to allow each row in a table to be uniquely identified and have no meaning to the users.
Antworten
-
Surrogate keys
Frage 52
Frage
Queries can be expressed to the database using the data access language called [blank_start]SQL[blank_end] .
Antworten
-
SQL
Frage 53
Frage
QBE, which stands for [blank_start]query by example[blank_end] , is a means of expressing a query to the database.
Antworten
-
query by example
Frage 54
Frage
Queries can be [blank_start]parameterized[blank_end] , meaning that they are constructed to accept a criteria value at the time they are run.
Antworten
-
parameterized
Frage 55
Frage
A means of expressing a query to the database called [blank_start]query by form[blank_end] allows the user to enter query constraints on a data entry form.
Antworten
-
query by form
Frage 56
Frage
A(n) [blank_start]report[blank_end] is a formatted display of data.
Antworten
-
report
Frage 57
Frage
[blank_start]Menus[blank_end] are used to organize application components to make them more accessible to the end user and to provide control over the users’ activities.
Antworten
-
Menus
Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.