6038125
Descrição
Quiz por Angel Perez, atualizado more than 1 year ago
|
|
Criado por Angel Perez
mais de 7 anos atrás
|
|
Questão 1
Questão
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.
Responda
-
database management system
Questão 2
Questão
A single-user database that is used by only one person at a time is called a(n) [blank_start]personal[blank_end] database.
Responda
-
personal
Questão 3
Questão
A database that is used by more than one person at a time is called a(n) [blank_start]multi-user[blank_end] database.
Responda
-
multi-user
Questão 4
Questão
[blank_start]Organizational[blank_end] databases were the first applications of database technology.
Responda
-
Organizational
Questão 5
Questão
A(n) [blank_start]workgroup[blank_end] database is characterized by having 25 or fewer concurrent users and 100 megabytes or less data.
Responda
-
workgroup
Questão 6
Questão
In database processing systems, the data is directly accessed only by the [blank_start]database management system[blank_end].
Responda
-
database management system
Questão 7
Questão
In database application processing systems, the user interacts directly with the [blank_start]database application programs[blank_end].
Responda
-
database application programs
Questão 8
Questão
The first business information systems stored groups of records in separate files and were called [blank_start]file-processing systems[blank_end].
Responda
-
file-processing systems
Questão 9
Questão
The most serious problem with data duplication concerns [blank_start]data integrity[blank_end].
Responda
-
data integrity
Questão 10
Questão
A collection of data has [blank_start]integrity[blank_end] if it is logically consistent.
Responda
-
integrity
Questão 11
Questão
In file-processing systems, the [blank_start]physical format[blank_end] of files and records are part of the application code.
Responda
-
physical format
Questão 12
Questão
A(n) [blank_start]database[blank_end] is a self-describing collection of integrated records.
Responda
-
database
Questão 13
Questão
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.
Responda
-
metadata
Questão 14
Questão
In the standard data hierarchy, a byte, or character, is composed of [blank_start]bits[blank_end] .
Responda
-
bits
Questão 15
Questão
In the standard data hierarchy, a field is composed of [blank_start]bytes[blank_end] .
Responda
-
bytes
Questão 16
Questão
In the standard data hierarchy, a record is composed of [blank_start]fields[blank_end] .
Responda
-
fields
Questão 17
Questão
In the standard data hierarchy, a file is composed of [blank_start]records[blank_end] .
Responda
-
records
Questão 18
Questão
A(n) [blank_start]index[blank_end] is used to represent relationships among the data and to improve the performance of database applications.
Responda
-
index
Questão 19
Questão
When the structure of a form or report is part of the database it is called [blank_start]application metadata[blank_end] .
Responda
-
application metadata
Questão 20
Questão
The database is a(n) [blank_start]dynamic[blank_end] model because businesses change.
Responda
-
dynamic
Questão 21
Questão
[blank_start]Transactions[blank_end] are representations of events that must be processed against the database.
Responda
-
Transactions
Questão 22
Questão
A database is a model of the [blank_start]users’[blank_end] model or view of the business.
Responda
-
users’
Questão 23
Questão
The [blank_start]relational[blank_end] database model stores data as tables, with rows and columns.
Responda
-
relational
Questão 24
Questão
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.
Responda
-
normalization
Questão 25
Questão
Originally, it was thought that the relational model would allow [blank_start]users[blank_end] to obtain their own information from databases.
Responda
-
users
Questão 26
Questão
One impact of the movement of database technology from mainframes to microcomputers was the dramatic improvement in DBMS [blank_start]user interfaces[blank_end] .
Responda
-
user interfaces
Questão 27
Questão
The use of multiple CPUs in processing database applications in LAN-based multi-user database architecture produced greater [blank_start]performance[blank_end] .
Responda
-
performance
Questão 28
Questão
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.
Responda
-
client-server database architecture
Questão 29
Questão
Of the two types of LAN-based multi-user database processing, [blank_start]file-sharing architecture[blank_end] is the simpler and less robust.
Responda
-
file-sharing architecture
Questão 30
Questão
A(n) [blank_start]distributed[blank_end] database is logically integrated but physically located in more than one place.
Responda
-
distributed
Questão 31
Questão
Object-oriented database systems developed to handle the structures processed by [blank_start]object-oriented programming[blank_end] .
Responda
-
object-oriented programming
Questão 32
Questão
The database is processed by the [blank_start]Database Management System[blank_end] , which is used by both users and developers.
Responda
-
Database Management System
Questão 33
Questão
Today, most databases represent user data in [blank_start]relations[blank_end] , which are tables of data.
Responda
-
relations
Questão 34
Questão
In a table of users’ data, the columns contain [blank_start]fields[blank_end].
Responda
-
fields
Questão 35
Questão
The process of [blank_start]normalization[blank_end] is used to change poorly structured tables into well-structured ones.
Responda
-
normalization
Questão 36
Questão
Most DBMS products store metadata in tables, sometimes called [blank_start]system tables[blank_end] .
Responda
-
system tables
Questão 37
Questão
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.
Responda
-
developers
Questão 38
Questão
A type of database data that consists primarily of indexes is called [blank_start]overhead data[blank_end] .
Responda
-
overhead data
Questão 39
Questão
Overhead data typically includes indexes and sometimes [blank_start]linked lists[blank_end] .
Responda
-
linked lists
Questão 40
Questão
Indexes are useful for [blank_start]sorting[blank_end] and search operations.
Responda
-
sorting
Questão 41
Questão
The structure and format of user forms, reports, and other application components are stored in the database as [blank_start]application metadata[blank_end] .
Responda
-
application metadata
Questão 42
Questão
The [blank_start]design tools[blank_end] subsystem contains tools to facilitate the creation of the database.
Responda
-
design tools
Questão 43
Questão
The [blank_start]run-time[blank_end] subsystem processes the application components created using the design tools
Responda
-
run-time
Questão 44
Questão
The DBMS engine is the intermediary between the other DBMS components and the [blank_start]data[blank_end] .
Responda
-
data
Questão 45
Questão
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.
Responda
-
operating system
Questão 46
Questão
A database [blank_start]schema[blank_end] defines a database’s structure – its tables, relationships, domains, and business rules.
Responda
-
schema
Questão 47
Questão
A database schema is a(n) [blank_start]design[blank_end] .
Responda
-
design
Questão 48
Questão
A(n) [blank_start]domain[blank_end] is a set of values that a column may have.
Responda
-
domain
Questão 49
Questão
[blank_start]Business rules[blank_end] are restrictions on the business’s activities that need to be reflected in the database and database applications.
Responda
-
Business rules
Questão 50
Questão
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.
Responda
-
foreign key
Questão 51
Questão
[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.
Responda
-
Surrogate keys
Questão 52
Questão
Queries can be expressed to the database using the data access language called [blank_start]SQL[blank_end] .
Responda
-
SQL
Questão 53
Questão
QBE, which stands for [blank_start]query by example[blank_end] , is a means of expressing a query to the database.
Responda
-
query by example
Questão 54
Questão
Queries can be [blank_start]parameterized[blank_end] , meaning that they are constructed to accept a criteria value at the time they are run.
Responda
-
parameterized
Questão 55
Questão
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.
Responda
-
query by form
Questão 56
Questão
A(n) [blank_start]report[blank_end] is a formatted display of data.
Responda
-
report
Questão 57
Questão
[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.
Responda
-
Menus
Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.