Capítulo 2 Cierto o Falso

Question 1

Users may access the DBMS or indirectly through application programs.

Accepted Answer

true

Question 2

The database is processed by the DBMS.

Accepted Answer

true

Question 3

A database contains four main elements: user data, application programs, metadata, and indexes.

Accepted Answer

false

Answer

true

Question 4

Today, most databases represent user data as trees of data.

Accepted Answer

false

Answer

true

Question 5

In a relation, the columns of the relation contain records for particular entities in the business environment, and the rows of the relation contain fields or attributes.

Accepted Answer

false

Answer

true

Question 6

In a relation, the columns of the relation contain fields or attributes, and the rows of the relation contain records for particular entities in the business environment.

Accepted Answer

true

Question 7

Most DBMS products store the metadata in the form of tables.

Accepted Answer

true

Question 8

System tables contain the user's data.

Accepted Answer

false

Answer

true

Question 9

Developers have a special set of tools for querying metadata that is separate from the query tools for user's data.

Accepted Answer

false

Answer

true

Question 10

Overhead data is a synonym for metadata.

Accepted Answer

false

Answer

true

Question 11

Overhead data is composed primarily of indexes.

Accepted Answer

true

Question 12

Indexes and linked lists are both types of overhead data.

Accepted Answer

true

Question 13

Overhead data contains types of data structures that can improve the performance and accessibility of the database.

Accepted Answer

true

Question 14

Indexes are beneficial for search operations, but at the cost of slowing down sorting operations.

Accepted Answer

false

Answer

true

Question 15

Indexes should be created for every field in a relation, even if they are not currently needed, to support future uses of the data.

Accepted Answer

false

Answer

true

Question 16

Application metadata is used to store the structure of some application components in the database.

Accepted Answer

true

Question 17

Although all DBMS products do not support application components, all DBMS products that do support application components store the structure of those components in application metadata.

Accepted Answer

false

Answer

true

Question 18

While users can not access the application metadata directly, database developers often must directly access application metadata to create database application programs.

Accepted Answer

false

Answer

true

Question 19

The design tool subsystem of the DBMS is responsible for processing the application components.

Accepted Answer

false

Answer

true

Question 20

The design tools subsystem of the DBMS can facilitate the design of a database, but does not have tools to help in actually implementing the design.

Accepted Answer

false

Answer

true

Question 21

If a DBMS includes a programming language or an interface to a programming language, it is considered to be part of the design tool subsystem of the DBMS.

Accepted Answer

true

Question 22

If a DBMS includes a programming language or an interface to a programming language, it is considered to be part of the design tool subsystem of the DBMS.

Accepted Answer

true

Question 23

The run-time subsystem of the DBMS processes the application components.

Accepted Answer

true

Question 24

The DBMS engine acts as an intermediary between the other DBMS components and the database data.

Accepted Answer

true

Question 25

The DBMS engine receives requests from the run-time subsystem and the design tools subsystem and translates them into commands for the operating system to read and write data on physical media.

Accepted Answer

true

Question 26

To retrieve data from the database, the run-time subsystem instructs the operating system to read data from the physical media.

Accepted Answer

false

Answer

true

Question 27

The DBMS engine is involved in transaction management.

Accepted Answer

true

Question 28

The run-time subsystem is responsible for locking, and backup and recovery within the database.

Accepted Answer

false

Answer

true

Question 29

The database schema is a component of the DBMS engine.

Accepted Answer

false

Answer

true

Question 30

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

Accepted Answer

true

Question 31

A database schema is a set of values that a column can have.

Accepted Answer

false

Answer

true

Question 32

A domain includes the physical format of an attribute and its uniqueness.

Accepted Answer

true

Question 33

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

Accepted Answer

true

Question 34

Business rules can always be enforced in the DBMS if the database is properly designed.

Accepted Answer

false

Answer

true

Question 35

Some DBMS products use “stored procedures” to enforce business rules.

Accepted Answer

true

Question 36

Once a database schema has been designed, the next step in creating a database is to define the relationships.

Accepted Answer

false

Answer

true

Question 37

One disadvantage of declaring a relationship between two tables to the DBMS is that whenever those two tables are used in a form, query, or report the relationship must be declared again.

Accepted Answer

false

Answer

true

Question 38

Identifiers that have no meaning to the users but are created only so that each row in a table will be uniquely identifiable to the DBMS are called foreign keys.

Accepted Answer

false

Answer

true

Question 39

While most DBMS products support creating queries, few actually store the query as part of the application.

Accepted Answer

false

Answer

true

Question 40

A criterion query is a query that has been constructed to accept criteria values at run-time.

Accepted Answer

false

Answer

true

Question 41

A report can be used to enter data into the database as well as display data from the database.

Accepted Answer

false

Answer

true

Question 42

Reports usually have a more complex structure than forms.

Accepted Answer

true

Question 43

Menus can be used to control user access to forms, reports, and programs.

Accepted Answer

true

Question 44

Menus can make application components more accessible to users, but at the cost of losing control over the users’ activities.

Accepted Answer

false

Answer

true

Question 45

Database application programs must be written using a language that is specific to the DBMS.

Accepted Answer

false

Answer

true

Question 46

Predefined program interfaces allow database application programs written in standard programming languages to interact with the DBMS.

Accepted Answer

true

Question 47

Top-down development proceeds from the need to develop a specific system.

Accepted Answer

false

Answer

true

Question 48

Studying the strategic goals of the organization and the information requirements necessary to achieve those goals is characteristic of top-down development.

Accepted Answer

true

Question 49

Top-down development tends to produce useful systems more quickly than bottom-up development.

Accepted Answer

false

Answer

true

Question 50

Bottom-up development produces systems with a global perspective requiring fewer modifications as additional systems are built.

Accepted Answer

false

Answer

true

Question 51

Typically, users can clearly express their needs to the database developer.

Accepted Answer

false

Answer

true

Question 52

Typically,  database developers will start with the outputs that the users desire and work backward to infer the data model.

Accepted Answer

true

Question 53

Development of multi-user databases, such as workgroup and organizational databases, is simplified because the developer has more potential sources for information.

Accepted Answer

true

Question 54

Development of multi-user databases is especially difficult when the system is so large that no single user has a model of the complete structure.

Accepted Answer

true

	Erstellt von Angel Perez vor mehr als 8 Jahre

Nächster

Capítulo 2 Cierto o Falso

Beschreibung

Zusammenfassung der Ressource

Frage 1

Frage 2

Frage 3

Frage 4

Frage 5

Frage 6

Frage 7

Frage 8

Frage 9

Frage 10

Frage 11

Frage 12

Frage 13

Frage 14

Frage 15

Frage 16

Frage 17

Frage 18

Frage 19

Frage 20

Frage 21

Frage 22

Frage 23

Frage 24

Frage 25

Frage 26

Frage 27

Frage 28

Frage 29

Frage 30

Frage 31

Frage 32

Frage 33

Frage 34

Frage 35

Frage 36

Frage 37

Frage 38

Frage 39

Frage 40

Frage 41

Frage 42

Frage 43

Frage 44

Frage 45

Frage 46

Frage 47

Frage 48

Frage 49

Frage 50

Frage 51

Frage 52

Frage 53

Frage 54

ähnlicher Inhalt