BCIS 4620 Exam 1
The hierarchical data model was developed in the _____.
1960s
The relational data model was developed in the _____.
1970s
A(n) _____ is the equivalent of a field in a file system.
Attribute
A _____ key can be described as a minimal superkey, a superkey without any unnecessary attributes.
Candidate
Which of the following types of HDFS nodes acts as the interface between the user application and the HDFS?
Client node
A(n) _______ enables a database administrator to describe schema components.
DDL
_____ exists when different versions of the same data appear in different places.
Data inconsistency
An operational database is sometimes referred to as an enterprise database.
False
Business rules apply to businesses and government groups, but not to other types of organizations such as religious groups or research laboratories.
False
Character data can contain any character or symbol intended for mathematical manipulation.
False
Data and information are essentially the same thing.
False
Data anomaly is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions.
False
Database programming languages receive all application requests and translate them into the complex operations required to fulfill those requests.
False
Field refers to a collection of related records.
False
The SELECT operator yields a vertical subset of a table.
False
The idea of determination is unique to the database environment.
False
The one-to-many (1:M) relationship is easily implemented in the relational model by putting the foreign key of the "1" side in the table of the "many" side as a primary key.
False
Which of the following types of HDFS nodes stores all the metadata about a file system?
Name node
The _____ data model uses the concept of inheritance.
Object-oriented
A _____ is any key that uniquely identifies each row.
Superkey
If the attribute (B) is functionally dependent on a composite key (A) but not on any subset of that composite key, the attribute (B) is fully functionally dependent on (A).
True
In an SQL-based relational database, rows in different tables are related based on common values in common attributes.
True
_____ data exist in a format that does not lend itself to processing that yields information.
Unstructured
_____ data exist in the format in which they were collected.
Unstructured
The database structure in a DBMS is stored as a _____.
collection of files
A(n) _____ is a restriction placed on the data.
constraint
_____ are normally expressed in the form of rules.
constraints
A(n) _____ database is used by an organization and supports many users across many departments.
enterprise
A noun in a business rule translates to a(n) _____ in the data model.
entity
Accurate, relevant, and timely information is the key to ____.
good decision making
A workgroup database is a(n) _____ database.
multiuser
The _____ constraint can be placed on a column to ensure that every row in the table has a value for that column.
not null
The _____ data model is said to be a semantic data model.
object-oriented
The response of the DBMS to a query is the ___________
query result set
End-user data is ______
raw facts of interest to the end user
MySQL is an example of the _____.
relational data model
A desktop database is a _____ database.
single-user
The DIFFERENCE operator subtracts one table from the other.
True
The DIVIDE operation uses one single-column table (e.g., column "a") as the divisor and one two-column table (e.g., columns "a" and "b") as the dividend.
True
The network model has structural level dependence.
True
The only way to access the data in a database is through the DBMS.
True
The practical significance of taking the logical view of a database is that it serves as a reminder of the simple file concept of data storage.
True
Today, most relational database products can be classified as object/relational.
True
You can think of a table as a persistent representation of a logical relation.
True
A(n) _____ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization.
workgroup
Each table _____ represents an attribute.
Column
_____ are important because they help to ensure data integrity.
Constraints
___ serve as the intermediary between the user and the database
DBMSs
_____ is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions.
Data integrity
Which of the following refers to the situation where different versions of the same data are stored at different places because they weren't updated consistently?
Data redundancy
The term _____ refers to an organization of components that define and regulate the collection, storage, management and use of data within a database environment.
Database system
The _____ model uses the term connectivity to label the relationship types.
Entity relationship
The _____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text.
Entity relationship
A disadvantage of the relational database management system (RDBMS) is its inability to hide the complexities of the relational model from the user.
False
An advantage of database systems is that you needn't perform frequent updates and apply latest patches.
False
An implementation-ready data model needn't necessarily contain enforceable rules to guarantee the integrity of the data.
False
Even when a good database blueprint is available, an applications programmer's view of the data should match that of the manager and the end user.
False
In a natural join, the column on which the join was made occurs twice in the new table.
False
One advantage of a database system over previous data management approaches is that the database system is considerably less complex.
False
One disadvantage of the DBMS is that it increases the risk of data security breaches.
False
Only a single attribute, not multiple attributes, can define functional dependence.
False
Structural dependence exists when it is possible to make changes in the file structure without affecting the application program's ability to access the data.
False
The DBMS reveals much of the database's internal complexity to the application programs and users.
False
The order of the rows and columns is important to the DBMS.
False
The row's range of permissible values is known as its domain.
False
When data are entered into a form and saved, they are placed in the underlying database as knowledge.
False
A _____ is a collection of related records.
File
A _____ is the primary key of one table that has been placed into another table to create a common attribute.
Foreign key
In the _____ model, each parent can have many children, but each child has only one parent.
Hierarchical
_____ is the result of revealing the meaning of raw facts.
Information
Date attributes contain calendar dates stored in a special format known as the _____ date format.
Julian
In the relational model, _____ are important because they are used to ensure that each row in a table is uniquely identifiable.
Keys
_____ is the body of information and facts about a specific subject.
Knowledge
_____ provide a description of the data characteristics and the set of relationships that link the data found within the database.
Metadata
_____ relates to the activities that make the database execute transactions more efficiently in terms of storage and access speed.
Performance tuning
_____ logic, used extensively in mathematics, provides a framework in which an assertion (statement of fact) can be verified as either true or false.
Predicate
A verb associating two nouns in a business rule translates to a(n) _____ in the data model.
Relationship
A _____ key is defined as a key that is used strictly for data retrieval purposes.
Secondary
Which of the following is true of business rules?
They can serve as a communication tool between the users and designers.
Which of the following is true of spreadsheet applications?
They enhance the user's ability to understand the data.
A data dictionary is sometimes described as "the database designer's database" because it records the design decisions about tables and their structures.
True
A data warehouse can store data derived from many sources.
True
A null is created when you press the Enter key or the Tab key to move to the next entry without making a prior entry of any kind.
True
As rare as 1:1 relationships should be, certain conditions absolutely require their use.
True
Data constitute the building blocks of information.
True
Data processing can be as simple as organizing data to reveal patterns.
True
Depending on the sophistication of the application development software, nulls can create problems when functions such as COUNT, AVERAGE, and SUM are used.
True
Each table in a relational database must have a primary key.
True
In the context of data models, an entity is a person, place, thing, or event about which data will be collected and stored.
True
Metadata describe the data characteristics and the set of relationships that links the data found within the database.
True
One disadvantage of a database system over previous data management approaches is increased costs.
True
RDBMSs enforce integrity rules automatically.
True
Relational algebra defines the theoretical way of manipulating table contents using relational operators.
True
Structure is based on the type of processing to be performed on the data.
True
A(n) _____ represents a particular type of object in the real world.
entity
The CUSTOMER table's primary key is CUS_CODE. The CUSTOMER primary key column has no null entries, and all entries are unique. This is an example of _____ integrity.
entity
A ___ is a character or group of characters that has a specific meaning
field
Referential _____ dictates that the foreign key must contain values that match the primary key in the related table, or must contain null.
integrity
The organization of data within folders in a manual file system is determined by _______.
its expected use
Data is said to be verifiable if:
the data always yields consistent results.
