K201 Mastery Quizzes - Exam 1

which can be used as a source for a lookup field created by the Lookup Wizard? (2 answers)

1. a query

2. a manually entered list of values

Enforcing referential integrity prevents the deletion of records in a primary tab le that are related to records in a foreign table - true or false?

true

Setting the “Allow Zero Length” property to Yes ensures that an empty string is allowed in a text field - true or false?

True

What does the Date() function return when used in a default value expression in Access?

The current date

The Lookup Wizard can only be used with text fields - true or false?

False

What type of relationship exists between a “Customers
table and an “Orders” table where each customer can place multiple orders?

One-to-Many

A foreign key can have duplicate values in a table - true or false?

True

Zach follows the instructions that show him how to create a custom Web site in his school’s learning management system. These steps that he follows are examples of the _____ component of an information system.

procedures

Which best defines a primary key

A unique identifier for each record in a table

IT and IS are essentially the same thing - true or false?

False

A ____ is a request for information from a database

query

What actions are prevented when referential integrity is enforced?

1. Updating the primary key in the primary table when related records exist

2. Adding a record to the foreign table with no related record in the primary table

3. Deleting a record in the primary table that has related record in the foreign table

What is the order of IS components from east to change to most difficult?

1. (easiest) hardware

2. software

3. data

4. procedures

5. (hardest) people

Which techniques can be used to locate a specific record in a large table? (2 answers)

1. filtering

2. sorting

What is the file extension for Access Database?

.accdb

What is the file extension for Excel

.xlsx

What is the file extension for XML?

.xml

What is the file extension for Text?

.csv or .txt

What property should be used to automatically fill in a value for a field when a new record is created?

Default Value

The “Limit To List” property restricts user input to the values specified in the Row Source of a lookup field - true or false?

True

which data type is used to store text up to 255 characters

short text

which properties constrain data entry into a field, which is important for maintaining data integrity in an Access Table? (2 answers)

1. validation rule

2. required

______ is the process of organizing data to minimize redundancy and improve data integrity

Normalization

Which actions are necessary to create a one-to-many relationship between two tables in Access? (3 answers)

1. define a primary key

2. define a foreign key

3. link the tables through the Relationships windows

A composite primary key uses two or more fields in a table to create a unique identifier - true or false?

True

Information systems are only used for processing financial data in businesses - true or false

false

Examine the image and identify the foreign key field

tblTransaction/MemberID

Which data type should be used to store monetary values?

currency

What is a primary purpose of information systems in businesses?

To facilitate the processing of data into useful information

Examine the image and identify the foreign key field

tblProduct/ProductCategoryID

The Date() function can be used to set a default value for a short text field - true or false?

False

What is the primary purpose of enforcing referential integrity in a database?

to ensure that data remains consistent across related tables

If you move a file from cloud storage to work in on a computer lab, what must you do before you log out to save your work?

Copy your file back to cloud storage

What component provides long-term storage in a computer?

Hard drive

Which operating system is commonly used in personal computers

Windows OS

What does the computer case hold?

The main components

Storing files in the cloud protects them from physical damage to your device - true or false?

True

When files are stored in the cloud, they are saved on your computer’s hard drive

False

The CPU is responsible for storing all of the computer’s data - true or false?

False

Microsoft Word is not considered an app - true or false

False

Which tasks can you perform using Windows File Explorer?

Creating and organizing folders

Google Docs is free cloud-based app that allows you to view, create, and edit documents

True

What is a computer?

An electronic device that manipulates information or data

What type of cases are most common for desktop computers today?

Tower cases

Apps are only available on mobile devices - true or false?

false

Which is considered hardware?

Monitor

What is the primary function of the monitor?

To display images, text, and other content

IUanyWare allows a person to use software that is not currently installed on their device. Which of the following platforms can use IUanyWare: (3 answers)

1. MacOS

2. Windows

3. Android

What is the primary function of the CPU?

Processing information and carrying out commands

Which type of memory is cleared when the computer is turned off?

RAM

What is one advantage of storing files in the cloud?

Files are protected from accidents, viruses, and more.

Which operating system is used by Mac computers?

Mac OS

How does a computer "see" data?

As ones and zeroes

Which file type is used to compress a collection of files into one?

.zip

Mobile apps are only for entertainment purposes - true or false?

False

What does RAM stand for?

Random Access Memory

What does the CPU stand for?

Central Processing Unit

Refrigerators can have built-in computers, although they may not perform the same functions as a desktop or laptop - true or false

true

What does it mean when something is stored in the cloud?

It is saved on Internet servers instead of on your computer.

What is IUanyWare?

A client virtualization service for accessing IU-licensed software

Where can you find apps?

On smartphones, tablets, and computers

What is the role of the OneDrive app on your personal computing device?

It automatically synchronizes files between your local device and cloud storage.

The Google Maps application on a smartphone is an example of a mobile app - true or false?

true

If you use Microsoft Word to create a document, what type of application are you using?

Word processing

What do you need in order to access files stored in the cloud?

A device with an Internet connection 

Laptops cannot be used with external monitors or keyboards - true or false?

false

The keyboard is an output device - true or false?

false

which property should be set to ensure that a Number field cannot be left blank?

required

what language is used to manage and manipulate data in a relational database

SQL

which field property determines how data are displayed in a field?

format

a lookup field can only display data from a single field in the related table - true or false?

false

What is the main purpose of a composite primary key in a table?

To uniquely identify a record using two or more fields

Automatically fills in a value for a new record.

Default Value

Sets criteria for data entered into a field.

Validation Rule

Ensures a field is not empty.

Required

Displays a message when the data entered does not meet the criteria.

Validation Text

many-to-many

Multiple records in Table A can match multiple records in Table B

One-to-Many

Each record in Table A can have multiple matching records in Table B

One-to-One

Each record in Table A matches exactly one record in Table B

A field in one table that links to a primary key in another table.

Foreign Key

A unique identifier for each record in a table.

Primary Key

An object that allows you to retrieve records that meet specific conditions.

Query

An object that stores data in a database.

Table

A foreign key can have duplicate values in a table.

true

the steps in the correct order to filter records where JoinDate is after 01/01/2024

1. open the table

2. select the JoinDate column heading

3. Specify the criteria “After 01/01/2024”

4. Apply the filter

In which of the following scenarios is the Date() function most appropriately used as a default value? (2 answers)

1. Setting the current date as a default for new orders

2. Tracking when a record was created

Which of the following are considered core components of an information system? (5 answers)

1. hardware

2. people

3. data

4. software

5. procedures

A foreign key is required to create a one-to-many relationship between two tables. - true or false?

true