Sem 2- (6 week 1) Flashcards
1
Q
Yelena needs to create a place to store information from thousands of online sales. She wants to include information about the product, customer, and payment type. Which type of software would BEST suit her needs? PDF reader. Word processing. Database. Presentation.
A
Database.
2
Q
Alfonso has hundreds of data points and wants to use software that will allow him to easily manipulate the data. Should he use a database or spreadsheet program?
A database program—a spreadsheet program works only with small amounts of data.
A database program—it is the easiest program for using formulas.
A spreadsheet program—a database program works only with small amounts of data
A spreadsheet program—it is the easiest program for using queries.
A
A database program—a spreadsheet program works only with small amounts of data.
3
Q
Danita is confused about how a data warehouse is designed. Which of the following BEST describes a data warehouse?
A folder of multiple databases.
A single database with data from a single source.
A single database with data from multiple sources.
Multiple databases with data from a single source.
A
A single database with data from multiple sources.
4
Q
A Database Management Systems is an application that allows for interactions. When used along with a database it is called a Database Management System (DBMS). Which of the following BEST describe those interactions?
An interaction between a user and other applications.
An interaction between a developer and other applications.
An interaction between a user and other users.
An interaction between a developer and the same application.
A
An interaction between a user and other applications.
5
Q
What is considered the central part of a database which contains the data for each record? A report. A query. A form. A table.
A
A table.
6
Q
You want to store events, members, and inventories for the New Horizon Candle Company and you need to collect the information into a single database. What is the EASIEST function available in MS Access to begin collecting data quickly? Create a Blank Database. Use a pre-designed Template. Design a Query for each category. Add new records to their spreadsheet.
A
Use a pre-designed Template.
7
Q
Suppose you started a new job recently. While you were completing your employee information forms online, you noticed that you must enter the same information several times. What function in MS Access might help your company eliminate the need to enter duplicate data? Use multiple tables Use repeating records Use different fields Use related tables
A
Use related tables
8
Q
Suppose you are going to store medical records for your patients and you need to be consistent in logging the important pieces of data or information for each patient. Your database structure needs to include which basic element? Marking Key Fields Text Elements Blocks
A
Fields
9
Q
You've been assigned to build databases for your Spanish Club and you want a easy way to find the day every single member joined the club.. What is the best function in MS Access for you to use to produce the information quickly? A table. A query. A record. A filter.
A
A query.
10
Q
What is the EASIEST way to designate a primary key in its field?
Double-click on the record and select “Primary Key.”
Right-click on the record and select “Primary Key.”
Right-click on the “Primary Key and select the record.
Select “Primary Key” and then Right-click on the record.
A
Right-click on the record and select “Primary Key.”
11
Q
Which of these describes the best way to know when it is time to move your data from other software (like Word or Excel) to a database?
The amount of fields you have stored on lists becomes too difficult to manage.
The amount of tables you have stored on lists becomes too difficult to manage.
The amount of folders you have stored on lists becomes too difficult to manage.
The amount of data you have stored on lists becomes too difficult to manage.
A
The amount of data you have stored on lists becomes too difficult to manage.
12
Q
In MS Access, which of the following statements is the MOST correct?
Design view is where you create and maintain fields that contain the data.
Design view is the screen on which you actually enter the data into those fields.
Datasheet view is the screen on which you actually enter the fields into those data.
Datasheet view is where you create and maintain fields that contain the data.
A
Design view is where you create and maintain fields that contain the data.
13
Q
Suppose you are creating a new Contact List database. When adding the Birthday field, you are defining the field as a date field. Which of these methods will the records be sorted by?
The dates will sort by birth day.
The dates will sort by birth month.
The dates will sort by month, day and year.
The dates will sort by birth year, month,day.
A
The dates will sort by birth year, month,day.
14
Q
We routinely use databases everyday, often without thinking about it. Which of the following is the BEST example of a common database? A video game A local newspaper A search engine A text message
A
A search engine
15
Q
Tables contain data (bits or pieces of information) about one subject. How are these tables arranged? In forms (records) and queries (fields). In forms (columns) and queries (rows) In rows (records) and columns (fields). In rows (fields) and columns (records).
A
In rows (records) and columns (fields).
16
Q
Of the three methods for creating a table, which one is the EASIEST method? enter data into a table use the design view use the datastore view use a wizard
A
use a wizard
17
Q
Which of the following is not a data type? number style date text
A
style
18
Q
Once you have entered the first record, you can add a new record. There are three ways to start the new record. Which of the following is not one of those ways?
clicking on the New icon from the Home menu
clicking the forward arrow to the right of the Record Tracker
clicking in the column next to New icon in the first column of the table
clicking on the Record icon from the Home menu
A
clicking on the Record icon from the Home menu
19
Q
When your data is entered, where does ALL of the data end up? in the primary listing in the table in a form in a file
A
in the table
20
Q
Which of the following is made up of controls, such as text boxes, buttons, document tabs, and drop-down? a report a form a table a datasheet
A
a form
21
Q
What are the three methods for creating a table?
using entry view; using a wizard; and entering data directly into a table
using design view; using a builder; and entering data directly into a table
using design view; using a wizard; and entering data directly into a report
using design view; using a wizard; and entering data directly into a table
A
using design view; using a wizard; and entering data directly into a table
22
Q
What is the function of Reports?
They provide a way to create the data that will be entered into a table.
They provide a way to format and print the data that exists in a table.
They provide a way to format and print the data that exists in a form.
They provide a way to format and print the data that exists in a datasheet.
A
They provide a way to format and print the data that exists in a table.
23
Q
Which of the following BEST describes why a table is considered a central part of a database?
It contains the record for each record.
It contains the number of records available.
It contains the data types for certain records.
It contains the data for each record.
A
It contains the data for each record.
24
Q
In the "First Look" video, you saw the creation of a new database. What was the first step taken after the MS Access application was opened? Open a New Table Open a New Record Open a Blank Table Open a Blank Database
A
Open a Blank Database
25
```
Suppose that you are creating a new Contact List database. When adding the phone number field, what is the BEST choice of Data Types to use prior to entering data into the datasheet?
an autonumber
a number
a short text
a large number
```
a large number
26
When a new business uses data to track company products, which statement BEST reflects how information is ultimately stored?
Data is entered into different data types and stored in a table.
Data is entered into different data fields and stored in a table.
Data is entered into a report and stored in a table.
Data is entered into different data blocks and stored in a table.
Data is entered into different data fields and stored in a table.
27
Thinking back to the "First Look" video, when building a database in the Design View our Data Fields need to have defined Data Types. Which of the following statements BEST describes choosing a Data Type in the designated column for an individual record?
Click the up arrow and select the field’s data type from the choices in the drop-down menu.
Click the drop-down arrow and select the field’s data type from the choices in the drop-down menu.
Click the drop-down arrow and select the field’s data type from the choices in the selector.
Click the drop-down arrow and select the field’s data structure from the choices in the drop-down menu.
Click the drop-down arrow and select the field’s data type from the choices in the drop-down menu.
28
A simple feature of a database is to display a Field Name. Which answer MOST ACCURATELY describes how a Field Name should be designed?
Field names must be simple within a table.
Field names must be short and consistent within a table.
Field names must be common, concise, and functional within a table.
Field names must be unique, concise, and descriptive within a table.
Field names must be unique, concise, and descriptive within a table.
29
Which answer MOST ACCURATELY describes how the Design View functions?
The Design view is where you create and maintain fields that contain the data.
The Design view is where you create and maintain records that contain the data.
The Design view is where you enter and maintain records that contain the data.
The Design view is where you create and maintain data that are contained the fields.
The Design view is where you create and maintain fields that contain the data.
30
Suppose that you take a job working for a local auto parts store. They ask you to build a new database using MS Access. Each of the parts are unique and have Brand names, Manufacturer part numbers, Weight, and Dimensions so you included these in the record
You're still not sure what additional information you may need to include. Which of these is the BEST two pieces of data that you might include in the record?
Field and Quantity
Field and Text
Price and Quantity
Place and Price
Price and Quantity
31
When you talk about the whole customer, which of the following BEST describes how they will be treated?
using professionalism to make them feel good about your company
using professionalism in our online systems
using professionalism in our communications and when using their stored data
using professional communications when responding to product complaints
using professionalism in our communications and when using their stored data
32
Communication must be simple and concise, specific and coherent, thorough and polite. Which of the following statements would be the MOST valid in todays business environment?
Communication is important when dealing with nasty customer complaints.
Communication is important when dealing with minor product defect.
Communication is important when servicing and marketing to customers and vendors.
Communication is important when suggesting new products for the customer.
Communication is important when servicing and marketing to customers and vendors.
33
Which statement provides the BEST understanding of why whole-customer marketing allows you to get much more out of your customers than just their initial business?
Whole-customer marketing considers both current sales and customer service.
Whole-customer marketing considers any potential legal actions.
Whole-customer marketing considers future sales and customer service.
Whole-customer marketing considers both future stock prices and company reputation.
Whole-customer marketing considers future sales and customer service.
34
When a new business uses stored data to sell company products, which statement BEST reflects how customers feel about this direct marketing?
Customers seem to know when data is being used to actively promote a company’s business.
Customers feel important when data is used to sell company products.
Customers don't seem to care when data is being used to actively promote a company’s business.
Customers have negative feelings when data is used to sell company products.
Customers seem to know when data is being used to actively promote a company’s business.
35
As a company looks more closely at business practices and focuses on customer connections, which of the following MOST ACCURATELY describes why companies make this change in focus?
Because the focus centers around the making the product better.
Because the focus centers around employee and corporate goals.
Because the focus centers around keeping company networks secure and private.
Because the focus centers around the needs of the individual at all levels.
Because the focus centers around the needs of the individual at all levels.
36
Your creating a new Customer List database. When adding the Last Name field, you defining the field as that short text field because you know the record will sort by which method?
The text fields will sort by the first decimal of the text field.
The text fields will sort by the first letter of the customer's title.
The text fields will sort by the last letter of the last name.
The text fields will sort by the first letter of the last name.
The text fields will sort by the first letter of the last name.
37
Thinking about when building a database adding defined Data Types. Which of the following statements BEST describes the choosing of a Data Type in the designated column for an individual record?
Click the up arrow and select the field’s data type from the choices in the drop-down menu.
Click the drop-down arrow and select the field’s data structure from the choices in the drop-down menu.
Click the drop-down arrow and select the field’s data type from the choices in the selector.
Click the drop-down arrow and select the field’s data type from the choices in the drop-down menu.
Click the drop-down arrow and select the field’s data type from the choices in the drop-down menu.
38
A simple feature of a database is a Select Query. Which answer MOST ACCURATELY describes how a Select Query should function?
The query should show information based on values that you specify.
The query should display information based on data form that you specify.
The query should add data fields based on values that you specify.
The query should show information based on size of the table being used.
The query should show information based on values that you specify.
39
You take a job working for a local fashion boutique. They ask you to build a new database using MS Access. Each of the clothing is unique and have Brand names, Manufacturer ID numbers, Color and Price. You're still not sure what additional information you will need. Of the following answers, which are the BEST two pieces of data that you might include in the record?
Field and Quantity.
Size and Quantity.
Field and Text.
Place and Size.
Size and Quantity.
40
```
Which of the following is NOT easily produced by Microsoft Access?
A table.
A Customer List.
A formal report.
An Address List.
```
A formal report.
41
```
You used database information to answer the following question: How many employees have been here 10 years or longer? Which database function did you MOST LIKELY use to answer the question?
A Design.
A Question.
A Query.
A Data Field.
```
A Query.
42
```
Gina manages four sets of databases for the University; one with student name and address information, and one with student billing information, one with academic records for all students and one for current student enrollment status for the semester. She has been asked to use one common field to link the databases. What BEST identifies this particular type of field name?
A linked field type.
A common field key.
A primary key.
A connecting field type.
```
A primary key.
43
```
What type of database is a collection of data that is organized in tables from which the data can be accessed and organized in many different ways?
A Designed database.
A Primary database.
A Template database.
A Relational database.
```
A Relational database.
44
Think back to the "Step by Step" video from the Explore page. When building a database in the Datasheet View, our Data Fields need to have defined Data Types.
Which of the following statements BEST describes the process for choosing a Data Type in the designated column for an individual record?
Click the drop-down arrow and select the field’s data structure from the choices in the drop-down menu.
Click the up arrow and select the field’s data size from the choices in the drop-down menu.
Click the drop-down arrow and type in the field’s data type with the keyboard.
Click the drop-down arrow and select the field’s data type from the choices in the drop-down menu.
Click the drop-down arrow and select the field’s data type from the choices in the drop-down menu.
45
```
Microsoft Access uses which function to easily produce a quick temporary list based on choosing a particular piece of data?
A table.
A Sort.
A Filter.
An List.
```
A Filter.
46
```
You've been assigned to build databases for your Neighborhood Crime Watch and you want a quick and easy way to build them for the events, members, and criminal activity. What is the best function in MS Access for you to use?
A template
A query
A report
A record
```
A template
47
Edna has been tasked with maintaining her sorority database, which contains many elements of students' personal and academic information. Which of the following considerations will probably be MOST important to Edna if she plans to use the database for creating data queries and reports?
Developing an attractive graphic representation of the data.
Printing and checking the database weekly.
Sending out regular announcements to the students.
Gathering and tracking the unique data.
Gathering and tracking the unique data.
48
```
Raphael uses a software at work that allow his organization to manage large amounts of data that needs to be viewed quickly. His current databases require that duplicate information be placed in each table. What unique element(s) are LIKELY missing from these tables?
A preliminary link.
A relational link.
A rational link.
A connecting link.
```
A relational link.
49
A Field Name is a simple feature of a database. Which answer MOST ACCURATELY describes the proper design of a Field Name?
A Field name must be simple within a table.
A Field name must be short and consistent within a table.
A Field name must be common, concise and functional within a table.
A Field name must be unique, concise and descriptive within a table.
A Field name must be unique, concise and descriptive within a table.
50
Which answer MOST ACCURATELY describes the purpose of the Datasheet View?
The Datasheet View is where you create and maintain data fields and data types.
The Datasheet View is where you create and maintain data types.
The Datasheet View is where you enter and maintain records that contain the data.
The Datasheet View is where you create and maintain types that contain the data.
The Datasheet View is where you enter and maintain records that contain the data.
51
Of the following answers, what BEST describes why a business needs a comprehensive DBMS that allows people to update and administer data?
They need to export their data for management and marketing purposes.
They need to utilize their data for restructuring and tax reporting purposes.
They need to reorganize their data types for management and marketing purposes.
They need to utilize their data for management and marketing purposes.
They need to utilize their data for management and marketing purposes.
52
A database is a collection of recorded information that is organized in a common sense, understandable manner. Which of the following statement BEST represents how the database information will be recorded?
The database is built and modified with unique alterations.
The database is built and recorded with a general, flexible purpose.
The database is built and designed to a specific database software product.
The database is built and recorded with a unique, specific purpose.
The database is built and recorded with a unique, specific purpose.
53
Generally, database software decisions concern themselves with the data, users, usage and storage needs. Which statement is MOST ACCURATE when it comes to how other departments in a company will look at the selection process?
They will have a generalized concept of how the software should work for the whole company.
They will have overall criticisms that relates directly to their department's need to change procedures.
They will have specific criteria that relates directly to their department interest.
They will have preconceived ideas that relates to how a database should work.
They will have specific criteria that relates directly to their department interest.
54
A spreadsheet and a data table are very similar. Which of the following is an ACCURATE statement about what an Excel spreadsheet can extract from their tables?
Excel can reproduce, sort, query and filter data on a table.
Excel can present, sort and filter data on a table.
Excel can enter, sort, question and fill data on a table.
Excel can present, modify, query and narrow fields on a table.
Excel can present, sort and filter data on a table.
55
Understanding the interactive needs of your application is important. How to we refer to the building blocks of a database?
They are the database internal code.
They are the structure of interacting variables.
They are the database headings.
They are the database structure.
They are the database structure.
56
```
When you create a new database to track the customer purchases for your employer, you need to be precise in placing the location for a pieces of data or information. Your table needs to include this initial elements?
Query
Cells
Fields
Assets
```
Fields
57
Genova has been promoted to a General Manager in the Marketing department. Her first task as manager is to increase product purchases among the their clients. Genova begins creating an information gathering plan on how the Marketing department can achieve this goal. Using your understanding of data and customers, what is the LEAST important factor required to be defined in this initial plan?
what information needs to be gathered?
when does it will be gathered?
how it will be gathered?
who will get it gathered?
when does it will be gathered?
58
Your creating a new Contact List database. When adding the zip code field, you defining the field as a special number field. Which answer BEST represents what you know about how the record will sort?
The numbers will sort by lowest number last.
The numbers will sort by highest number last.
The numbers will sort by highest number first.
The numbers will sort by highest number first. and lowest number last.
The numbers will sort by highest number last.
59
When you think about building a database, which statement BEST describes the reason database fields are defined by data types?
To make it easy to search, extract data from, and reference information.
To make it easy to move your data from an existing spreadsheet.
To make it easy change once the query is built.
To make it easy to copy and paste the table into a Word document.
To make it easy to search, extract data from, and reference information.
60
```
When using a database information that contains the individual input for each data records or tracking purposes which of these is NOT considered a final product?
A report.
A query.
A form.
A table.
```
A form.
61
```
Data types are important in constructing an effective database. What shortcut can be used to indicate a Yes/No field?
A Bullet.
A Spacebar.
A Number.
A Checkbox.
```
A Checkbox.
62
As a Database Administrator, how would you MOST LIKELY define the management of your project development?
Activities performed to use knowledge, skills, tools and equipment to ensure the precise and successful completion of a new database.
Applications facilitate the process of meeting specific scope, time, cost, and quality goals of projects
A new system to increase sales, employee productivity, and monitors customer services is designed for companies.
Projects that can range in size, from large too small.
Activities performed to use knowledge, skills, tools and equipment to ensure the precise and successful completion of a new database.
63
```
When you create a new database to track the customer information for your employer. Data will be entered in multiple locations, so a precise definition of pieces of data or information is paramount. You're building tables and forms that MUST include these critical elements?
Fields.
Bullets.
Queries.
Checkboxes.
```
Fields
64
```
When you create a new database to track the toy inventory for your employer, you need to be precise in placing the location for a pieces of data or information. You decide that a form might be the best method to collect the data, which of the following is NOT a critical element of a form?
Field Footers.
Field Headings.
Data Types.
Data Fields.
```
Field Footers.
65
```
When we build databases using MS Excel or Google Sheets, we need to add indicators in the first two rows of the first column, what are they?
Data Name and Data Type.
Primary Field and Data Type.
Data Field and Data Type.
Data Number and Data Type.
```
Data Field and Data Type.
66
You take a job working for a local cell phone repair shop. They ask you to build a new database using MS Access. Each of the parts are unique and have Brand Names, Manufacturer part numbers and Weight. Your employees sell parts online and over the phone. Usually, Brand Name is the most commonly requested piece of information when looking for the correct part. Which of the following methods would MOST LIKELY be used to find that field?
A Sort.
A Primary Key.
A Find.
A Filter.
A Filter.
67
When planning to create an effective database you need to ask if the data you are sharing is key to telling the story? What types of information would that offer a clear picture of a way forward in the creation of the new database.
Select types, specific fields, images and tables.
Select sorting, generalized queries, images and reports.
Select tables, specific queries, images and reports.
Select designs, specific tabulations, imagery and reports.
Select tables, specific queries, images and reports.
68
A Database Administrator needs to calculate the current and future capacity needs of the database system. Which calculation BELOW is required to determine capacity?
Capacity is calculated as (number of machines and/or workers) × (number of hourly work shifts) × (practical and measured utilization) × (efficiency of the machines and/or workers).
Capacity is calculated as (efficiency of machines and/or workers) × (efficiency of hourly work shifts) × (practical and measured utilization) × (expandability of the machines and/or workers).
Capacity is calculated as (speed of machines and/or workers) × (speed of hourly work shifts) × (practical and measured utilization) × (expandability of the machines and/or workers).
Capacity is calculated as (number of machines and/or workers) × (number of yearly work shifts) × (practical and measured utilization) × (capacity of the machines and/or workers).
Capacity is calculated as (number of machines and/or workers) × (number of hourly work shifts) × (practical and measured utilization) × (efficiency of the machines and/or workers).
69
As the new Database Administrator at Acorn Aerospace, you are charge with planning the new database hardware and software systems. Your boss wants to know make sure that the MAJOR concerns are addressed, what are they?
The plan addresses capacity planning, configuration and mitigation.
The plan addresses capacity planning, construction and migration.
The plan addresses capacity planning, configuration and migration.
The plan addresses consistency planning, configuration and migration.
The plan addresses capacity planning, configuration and migration.
70
As the new Database Administrator, you have successfully overseen the installation of the new database hardware and software systems at Acorn Aerospace. You now need to make sure that MOST ongoing system concerns are addressed, what are they?
These concerns are security, outsourcing, backup and data transfers.
These concerns are security, troubleshooting, backup and data recovery.
These concerns are obsolescence, troubleshooting, air filtering and data recovery.
These concerns are security, control power cost, backup and data recognition.
These concerns are security, troubleshooting, backup and data recovery.
