Sem 2- (6 week 1)

Question 1

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.

Answer 1

Database.

Question 2

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.

Answer 2

A database program—a spreadsheet program works only with small amounts of data.

Question 3

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.

Answer 3

A single database with data from multiple sources.

Question 4

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.

Answer 4

An interaction between a user and other applications.

Question 5

What is considered the central part of a database which contains the data for each record?
  A report. 
  A query. 
  A form. 
  A table.

Answer 5

A table.

Question 6

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.

Answer 6

Use a pre-designed Template.

Question 7

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

Answer 7

Use related tables

Question 8

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

Answer 8

Fields

Question 9

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.

Answer 9

A query.

Question 10

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.

Answer 10

Right-click on the record and select “Primary Key.”

Question 11

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.

Answer 11

The amount of data you have stored on lists becomes too difficult to manage.

Question 12

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.

Answer 12

Design view is where you create and maintain fields that contain the data.

Question 13

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.

Answer 13

The dates will sort by birth year, month,day.

Question 14

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

Answer 14

A search engine

Question 15

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).

Answer 15

In rows (records) and columns (fields).

Question 16

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

Answer 16

use a wizard

Question 17

Which of the following is not a data type?
  number 
  style 
  date 
  text

Answer 17

style

Question 18

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

Answer 18

clicking on the Record icon from the Home menu

Question 19

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

Answer 19

in the table

Question 20

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

Answer 20

a form

Question 21

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

Answer 21

using design view; using a wizard; and entering data directly into a table

Question 22

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.

Answer 22

They provide a way to format and print the data that exists in a table.

Question 23

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.

Answer 23

It contains the data for each record.

Question 24

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

Answer 24

Open a Blank Database

Question 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

Answer 25

a large number

Question 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.

Answer 26

Data is entered into different data fields and stored in a table.

Question 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.

Answer 27

Click the drop-down arrow and select the field’s data type from the choices in the drop-down menu.

Question 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.

Answer 28

Field names must be unique, concise, and descriptive within a table.

Question 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.

Answer 29

The Design view is where you create and maintain fields that contain the data.

Question 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

Answer 30

Price and Quantity

Question 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

Answer 31

using professionalism in our communications and when using their stored data

Question 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.

Answer 32

Communication is important when servicing and marketing to customers and vendors.

Question 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.

Answer 33

Whole-customer marketing considers future sales and customer service.

Question 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.

Answer 34

Customers seem to know when data is being used to actively promote a company’s business.

Question 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.

Answer 35

Because the focus centers around the needs of the individual at all levels.

Question 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.

Answer 36

The text fields will sort by the first letter of the last name.

Question 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.

Answer 37

Click the drop-down arrow and select the field’s data type from the choices in the drop-down menu.

Question 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.

Answer 38

The query should show information based on values that you specify.

Question 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.

Answer 39

Size and Quantity.

Question 40

Which of the following is NOT easily produced by Microsoft Access? 
  A table. 
  A Customer List. 
  A formal report. 
  An Address List.

Answer 40

A formal report.

Question 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.

Answer 41

A Query.

Question 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.

Answer 42

A primary key.

Question 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.

Answer 43

A Relational database.

Question 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.

Answer 44

Click the drop-down arrow and select the field’s data type from the choices in the drop-down menu.

Question 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.

Answer 45

A Filter.

Question 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

Answer 46

A template

Question 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.

Answer 47

Gathering and tracking the unique data.

Question 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.

Answer 48

A relational link.

Question 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.

Answer 49

A Field name must be unique, concise and descriptive within a table.

Question 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.

Answer 50

The Datasheet View is where you enter and maintain records that contain the data.

Question 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.

Answer 51

They need to utilize their data for management and marketing purposes.

Question 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.

Answer 52

The database is built and recorded with a unique, specific purpose.

Question 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.

Answer 53

They will have specific criteria that relates directly to their department interest.

Question 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.

Answer 54

Excel can present, sort and filter data on a table.

Question 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.

Answer 55

They are the database structure.

Question 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

Answer 56

Fields

Question 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?

Answer 57

when does it will be gathered?

Question 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.

Answer 58

The numbers will sort by highest number last.

Question 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.

Answer 59

To make it easy to search, extract data from, and reference information.

Question 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.

Answer 60

A form.

Question 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.

Answer 61

A Checkbox.

Question 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.

Answer 62

Activities performed to use knowledge, skills, tools and equipment to ensure the precise and successful completion of a new database.

Question 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.

Answer 63

Fields

Question 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.

Answer 64

Field Footers.

Question 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.

Answer 65

Data Field and Data Type.

Question 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.

Answer 66

A Filter.

Question 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.

Answer 67

Select tables, specific queries, images and reports.

Question 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).

Answer 68

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).

Question 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.

Answer 69

The plan addresses capacity planning, configuration and migration.

Question 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.

Answer 70

These concerns are security, troubleshooting, backup and data recovery.