Copy and Edit

Capítulo 2 Cierto o Falso

Description

Just do it!
Angel Perez
Quiz by Angel Perez, updated more than 1 year ago
Angel Perez
Created by Angel Perez over 7 years ago
21
1
0

Resource summary

Question 1

Question
Users may access the DBMS or indirectly through application programs.
Answer
  • True
  • False

Question 2

Question
The database is processed by the DBMS.
Answer
  • True
  • False

Question 3

Question
A database contains four main elements: user data, application programs, metadata, and indexes.
Answer
  • True
  • False

Question 4

Question
Today, most databases represent user data as trees of data.
Answer
  • True
  • False

Question 5

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

Question 6

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

Question 7

Question
Most DBMS products store the metadata in the form of tables.
Answer
  • True
  • False

Question 8

Question
System tables contain the user's data.
Answer
  • True
  • False

Question 9

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

Question 10

Question
Overhead data is a synonym for metadata.
Answer
  • True
  • False

Question 11

Question
Overhead data is composed primarily of indexes.
Answer
  • True
  • False

Question 12

Question
Indexes and linked lists are both types of overhead data.
Answer
  • True
  • False

Question 13

Question
Overhead data contains types of data structures that can improve the performance and accessibility of the database.
Answer
  • True
  • False

Question 14

Question
Indexes are beneficial for search operations, but at the cost of slowing down sorting operations.
Answer
  • True
  • False

Question 15

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

Question 16

Question
Application metadata is used to store the structure of some application components in the database.
Answer
  • True
  • False

Question 17

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

Question 18

Question
While users can not access the application metadata directly, database developers often must directly access application metadata to create database application programs.
Answer
  • True
  • False

Question 19

Question
The design tool subsystem of the DBMS is responsible for processing the application components.
Answer
  • True
  • False

Question 20

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

Question 21

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

Question 22

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

Question 23

Question
The run-time subsystem of the DBMS processes the application components.
Answer
  • True
  • False

Question 24

Question
The DBMS engine acts as an intermediary between the other DBMS components and the database data.
Answer
  • True
  • False

Question 25

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

Question 26

Question
To retrieve data from the database, the run-time subsystem instructs the operating system to read data from the physical media.
Answer
  • True
  • False

Question 27

Question
The DBMS engine is involved in transaction management.
Answer
  • True
  • False

Question 28

Question
The run-time subsystem is responsible for locking, and backup and recovery within the database.
Answer
  • True
  • False

Question 29

Question
The database schema is a component of the DBMS engine.
Answer
  • True
  • False

Question 30

Question
A database schema defines a database’s structure – its tables, relationships, domains, and business rules.
Answer
  • True
  • False

Question 31

Question
A database schema is a set of values that a column can have.
Answer
  • True
  • False

Question 32

Question
A domain includes the physical format of an attribute and its uniqueness.
Answer
  • True
  • False

Question 33

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

Question 34

Question
Business rules can always be enforced in the DBMS if the database is properly designed.
Answer
  • True
  • False

Question 35

Question
Some DBMS products use “stored procedures” to enforce business rules.
Answer
  • True
  • False

Question 36

Question
Once a database schema has been designed, the next step in creating a database is to define the relationships.
Answer
  • True
  • False

Question 37

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

Question 38

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

Question 39

Question
While most DBMS products support creating queries, few actually store the query as part of the application.
Answer
  • True
  • False

Question 40

Question
A criterion query is a query that has been constructed to accept criteria values at run-time.
Answer
  • True
  • False

Question 41

Question
A report can be used to enter data into the database as well as display data from the database.
Answer
  • True
  • False

Question 42

Question
Reports usually have a more complex structure than forms.
Answer
  • True
  • False

Question 43

Question
Menus can be used to control user access to forms, reports, and programs.
Answer
  • True
  • False

Question 44

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

Question 45

Question
Database application programs must be written using a language that is specific to the DBMS.
Answer
  • True
  • False

Question 46

Question
Predefined program interfaces allow database application programs written in standard programming languages to interact with the DBMS.
Answer
  • True
  • False

Question 47

Question
Top-down development proceeds from the need to develop a specific system.
Answer
  • True
  • False

Question 48

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

Question 49

Question
Top-down development tends to produce useful systems more quickly than bottom-up development.
Answer
  • True
  • False

Question 50

Question
Bottom-up development produces systems with a global perspective requiring fewer modifications as additional systems are built.
Answer
  • True
  • False

Question 51

Question
Typically, users can clearly express their needs to the database developer.
Answer
  • True
  • False

Question 52

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

Question 53

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

Question 54

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

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

Biology: B2.1, cells and simple cell transport; B2.2, tissues, organs and organ systems
Henry Kitchen
Summer Learning Loss & How To Prevent It
philip.ellis
PRACTICA EL SPEAKING DEL FIRST
Diana GE
To Kill a Mockingbird -Analysis of Major Characters
sungiemarie
Data Types
Jacob Sedore
Examen II Salesforce Developer
Youssef Ahmani
Intake7 BIM L1
Stanley Chia
1PR101 2.test - Část 18.
Nikola Truong
SFDC App Builder 1 (151-175)
Connie Woolard
Část 4.
Gábi Krsková
AAHI_Card set 2 (Escalation criteria)
Tafe Teachers SB
Browse Library