Angel  Perez
Quiz by , created more than 1 year ago

Yes you can!

13
1
0
No tags specified
Angel  Perez
Created by Angel Perez over 8 years ago
Close

Llena blanco Cap 1 y 2

Question 1 of 57

1

Fill the blank space to complete the text.

It is the job of a program called a(n) to store and retrieve data in database tables.

Explanation

Question 2 of 57

1

Fill the blank space to complete the text.

A single-user database that is used by only one person at a time is called a(n) database.

Explanation

Question 3 of 57

1

Fill the blank space to complete the text.

A database that is used by more than one person at a time is called a(n) database.

Explanation

Question 4 of 57

1

Fill the blank space to complete the text.

databases were the first applications of database technology.

Explanation

Question 5 of 57

1

Fill the blank space to complete the text.

A(n) database is characterized by having 25 or fewer concurrent users and 100 megabytes or less data.

Explanation

Question 6 of 57

1

Fill the blank space to complete the text.

In database processing systems, the data is directly accessed only by the .

Explanation

Question 7 of 57

1

Fill the blank space to complete the text.

In database application processing systems, the user interacts directly with the .

Explanation

Question 8 of 57

1

Fill the blank space to complete the text.

The first business information systems stored groups of records in separate files and were called .

Explanation

Question 9 of 57

1

Fill the blank space to complete the text.

The most serious problem with data duplication concerns .

Explanation

Question 10 of 57

1

Fill the blank space to complete the text.

A collection of data has if it is logically consistent.

Explanation

Question 11 of 57

1

Fill the blank space to complete the text.

In file-processing systems, the of files and records are part of the application code.

Explanation

Question 12 of 57

1

Fill the blank space to complete the text.

A(n) is a self-describing collection of integrated records.

Explanation

Question 13 of 57

1

Fill the blank space to complete the text.

The description of the structure of a database is stored in the , also known as the data dictionary or the data directory.

Explanation

Question 14 of 57

1

Fill the blank space to complete the text.

In the standard data hierarchy, a byte, or character, is composed of .

Explanation

Question 15 of 57

1

Fill the blank space to complete the text.

In the standard data hierarchy, a field is composed of .

Explanation

Question 16 of 57

1

Fill the blank space to complete the text.

In the standard data hierarchy, a record is composed of .

Explanation

Question 17 of 57

1

Fill the blank space to complete the text.

In the standard data hierarchy, a file is composed of .

Explanation

Question 18 of 57

1

Fill the blank space to complete the text.

A(n) is used to represent relationships among the data and to improve the performance of database applications.

Explanation

Question 19 of 57

1

Fill the blank space to complete the text.

When the structure of a form or report is part of the database it is called .

Explanation

Question 20 of 57

1

Fill the blank space to complete the text.

The database is a(n) model because businesses change.

Explanation

Question 21 of 57

1

Fill the blank space to complete the text.

are representations of events that must be processed against the database.

Explanation

Question 22 of 57

1

Fill the blank space to complete the text.

A database is a model of the model or view of the business.

Explanation

Question 23 of 57

1

Fill the blank space to complete the text.

The database model stores data as tables, with rows and columns.

Explanation

Question 24 of 57

1

Fill the blank space to complete the text.

In the relational model, the process of is used to change an undesirable table into two or more desirable tables.

Explanation

Question 25 of 57

1

Fill the blank space to complete the text.

Originally, it was thought that the relational model would allow to obtain their own information from databases.

Explanation

Question 26 of 57

1

Fill the blank space to complete the text.

One impact of the movement of database technology from mainframes to microcomputers was the dramatic improvement in DBMS .

Explanation

Question 27 of 57

1

Fill the blank space to complete the text.

The use of multiple CPUs in processing database applications in LAN-based multi-user database architecture produced greater .

Explanation

Question 28 of 57

1

Fill the blank space to complete the text.

Of the two types of LAN-based multi-user database processing, is the more complex and robust.

Explanation

Question 29 of 57

1

Fill the blank space to complete the text.

Of the two types of LAN-based multi-user database processing, is the simpler and less robust.

Explanation

Question 30 of 57

1

Fill the blank space to complete the text.

A(n) database is logically integrated but physically located in more than one place.

Explanation

Question 31 of 57

1

Fill the blank space to complete the text.

Object-oriented database systems developed to handle the structures processed by .

Explanation

Question 32 of 57

1

Fill the blank space to complete the text.

The database is processed by the , which is used by both users and developers.

Explanation

Question 33 of 57

1

Fill the blank space to complete the text.

Today, most databases represent user data in , which are tables of data.

Explanation

Question 34 of 57

1

Fill the blank space to complete the text.

In a table of users’ data, the columns contain .

Explanation

Question 35 of 57

1

Fill the blank space to complete the text.

The process of is used to change poorly structured tables into well-structured ones.

Explanation

Question 36 of 57

1

Fill the blank space to complete the text.

Most DBMS products store metadata in tables, sometimes called .

Explanation

Question 37 of 57

1

Fill the blank space to complete the text.

One advantage to storing metadata in tables is that can use the same tools to query the metadata as they do to query the users’ data.

Explanation

Question 38 of 57

1

Fill the blank space to complete the text.

A type of database data that consists primarily of indexes is called .

Explanation

Question 39 of 57

1

Fill the blank space to complete the text.

Overhead data typically includes indexes and sometimes .

Explanation

Question 40 of 57

1

Fill the blank space to complete the text.

Indexes are useful for and search operations.

Explanation

Question 41 of 57

1

Fill the blank space to complete the text.

The structure and format of user forms, reports, and other application components are stored in the database as .

Explanation

Question 42 of 57

1

Fill the blank space to complete the text.

The subsystem contains tools to facilitate the creation of the database.

Explanation

Question 43 of 57

1

Fill the blank space to complete the text.

The subsystem processes the application components created using the design tools

Explanation

Question 44 of 57

1

Fill the blank space to complete the text.

The DBMS engine is the intermediary between the other DBMS components and the .

Explanation

Question 45 of 57

1

Fill the blank space to complete the text.

The DBMS engine receives requests from the other DBMS components and translates them into commands for the to read or write data from the physical media.

Explanation

Question 46 of 57

1

Fill the blank space to complete the text.

A database defines a database’s structure – its tables, relationships, domains, and business rules.

Explanation

Question 47 of 57

1

Fill the blank space to complete the text.

A database schema is a(n) .

Explanation

Question 48 of 57

1

Fill the blank space to complete the text.

A(n) is a set of values that a column may have.

Explanation

Question 49 of 57

1

Fill the blank space to complete the text.

are restrictions on the business’s activities that need to be reflected in the database and database applications.

Explanation

Question 50 of 57

1

Fill the blank space to complete the text.

A primary key from one table that is placed into another table to declare a relationship is called a(n) in the second table.

Explanation

Question 51 of 57

1

Fill the blank space to complete the text.

are identifiers that are created only to allow each row in a table to be uniquely identified and have no meaning to the users.

Explanation

Question 52 of 57

1

Fill the blank space to complete the text.

Queries can be expressed to the database using the data access language called .

Explanation

Question 53 of 57

1

Fill the blank space to complete the text.

QBE, which stands for , is a means of expressing a query to the database.

Explanation

Question 54 of 57

1

Fill the blank space to complete the text.

Queries can be , meaning that they are constructed to accept a criteria value at the time they are run.

Explanation

Question 55 of 57

1

Fill the blank space to complete the text.

A means of expressing a query to the database called allows the user to enter query constraints on a data entry form.

Explanation

Question 56 of 57

1

Fill the blank space to complete the text.

A(n) is a formatted display of data.

Explanation

Question 57 of 57

1

Fill the blank space to complete the text.

are used to organize application components to make them more accessible to the end user and to provide control over the users’ activities.

Explanation