MIS exam 4 study guide

DBMS stands for

Database Management System. It is a software system that is used to manage, organize, and manipulate data in a database.

RDBMS stands for

Relational Database Management System. It is a type of software system that is used to manage relational databases

Which of the following is not true about Gannt and PERT charts? Group of answer choices a. PERT stands for Program Evaluation and Review Technique. b. A Gannt charts shows project phases or activities. c. Gantt charts are better suited than PERT charts for large, complex projects. d. PERT charts also are called network diagrams.

c. Gantt charts are better suited than PERT charts for large, complex projects.

what does PMP stand for? a. pressure melting point b. position monitor portal c. Project management professional d. point measure position

c. Project management professional

To sell a product to a reseller, you should contact a/n ______. Group of answer choices a. RFP b. IT consultant c.VAR d. OEM

c. VAR (Value Added Reseller).

The purpose of the implementation phase is to ______. Group of answer choices a. consider UX and design a prototype b. determine the feasibility of a product's technical and economic aspects c. build the product and deliver it to users d. maintain and provide updates to the product after it is delivered

c. build the product and deliver it to users

Which of the following is a responsibility of a database administrator? Group of answer choices a. analyzing and measuring website traffic patterns b. collecting and analyzing evidence found in databases c. creating and maintaining the data dictionary d. interpreting a company's data from a variety of sources

c. creating and maintaining the data dictionary

A Boolean data type would be used for fields that contain ______. Group of answer choices a. letters, numeric characters, or special characters b. currency containing decimal values c. only the values Yes or No d. photos, audio, video, or a document created in another app

c. only the values Yes or No

An index helps speed up data processes by providing a ______. Group of answer choices a. filter that eliminates redundant data b. clear relationship between tables c. presorted list of values in a particular field d. listing of all objects, records, and fields

c. presorted list of values in a particular field

An input mask is a field property that ______. Group of answer choices a. is used to obscure data during entry b. ensures that all information entered is unique to that record c. provides a visual guide for users as they enter data d. is used in a form to provide each field one at a time

c. provides a visual guide for users as they enter data

Katie's company is looking to hire a CRM specialist and an SEO expert for its ______ department Group of answer choices a. data storage, retrieval, and analysis b. app development and mobile technologies c. web marketing and social media d. system development

c. web marketing and social media

jonathan is a systems analyst. He uses an RFP(request for Proposal) in order to ______. Group of answer choices a. sell his product to an organization that resells products to the public b. measure the performance of his system using benchmark tests c.obtain a quote from a vendor for products that meet specified requirements d.develop his project using an app that translates commands into code

c.obtain a quote from a vendor for products that meet specified requirements

CRM stands for

customer relationship management

Which of the following is not true about agile development? Group of answer choices a. It also is called adaptive development.I b. t incorporates flexibility in the goals and scope of the project. c. Agile projects may evolve in phases, releasing components as they are finalized. d. Agile development includes testing and user feedback only at the end of the project.

d. Agile development includes testing and user feedback only at the end of the project.

Jesse wants to use a career website. His options include all of the following, EXCEPT ______. Group of answer choices a. LinkedIn b. Dice c. Monster d. Google Cardboard

d. Google Cardboard Google Cardboard is not a career website, it is a virtual reality platform.

Braden is evaluating a new app he downloaded for ethical design principles. Which of the following might prompt him to uninstall and report the app? Group of answer choices a. The app asks permission to use his device's GPS. b. The app sends pull notifications. c. The ad content is distinguished from the app content. d. The app collects more data than is needed.

d. The app collects more data than is needed.

Which of the following is not one of the three Vs used to describe Big Data? Group of answer choices a. Volume b. Variety c. Velocity d. Visualization

d. Visualization

Emleigh uses an OLAP(Online Analytical Processing.) program in order to ______. Group of answer choices a. design new products b. perform human resources tasks c. manage inventory and fulfill orders d. analyze data to make decisions

d. analyze data to make decisions

Fallon is studying for the CompTIA A+ certification exam in order to prepare for a career in ______. Group of answer choices a. app development b. information security c. office management d. computer repair

d. computer repair

If...Then....Else is a type of ______. Group of answer choices a. variable b.prescriptive sequence c. iteration d. conditional statement

d. conditional statement

Kyle uses a CRM information system in his role in _____. Group of answer choices a. product development b. human resource c. sengineering d. customer service

d. customer service

A check digit is a number or character that is appended to or inserted in a/n ______. Group of answer choices a. multiple choice data set b. wizard c. user ID or password d. primary key value

d. primary key value

A report is the highest level in the data hierarchy. Group of answer choices TrueFalse

false

Data security rules state that all data in a database should be encrypted. Group of answer choices TrueFalse

false

Nonrelational databases offer the same kind of data consistency and validation as relational databases. Group of answer choices TrueFalse

false

JAD stands for

joint application development - is a facilitated workshop that brings together stakeholders, users, and developers to collect and define requirements for a project.

in OOP(Object-Oriented Programming) , each object in a class has the same format and can be used in the same way. Group of answer choicesTrueFalse

True

Telecommuting supporters cite that it reduces pollution and commuting time. Group of answer choices TrueFalse

True

Brian wants to make sure that his application works with other applications. He performs a/n ______ test. Group of answer choices a. integration b. acceptance c.unit d. systems

a. integration

A field that uniquely identifies a record in a table is called a ______. Group of answer choices a. primary key b. numerator c. field address d. distinctive cell

a. primary key

When you apply a filter to records in a table, ______. Group of answer choices a. some records are temporarily hidden b. you delete unnecessary or duplicate records c. the table can be merged with another table d. you save storage space and limit data redundancy

a. some records are temporarily hidden

In Access, you can use Datasheet view for ______. Group of answer choices a. structure and data entry b. setting parameters for a table's data c. data visualization techniques d, creating relationships among tables

a. structure and data entry

During fuzz testing, tools are used to test a system by ______. Group of answer choices a. using unexpected input b. attempting to enter it without authentication c. exposing security flaws unique to the development language or tool d. allowing users to work with a prerelease version

a. using unexpected input

A unique number assigned by the DBMS that provides a value that identifies the record is a/n ______ data type. Group of answer choices a. Composite Key b. AutoNumber c. Boolean d. BLOB

b. AutoNumber

Jakob is a database administrator. He wants to select an open source database so that he can customize it. He should use______. Group of answer choices a. Oracle Database b. MySQL c. Microsoft SQL Server d. Amazon's Aurora

b. MySQL

A Gantt chart is a bar chart in which the vertical and horizontal axes represent ______. Group of answer choices a. costs and benefits b. activities and time c. requirements and priorities d. sales and years

b. activities and time

Micah creates a macro in order to ______. Group of answer choices a. keep an inventory of the apps he has created b. automate a difficult task in his spreadsheet program c. analyze how well his project is performing in the market d.keep track of a schedule and budget during development

b. automate a difficult task in his spreadsheet program

Adele uses a sequence in her program to instruct the program to _____. Group of answer choices a. make decisions b. complete a set of steps in a certain order c. tell a sequence when to stop d. assign a variable that might change

b. complete a set of steps in a certain order

A repository is another term for a ______. Group of answer choices a. user-generated report b. data dictionary c. query function d. validation tool

b. data dictionary

Validation is used to ______. Group of answer choices a. authenticate user privileges b. determine whether data meets certain criteria c. analyze query results d. give additional instructions on a data entry form

b. determine whether data meets certain criteria

Jordan is a CRM specialist. Her goal is to _____. Group of answer choices a. develop web content and layouts that put her website at the top of search results b. integrate apps and data related to customer inquiries to manage a company's relationship with its customers c. plan and design apps that consider a user's reaction to an app, including efficiency, effectiveness, and ease of use d. design applications that incorporate technologies such as VR and 3D to create storytelling apps

b. integrate apps and data related to customer inquiries to manage a company's relationship with its customers

Mateo is studying for the Cisco certification exam in order to prepare for a career in ______. a. app development b. network administration c. office management d. computer repair

b. network administration

Gregor works in data analysis and uses different business intelligence systems to collect data. Which of the following is not true about the BI systems he might use? Group of answer choices a. A data lake can be used to collect raw data, such as IoT sensor data. b. A data warehouse is designed primarily for analyzing data. c. A data warehouse is a collection of both structured and unstructured data. d. A dashboard provides at-a-glance views of summarized data.

c. A data warehouse is a collection of both structured and unstructured data.

Corporations usually require more rigorous educational backgrounds for trainers than educational institutions do for instructors. True False

False

JAD is a data gathering technique in which surveys are sent and the responses are analyzed. Group of answer choicesTrueFalse

False

MariaDB is an open source RDBMS. Group of answer choices TrueFalse

False

Reduced data redundancy is an advantage of file processing systems. Group of answer choicesTrueFalse

False

When you create a program or app, you are not protected under copyright laws until you apply for them. Group of answer choices TrueFalse

False

A cognitive engineer specifies the structure, interface, and requirements of a large-scale database. Group of answer choices TrueFalse

False A cognitive engineer typically designs and analyzes cognitive systems, which can involve human-computer interaction

Fuzz testing occurs when developers attempt to break into a system or an app to pinpoint security vulnerabilities. Group of answer choices True False

False. Fuzz testing, also known as fuzzing, is a software testing technique that involves feeding random or unexpected inputs into a program to see if it crashes or produces unexpected results.

The scope of a project refers to project activities that were not planned originally. Group of answer choices TrueFalse

False. The scope of a project refers to all the work that needs to be done in order to achieve the project goals and objectives, as defined in the project plan.

With ethical design, it is recommended to collect more data than you need to authenticate users. Group of answer choices TrueFalse

False. With ethical design, it is recommended to collect only the minimum amount of data necessary to authenticate users, and to be transparent about how this data will be used and protected.

A query must include all the fields in a table. Group of answer choices TrueFalse

False. A query does not have to include all the fields in a table.

The RedHat certification would be best suited for someone going into game development. Group of answer choices True False

False. The RedHat certification is focused on Linux operating systems and system administration, and is not directly related to game development.

What does OLTP stand for?

OLTP (Online Transaction Processing) is a type of database processing that involves real-time transactions example -online banking systems, airline reservation systems, and retail point-of-sale (POS) systems.

Ethical design principles state that ads should be clearly distinguished from app content. Group of answer choices TrueFalse

True. Ethical design principles recommend that ads should be clearly distinguished from app content to avoid misleading or confusing users.

A data lake is a collection of both structured and unstructured data. Group of answer choices TrueFalse

True

A query combines data from one or more tables. Group of answer choices TrueFalse

True

Charts, diagrams, reports, and program files are examples of deliverables. Group of answer choices True or False

True

Documents and spreadsheet files are stored as unrelated objects in a file system. Group of answer choicesTrueFalse

True

Fields other than the primary key can be indexed. Group of answer choices True False

True

Monster is an example of a career website. Group of answer choices TrueFalse

True

Operational feasibility measures how well the product will work and whether it will meet the requirements of the users. Group of answer choices TrueFalse

True

Proponents of offshoring argue that consumers benefit from the reduced cost of goods. True False

True

Telecommuting refers to working from home. True False

True

An example of UX is ______. Group of answer choices a. A designer takes into account how the user with interact with a program. b. A cross-platform app is created and sold. c. A project's features are extended beyond its original scope. d. An organization wants to improve its information system.

a. A designer takes into account how the user with interact with a program.

Louis refers to his DBMS's log to see ______. Group of answer choices a. a list of activities that modified the contents of the database b.the record of users and their privileges c.the status of backups of the database d. a map of database objects by relationship

a. a list of activities that modified the contents of the database

A pull notification is sent in response to ______. Group of answer choices a. a user's actions or request b. the release of a new app feature c. a game booster becoming available d. an app's need to use the device's GPS

a. a user's actions or request

Mary adds a foreign key to one table that ______. Group of answer choices a. contains data from the primary key in another table b. is related to a field from another database c.provides a translation method for data d.includes instructions for decryption

a. contains data from the primary key in another table

A compiler is a program that ______. Group of answer choices a. converts an entire source program into machine language before executing it b. enables programmers to share and comment on code c. uses multiple programming tools in one environment d. implements objects in a program

a. converts an entire source program into machine language before executing it

A prototype is created during the ______ phase. Group of answer choices a. design b. implementation c.planning d. analysis

a. design

UX goals might include the ______ of a project. Group of answer choices a. efficiency, effectiveness, and ease of use b. profitability and scalability c. timeliness, user profile, and scope d. security requirements and concerns

a. efficiency, effectiveness, and ease of use

A CAE information system aids in the development and testing of product designs. Group of answer choicesTrueFalse

true

A VAR is used to provide IT consulting to a small business. Group of answer choices TrueFalse

true

A sandbox is an environment that allows software developers to test their programs. Group of answer choices TrueFalse

true

A systems test verifies that all programs in an application work together properly. Group of answer choicesTrueFalse

true

A table can have more than one foreign key from other tables. Group of answer choices True False

true

Charts and maps are examples of data visualization. Group of answer choices TrueFalse

true

Monster is an example of a career website. Group of answer choicesTrueFalse

true

Often, blockchains are stored across nodes on a peer-to-peer network. Group of answer choices TrueFalse

ture

What does UX stand for?

user experience