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