Please enter something
Home Page Science Computer Science Databases Database Management Systems DB Chapter 1 True/False - Flashcards

DB Chapter 1 True/False – Flashcards

Ben Stevenson
8 July 2022
30 test answers

Unlock all answers in this set

Unlock answers 30
question
The purpose of a database is to help people keep track of things.
answer
T
question
A possible problem with keeping data in lists is that if you delete a row of data from a list, you may also delete some data items that you want to keep.
answer
T
question
An advantage of keeping data in lists is that if you update a data value in one row of data in a list, other occurrences of the same data item in other rows will be automatically updated as well.
answer
F
question
An advantage of keeping data in lists is that if you add a new row of data to the list, you will never have null values occurring for any data item in the row.
answer
F
question
One problem with storing duplicated data is the potential for inconsistent values.
answer
T
Unlock the answer
question
A relational database stores data in the form of lists.
answer
F
Unlock the answer
question
Usually, a database table containing both rows and columns is designed to store data for exactly two themes.
answer
F
Unlock the answer
question
By separating data into tables containing data on only one theme each, making changes to the data is simplified.
answer
T
Unlock the answer
question
SQL stands for Structural Question Language.
answer
F
Unlock the answer
question
Relational database tables are commonly combined, queried, and processed using Structured Query Language (SQL).
answer
T
Unlock the answer
question
Although users use database systems, they are not considered part of a database system.
answer
F
Unlock the answer
question
A database is a set of one or more computer programs that serves as an intermediary between the users and the database management system (DBMS).
answer
F
Unlock the answer
question
A relational database can be defined as a self-describing collection of related tables.
answer
T
Unlock the answer
question
A database is self-describing because the user maintains a record of the database structure outside the database itself.
answer
F
Unlock the answer
question
Metadata is the user data stored in the database.
answer
F
Unlock the answer
question
Most organizations create and use their own database management system (DBMS) products.
answer
F
Unlock the answer
question
The DBMS is used to create the database itself.
answer
T
Unlock the answer
question
Referential integrity constraints must be enforced by the application program.
answer
F
Unlock the answer
question
Application programs are responsible for creating, maintaining, and supporting database backup and recovery systems.
answer
F
Unlock the answer
question
The DBMS receives data update requests from the application program.
answer
T
Unlock the answer
question
In the general division of labor between database applications and the DBMS, the processing of forms is considered a DBMS task.
answer
F
Unlock the answer
question
In the general division of labor between database applications and the DBMS, the application program determines which tables need to be modified.
answer
T
Unlock the answer
question
In the general division of labor between database applications and the DBMS, the application program formats the results of a query into a report.
answer
T
Unlock the answer
question
Personal DBMS products, such as Microsoft Access, create a clear distinction between the DBMS and the database application.
answer
F
Unlock the answer
question
There is no reason for serious database developers to learn many aspects of database processing technology because DBMS products like Microsoft Access hide these aspects.
answer
F
Unlock the answer
question
Microsoft Access 2010 is a personal database that combines a DBMS with an application generator.
answer
T
Unlock the answer
question
The Microsoft Access 2010 application generator provides the ability to create and store forms, reports, and queries.
answer
T
Unlock the answer
question
Microsoft Access 2010 databases are stored using the file extension .accdb.
answer
F
Unlock the answer
question
Microsoft Access 2010 uses the Access 2003 .mdb file format as the default file format for database files.
answer
F
Unlock the answer
question
Microsoft Access 2010 uses the AutoNumber data type to create surrogate keys.
answer
T
Unlock the answer
Get an explanation on any task
Get unstuck with the help of our AI assistant in seconds
New
Get unstuck with AI assistant right now
  • Enter your topic/question
  • Receive an explanation
Pro tips to get quality response
  • Ask one question at a time
  • Enter a specific assignment topic
  • Aim at least 500 characters
Question
What is the right structure for an essay
Answer
A paragraph is a related group of sentences that develops one main idea. Each paragraph in the body of the essay should contain:
  • a topic sentence that states the main or controlling idea
  • supporting sentences to explain and develop the point you’re making
  • evidence from your reading or an example from the subject area that supports your point
  • analysis of the implication/significance/impact of the evidence finished off with a critical conclusion you have drawn from the evidence.