CBIS Database
Which of the following sets of characteristics specifically apply to relational databases? More than one answer may be correct.
- A relational database organizes data in tables composed of records or objects (the rows), and fields (the columns). - Data tables in a relational database are linked by the fields they have in common
What is the purpose of an SQL statement?
Answer questions about the database
Where could you click to switch to the Design view?
View
In the datasheet view of a relational database (such as Microsoft Access), a row of information is called a ___ .
record
The primary characteristic of a relational database is that it ______.
stores and allows access to data objects that are related to one another Reason: A relational database structures data and create relationships between objects. The data may be stored and accessed in different ways.
Which of the following sets of characteristics specifically apply to relational databases?
- Data tables in a relational database are linked by the fields they have in common. - A relational database organizes data in tables composed of records or objects (the rows), and fields (the columns).
Which of the following statements correctly describes referential integrity? More than one answer may be correct.
- For referential integrity to exist, data on both sides of the table relationship must be present. - Referential integrity applies to data quality within the structure of a relational database.
Which statement explains the difference between a database and a database management system (DBMS)?
A DBMS is a software program designed to organize and administer databases.
What element of a database field specifies the data in a field such as text, numeric, or date/time?
Data Type
Which statement most accurately describes the value of data integrity to an organization?
Databases and database management system (DBMS) with a high level of data integrity enable more efficient data maintenance in support of organizational goals.
Which statement best explains why traditional file systems have certain issues?
Each file is independent of another file in a traditional system.
Which of the following are examples of data objects that a relational database management system (RDBMS) may include? More than one answer may be correct.
Names of customers and records of when merchandise was returned Addresses of the company's wholesalers and the number of items in a company's inventory
A mid-sized independent hardware store has recently merged with a large national chain. The local owners have long used a reliable database to manage inventory. Their database has been essential in balancing orders for seasonal merchandise with the problem of limited shelf space. The merger will soon entail managing many more types of data, as the national chain has approved lists of suppliers, precise requirements for recording transactions, specific human resources procedures, and more. Which statement best summarizes what the local managers will be able to do for the first time when they start using the parent company's database management system (DBMS)?
The managers will be able to create, edit, and store data in a secure manner across all data types required by the parent company. Reason: Because a DBMS allows management and manipulation of data in databases, the owners will have access to organized information supplied by the parent company for their use.
Relational database management systems (RDBMS) have a variety of tools that can be used to execute/run queries. One of these query tools is the ability to execute/run action queries. Which of the following are common types of action queries? More than one answer may be correct.
Update query Delete query Append query
Data integrity is increased when ______.
data are centralized
A database management system (DBMS) is a computer program that is used to
help organize the data found in a database
In contrast to computerized systems, traditional file management systems can create issues with
organization, repetition, and lack of consistency
In contrast to computerized systems, traditional file management systems can create issues with ______.
organization, repetition, and lack of consistency
To search a database for information, create a
query
From the following list, select all of the examples of a relationship that an entity-relationship diagram (ERD) could be used to describe.
- Products a customer has ordered - The employees who report to a specific manager in an organizational chart - The courses a student is taking
