Llena blanco Cap 1 y 2

Description

Yes you can!
Angel  Perez
Quiz by Angel Perez, updated more than 1 year ago
Angel  Perez
Created by Angel Perez over 7 years ago
10
1

Resource summary

Question 1

Question
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.
Answer
  • database management system

Question 2

Question
A single-user database that is used by only one person at a time is called a(n) [blank_start]personal[blank_end] database.
Answer
  • personal

Question 3

Question
A database that is used by more than one person at a time is called a(n) [blank_start]multi-user[blank_end] database.
Answer
  • multi-user

Question 4

Question
[blank_start]Organizational[blank_end] databases were the first applications of database technology.
Answer
  • Organizational

Question 5

Question
A(n) [blank_start]workgroup[blank_end] database is characterized by having 25 or fewer concurrent users and 100 megabytes or less data.
Answer
  • workgroup

Question 6

Question
In database processing systems, the data is directly accessed only by the [blank_start]database management system[blank_end].
Answer
  • database management system

Question 7

Question
In database application processing systems, the user interacts directly with the [blank_start]database application programs[blank_end].
Answer
  • database application programs

Question 8

Question
The first business information systems stored groups of records in separate files and were called [blank_start]file-processing systems[blank_end].
Answer
  • file-processing systems

Question 9

Question
The most serious problem with data duplication concerns [blank_start]data integrity[blank_end].
Answer
  • data integrity

Question 10

Question
A collection of data has [blank_start]integrity[blank_end] if it is logically consistent.
Answer
  • integrity

Question 11

Question
In file-processing systems, the [blank_start]physical format[blank_end] of files and records are part of the application code.
Answer
  • physical format

Question 12

Question
A(n) [blank_start]database[blank_end] is a self-describing collection of integrated records.
Answer
  • database

Question 13

Question
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.
Answer
  • metadata

Question 14

Question
In the standard data hierarchy, a byte, or character, is composed of [blank_start]bits[blank_end] .
Answer
  • bits

Question 15

Question
In the standard data hierarchy, a field is composed of [blank_start]bytes[blank_end] .
Answer
  • bytes

Question 16

Question
In the standard data hierarchy, a record is composed of [blank_start]fields[blank_end] .
Answer
  • fields

Question 17

Question
In the standard data hierarchy, a file is composed of [blank_start]records[blank_end] .
Answer
  • records

Question 18

Question
A(n) [blank_start]index[blank_end] is used to represent relationships among the data and to improve the performance of database applications.
Answer
  • index

Question 19

Question
When the structure of a form or report is part of the database it is called [blank_start]application metadata[blank_end] .
Answer
  • application metadata

Question 20

Question
The database is a(n) [blank_start]dynamic[blank_end] model because businesses change.
Answer
  • dynamic

Question 21

Question
[blank_start]Transactions[blank_end] are representations of events that must be processed against the database.
Answer
  • Transactions

Question 22

Question
A database is a model of the [blank_start]users’[blank_end] model or view of the business.
Answer
  • users’

Question 23

Question
The [blank_start]relational[blank_end] database model stores data as tables, with rows and columns.
Answer
  • relational

Question 24

Question
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.
Answer
  • normalization

Question 25

Question
Originally, it was thought that the relational model would allow [blank_start]users[blank_end] to obtain their own information from databases.
Answer
  • users

Question 26

Question
One impact of the movement of database technology from mainframes to microcomputers was the dramatic improvement in DBMS [blank_start]user interfaces[blank_end] .
Answer
  • user interfaces

Question 27

Question
The use of multiple CPUs in processing database applications in LAN-based multi-user database architecture produced greater [blank_start]performance[blank_end] .
Answer
  • performance

Question 28

Question
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.
Answer
  • client-server database architecture

Question 29

Question
Of the two types of LAN-based multi-user database processing, [blank_start]file-sharing architecture[blank_end] is the simpler and less robust.
Answer
  • file-sharing architecture

Question 30

Question
A(n) [blank_start]distributed[blank_end] database is logically integrated but physically located in more than one place.
Answer
  • distributed

Question 31

Question
Object-oriented database systems developed to handle the structures processed by [blank_start]object-oriented programming[blank_end] .
Answer
  • object-oriented programming

Question 32

Question
The database is processed by the [blank_start]Database Management System[blank_end] , which is used by both users and developers.
Answer
  • Database Management System

Question 33

Question
Today, most databases represent user data in [blank_start]relations[blank_end] , which are tables of data.
Answer
  • relations

Question 34

Question
In a table of users’ data, the columns contain [blank_start]fields[blank_end].
Answer
  • fields

Question 35

Question
The process of [blank_start]normalization[blank_end] is used to change poorly structured tables into well-structured ones.
Answer
  • normalization

Question 36

Question
Most DBMS products store metadata in tables, sometimes called [blank_start]system tables[blank_end] .
Answer
  • system tables

Question 37

Question
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.
Answer
  • developers

Question 38

Question
A type of database data that consists primarily of indexes is called [blank_start]overhead data[blank_end] .
Answer
  • overhead data

Question 39

Question
Overhead data typically includes indexes and sometimes [blank_start]linked lists[blank_end] .
Answer
  • linked lists

Question 40

Question
Indexes are useful for [blank_start]sorting[blank_end] and search operations.
Answer
  • sorting

Question 41

Question
The structure and format of user forms, reports, and other application components are stored in the database as [blank_start]application metadata[blank_end] .
Answer
  • application metadata

Question 42

Question
The [blank_start]design tools[blank_end] subsystem contains tools to facilitate the creation of the database.
Answer
  • design tools

Question 43

Question
The [blank_start]run-time[blank_end] subsystem processes the application components created using the design tools
Answer
  • run-time

Question 44

Question
The DBMS engine is the intermediary between the other DBMS components and the [blank_start]data[blank_end] .
Answer
  • data

Question 45

Question
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.
Answer
  • operating system

Question 46

Question
A database [blank_start]schema[blank_end] defines a database’s structure – its tables, relationships, domains, and business rules.
Answer
  • schema

Question 47

Question
A database schema is a(n) [blank_start]design[blank_end] .
Answer
  • design

Question 48

Question
A(n) [blank_start]domain[blank_end] is a set of values that a column may have.
Answer
  • domain

Question 49

Question
[blank_start]Business rules[blank_end] are restrictions on the business’s activities that need to be reflected in the database and database applications.
Answer
  • Business rules

Question 50

Question
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.
Answer
  • foreign key

Question 51

Question
[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.
Answer
  • Surrogate keys

Question 52

Question
Queries can be expressed to the database using the data access language called [blank_start]SQL[blank_end] .
Answer
  • SQL

Question 53

Question
QBE, which stands for [blank_start]query by example[blank_end] , is a means of expressing a query to the database.
Answer
  • query by example

Question 54

Question
Queries can be [blank_start]parameterized[blank_end] , meaning that they are constructed to accept a criteria value at the time they are run.
Answer
  • parameterized

Question 55

Question
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.
Answer
  • query by form

Question 56

Question
A(n) [blank_start]report[blank_end] is a formatted display of data.
Answer
  • report

Question 57

Question
[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.
Answer
  • Menus
Show full summary Hide full summary

Similar

Characters in "King Lear"
eleanor.gregory
Romeo and Juliet essay
Tambo234
Chemistry C1
Chloe Winn
Themes in Macbeth
annasc0tt
Cell structure F211 OCR AS Biology
helen.rebecca
med chem 2 final exam
lola_smily
Science Unit 1 flashcards
bamoscato
Why did the Cold War begin?
n.mcdonald
Heartburn
mahmoud eladl
(YOUR EVENT)
Shelby Smith
Salem does not remember
Salma Moustafa