Business Information B Final

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)

A Database Administrator needs to calculate the current and future capacity needs of the database system. Which calculation BELOW is required to determine capacity?

An interaction between a user and other applications

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?

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

A Field Name is a simple feature of a database. Which answer MOST ACCURATELY describes the proper design of a Field Name?

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

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?

BIOS

A set of computer instructions that control input and output operations

The query should show information based on values that you specify

A simple feature of a database is a Select Query. Which answer MOST ACCURATELY describes how a Select Query should function?

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

A simple feature of a database is to display a Field Name. Which answer MOST ACCURATELY describes how a Field Name should be designed?

Excel can present, sort and filter data on a table

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?

system software

A system that is designed to support applications software from behind the scenes rather than to directly produce an output of value to the user is called?

Database program

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?

Sub-assembly

An assembled part that is a part of a larger assembly

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

As a Database Administrator, how would you MOST LIKELY define the management of your project development?

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

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?

The plan addresses capacity planning, configuration and migration

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?

These concerns are security, troubleshooting, backup and data recovery

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?

C

As the new Database Administrator, you have successfully overseen the installation of the new database hardware and software systems at your company. Which of these best describe ongoing system concerns you should address? A.obsolescence, troubleshooting, and data recovery B.security, control power cost, and data recognition C.security, troubleshooting, and data recovery D.security, outsourcing, and data transfers

Create a query to display purchase information based on a specific generator's kilowatt value

Ava has a large inventory of electric generators in a database table. Her boss asked her to create a table of 100 to 500 kilowatt generators that can also be used during freezing weather. How can Ava use this table to create a promotion for their customers?

Perfective Maintenance

Changes made to a system to add new features or to improve performance

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

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?

A

Cooper created a product information database for his organization. Which of the following statements about the fundamental structure of that database is true? A. It can be modified as needed. B. It cannot be changed once data has been entered. C. It automatically adapts to the type of data entered. D. Its structure depends on whether the data is textual or numeric.

Single database with data from multiple sources

Danita is confused about how a data warehouse is designed. Which of the following BEST describes a data warehouse?

Data mining detects which offers are most valued by customers

Data mining is commonly used by retailers to increase sale to existing customers. Which statement MOST ACCURATELY explains how retail data might be used?

A Checkbox

Data types are important in constructing an effective database. What shortcut can be used to indicate a Yes/No field?

Gathering and tracking the unique data

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?

Corrective Maintenance

Fixing bugs and computing errors that are not detected when new software was installed

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

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?

when will it be gathered?

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?

A primary key

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?

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

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.

Open a Blank Database

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?

Preventative Maintenance

Is routine care you give to erase the chance of system failure and elongate use

Replace and retest

Levi is using the Universal Troubleshooting Process to try to figure out the issues he is have with his personal computer. Levi has completed the first and second step in the process, what are the 3rd and 4th steps he will need to take.

Preventive Maintenance

Makes system changes to reduce the chance of future system failure

D

Mia needs to sort her senior class report in descending order by seniors' last names. Which of the following is the BEST example of a sort in descending order? A. Adams, Davis, Cockrell, Brown B. Brown, Adams, Cockrell, Davis C. Adams, Brown, Cockrell, Davis D. Davis, Cockrell, Brown, Adams

A filter

Microsoft Access uses which function to easily produce a quick temporary list based on choosing a particular piece of data?

Adaptive Maintenance

Modifying existing functions or adding new functionality to accommodate changes in the business or operating environment

They need to utilize their data for management and marketing purposes

Of the following answers, what BEST describes why a business needs a comprehensive DBMS that allows people to update and administer data?

use a wizard

Of the three methods for creating a table, which one is the EASIEST method?

clicking on the Record icon from the Home menu

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?

Database-creation software

Rachel uses a software at work that allow her to organize and manage large amounts of data that needs to be viewed quickly. This software can also be tied to other software allowing the manipulation of large amounts of data used for producing reports and documents. Which software is Rachel using?

A relational link

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?

Adaptive maintenance

Robert plans on modifying the existing functions and add new functionality in his organization to accommodate the changes in procedures and policies. Which category of maintenance will Robert be using?

Improves quality of application

Roger, technician for a retail corporation just completed upgrading all the computers in the Human Resources department. Before Roger can document that the upgrade is completed he is required retest each computer. What would be the benefit of retesting?

A

Short face-to-face meetings are best for which of these purposes? A.conveying sensitive or important information B.making a detailed business presentation C.providing important reminders D.conveying the latest news about the organization

Applications software

Software that helps a user perform a desired task

Boot process

Starting up a computer from a halted or powered down condition

C

Suppose Ahmad is a manager who is in the process of choosing goals for his team and determining what strategies they will use and which resources will be needed for a project. Which of these functions best describes these actions? A. leading B. organizing C. planning D. staffing

A

Suppose LaTisha creates a database for her book club. She should enter the field names and data types into which of these? A. Design View B. Datasheet View C. A Macro D. A layout

A short text

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?

Price and quantity

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?

Birth year, month, day.

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?

Fields

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?

Use related tables

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?

In rows (records) and columns (fields)

Tables contain data (bits or pieces of information) about one subject. How are these tables arranged?

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

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 type from the choices in the drop-down menu

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?

They are the database structure

Understanding the interactive needs of your application is important. How to we refer to the building blocks of a database?

A search engine

We routinely use databases everyday, often without thinking about it. Which of the following is the BEST example of a common database?

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

What are the three methods for creating a table?

Table

What is considered the central part of a database which contains the data for each record?

style

What is not a data type?

Right-click on the record and select Primary Key

What is the EASIEST way to designate a primary key in its field?

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

What is the function of Reports?

A relational database

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?

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

When a new business uses data to track company products, which statement BEST reflects how information is ultimately stored?

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

When a new business uses stored data to sell company products, which statement BEST reflects how customers feel about this direct marketing?

B

When modifying, importing, or exporting an information database, which of these is a potential consequence of deleting a field? A.There is a risk of corrupting the file. B.There is a risk of losing data. C.The file size becomes too small. D.The file can take a long time to run

Select tables, specific queries, images and reports

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.

A form

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?

Data field and data type

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?

Fields

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

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?

Field footers

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?

using professionalism in our communications and when using their stored data

When you talk about the whole customer, which of the following BEST describes how they will be treated?

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

When you think about building a database, which statement BEST describes the reason database fields are defined by data types?

in the table

When your data is entered, where does ALL of the data end up?

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

Which answer MOST ACCURATELY describes how the Design View functions?

The Datasheet View is where you create and maintain data fields and data types

Which answer MOST ACCURATELY describes the purpose of the Datasheet View?

It contains data for each record

Which of the following BEST describes why a table is considered a central part of a database?

Multiple databases with data from one or more sources

Which of the following best describes a data warehouse?

A formal report

Which of the following is NOT easily produced by Microsoft Access?

A form

Which of the following is made up of controls, such as text boxes, buttons, document tabs, and drop-down?

C

Which of these best describes projects? A. Projects are open-ended. B. Projects are fixed and are permanent in nature. C. Projects have a unique purpose. D. Projects work through one channel of communication.

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

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?

B

Which of these is a guideline project managers should follow when communicating with teams through e-mail? A.Always reply to all the people to whom the initial message was sent. B.Limit the e-mail to one main subject and send a separate e-mail if needed for other topics. C.The body of an email should be formal and written with paragraphs. D.Do not spend time thinking about what to write in the subject line.

Information technology equipment

Which one is a group of products that include devices and have a primary function related to the collection, transfer, storage, data processing, control, display, and computation.

Applications software

Which program below is a software that is used to help users solve particular computing problems?

Whole-customer marketing considers future sales and customer service.

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?

Problem

Which term best describes a matter or situation regarded as unwelcome or harmful and needing to be dealt with and overcome.

B

Which type of software is best for storing information from thousands of online sales including information about the products sold, customer data, and payment type? A.PDF reader. B.Database. C.Word processor. D.Presentation.

Queries are more long-term in that they can be saved and accessed again later

While mining for data, you find you need to rearrange the order of your information. What is a MAJOR advantage to using a Query Wizard instead of Filtering?

Database

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?

A filter

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?

Size and quantity

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?

A Query

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?

Use a pre-designed Template

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?

The numbers will sort by highest number last

You're 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 text fields will sort by the first letter of the last name

You're 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?

A template

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 filter

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?