BCIS 3610 UNT Exam 2 Questions and Answers, Exams of Nursing

Download BCIS 3610 UNT Exam 2 Questions and Answers and more Exams Nursing in PDF only on Docsity!

BCIS 3610 UNT Exam 2 questions well

answered already passed

Tables - correct answer ✔✔In Microsoft Access, Data are stored in __________________. Query - correct answer ✔✔In Microsoft Access, a _________________ is a question you ask about data stored in a database. Foreign Key - correct answer ✔✔A field that is defined as a primary key in one table is defined as a ___________ in a related Table. Keep Invalid data from being entered into a table - correct answer ✔✔The main reason to enforce referential integrity in Access is to __________________. True - correct answer ✔✔A spreadsheet can be used to store data if the structure of a list is simple False - correct answer ✔✔The purpose of a database is to keep track of things that involve a single theme. True - correct answer ✔✔A database is a self-describing collection of integrated records. False - correct answer ✔✔A database is best described as a collection of unrelated tables. False - correct answer ✔✔A group of similar rows or records in a table is called a field. True - correct answer ✔✔Special data that describes the structure of a database is called metadata. Cloud - correct answer ✔✔Elastic Leasing of pooled computer resources over the internet is known as the ______________.

A. Control of Data Location - correct answer ✔✔Which of the following is not a benefit of using the cloud. A. Control of Data location B. Small capital requirements C. Speedy Development D. Known Cost Structure IEEE - correct answer ✔✔____________ IS a committee that creates and publishes protocols and standards used by virtually every network. SaaS (Software as a service) - correct answer ✔✔iCloud and Office 365 are examples of ________________. CDN - correct answer ✔✔A system of hardware and software stores user data in many different geographical locations and makes data available on demand is known as ___________________. VPN - correct answer ✔✔Creates the appearance of private point-to-point connections by using tunnels over the internet. D. Why do companies outsource their IS operations - correct answer ✔✔All of the following are questions addressed in chapter 7 - Processes, organizations and IS, except? A. What are the basic types of processing B. How can IS improve process quality C. What are the elements of an ERP system. D. Why do companies outsource their IS operations D. Usually informal - correct answer ✔✔All of the following descrive characteristicss of structured business processes except: A. Support Operational and structured managerial decisions and activities. B. Standardized

C. Process Structure changes Slowly D. Usually informal Data are isolated in separated information systems - correct answer ✔✔You have a problem known as "Information Silos" when __________________. Enterprise - correct answer ✔✔_____________ Processes span an organization and support activities in multiple departments. CRM - correct answer ✔✔Managing all the interactions with the customer from lead generation to customer service is the purpose of CRM. D. Sales Forecase - correct answer ✔✔All of the following are major components of CRM applications except: A. Solicitation B. Lead tracking C. Relationship management D. Sales Forecase ERP - correct answer ✔✔_________ refers to a swite of applications, database, and set of inherent processes for consolidating business operations into a single, consistent, computing platform. D. Lower IT Cost - correct answer ✔✔Which of the following is not a likely benefit of ERP. A. Inventory reduction B. Lead-time reduction C. Improved customer service D. Lower IT cost. SAP - correct answer ✔✔______________ Is the largest ERP vendor.

False - correct answer ✔✔T/F. In most organizations, ERP systems are accepted with little or no resistance from employees. Social Media - correct answer ✔✔Use of IT to support sharing content among networks if users is referred to as ____________. Sponsors - correct answer ✔✔Social media _____________ are companies and organizations that choose to support a presence on social media sites. Application Providers - correct answer ✔✔Facebook, Twitter and LinkedIn are examples of social media _____________. Advertisements - correct answer ✔✔Most Social media application providers earn revenues through _______________. Sales and Marketing - correct answer ✔✔Companies can advance organizational strategies using SMIS in two ways - 1. Defender of belief and 2. Seekers of truth. Which of the following business activities is most likely to use the former 1. Crowdsourcing - correct answer ✔✔A dynamic process of employing users to participate in product design is referred to as _______________. Social Capital - correct answer ✔✔____________ adds value through information, influence, and personal reinforcement. Purchasing user names from SM sites - correct answer ✔✔All of the following are ways to increase social capital except: A. Asking for a favor B. Frequent interactions with users C. Connecting to those with more assets. D. Purchasing user names from SM sites.

Hypersocial - correct answer ✔✔A __________ organization is an organization that uses social media to transform its interactions with customers, employees, and partners into mutually satisfying relationships with them and their communities. Leave it - correct answer ✔✔If a company found a reasonable criticism of its products on social networking site, it should _____________. True - correct answer ✔✔A key is a column or group of columns that identifies a unique row in a table. False - correct answer ✔✔Each table in a database must have two or more primary keys. False - correct answer ✔✔Metadata refers to entities of a database that users want to process. False - correct answer ✔✔The format of metadata depends on the software product that is processing the database. True - correct answer ✔✔A database management system (DBMS) is a program used to create, process, and administer a database. False - correct answer ✔✔A DBMS and database mean the same thing and are synonymous terms that can be used interchangeably. True - correct answer ✔✔MySQL is an open source DBMS product that is license-free for most database applications. False - correct answer ✔✔Most organizations develop their own DBMS software in order to obtain control over data. False - correct answer ✔✔A user does not need user account credentials to access and process a database.

True - correct answer ✔✔A database application is a collection of forms, reports, queries, and application programs that serves as an intermediary between users and database data. C) lists involve data with multiple themes - correct answer ✔✔A database is required instead of a spreadsheet when ________. A) professionals need to keep a track of things B) a user requires control over data C) lists involve data with multiple themes D) one or more users want to access the same data C) byte - correct answer ✔✔Which of the following is the smallest data element in a database? A) field B) record C) byte D) file C) bytes - correct answer ✔✔In a database, ________ are grouped into columns. A) fields B) records C) bytes D) files D) fields - correct answer ✔✔The columns in a database are called ________. A) records B) tables C) files D) fields A) records - correct answer ✔✔The rows in a database are called ________.

A) records B) tables C) files D) fields B) files - correct answer ✔✔The tables that appear in a database are known as ________. A) records B) files C) fields D) attributes B) column or group of columns that identifies a unique row in a table - correct answer ✔✔A primary key used in a database is a ________. A) group of rows that are formed to identify a unique table or file B) column or group of columns that identifies a unique row in a table C) character or byte that represents fields or columns D) group of tables or files formed to identify a unique field or row A) primary key - correct answer ✔✔Albert creates a relational database to store employee performance statistics. He stores each employee's data in independent rows and creates a column named "Employee Number" to assign unique numbers to each employee. This column is referred to as a(n) ________. A) primary key B) identifier C) foreign key D) functionally dependent record B) foreign keys - correct answer ✔✔Columns that are keys to different tables than the ones in which they reside are called ________. A) attributes B) foreign keys

C) primary keys D) internal records C) data that describe data - correct answer ✔✔Metadata are ________. A) code used for server-side processing B) error logs of databases C) data that describe data D) encrypted data transmissions B) DBMS - correct answer ✔✔A(n) ________ is a program used to create, process, and administer a database. A) operating system B) DBMS C) information system D) data mart D) Access - correct answer ✔✔Which of the following is an example of a database management system? A) MS Excel B) BigData C) NoSQL D) Access A) MySQL - correct answer ✔✔Identify the open source DBMS product among the following. A) MySQL B) DB C) Access D) Oracle Database B) It is license-free for most applications. - correct answer ✔✔Which of the following is true of MySQL?

A) It is offered by Oracle. B) It is license-free for most applications. C) It is a closed-source database product. D) It is yet to be widely adopted. D) processing the database - correct answer ✔✔When you modify or delete data present in a database, you are ________. A) creating a new database B) forming a data model C) simplifying the data structure D) processing the database C) SQL - correct answer ✔✔Which of the following is an international standard language for processing a database? A) Cassandra B) DB C) SQL D) MS Access A) creating and staffing the DBA function - correct answer ✔✔Which of the following is a developmental task of database administration? A) creating and staffing the DBA function B) monitoring backup procedures C) conducting training for users D) managing configuration changes in systems A) development - correct answer ✔✔Identify the type of task that a database administrator is performing when validating the data model to be used in a database management system. A) development B) adaptation

C) backup and recovery D) operation D) operational - correct answer ✔✔The database administrator of an organization constantly manages the processing rights and responsibilities of employees. This is an example of a(n) ________ task. A) development B) recovery C) adaptation D) operational D) managing configuration changes in systems - correct answer ✔✔Which of the following database administration tasks is related to adaptation? A) monitoring backup procedures B) conducting training for users C) monitoring database performance D) managing configuration changes in systems A) database application - correct answer ✔✔A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data. A) database application B) database design C) data field D) data model B) Forms - correct answer ✔✔________ are used by users to read, insert, modify, and delete data in a database. A) Reports B) Forms C) Queries D) DBMS

D) query - correct answer ✔✔Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year. She should use a ________ to obtain the information that she wants from the database. A) report B) data model C) database administrative function D) query C) They are written in object-oriented languages such as C++ and VisualBasic. - correct answer ✔✔Which of the following is true of traditional database application programs? A) Application forms, reports, and queries are displayed and processed using a browser. B) All of the application logic is contained in a program on the database server. C) They are written in object-oriented languages such as C++ and VisualBasic. D) They are thin-client applications that need not be pre-installed on the users' computers. D) thick applications that need to be installed on users' computers - correct answer ✔✔Traditional database applications programs are ________. A) browser-based and display dynamic content B) written in languages such as html5 and JavaScript C) entirely dependent on the database server for application logic D) thick applications that need to be installed on users' computers