Q&A Hero

Management

Q: In Microsoft Visio 2013, a group of template objects is called a stencil.
Q: In Microsoft Visio 2013, both data models and database designs are created using the Crow's Foot Database Notation template.
Q: In Microsoft Visio 2013, clicking the File command tab opens the Backstage view.
Q: Microsoft Visio 2013 can be used to create data models, but not database designs.
Q: Microsoft Visio 2013 is a component of Microsoft Office 2013.
Q: What activities take place during the component design step of the systems development life cycle (SDLC)?
Q: What are the five steps or stages of the systems development life cycle (SDLC)?
Q: How does Michael Porter define support business activities?
Q: How does Michael Porter define primary or operational business activities?
Q: Define and discuss an information system.
Q: Databases are created in a DBMS during the ________ step.
Q: Database designs are created during the ________ step.
Q: Data models are created during the ________ step.
Q: One deliverable from the requirements analysis step is a ________.
Q: User interviews are conducted during the ________ step.
Q: The classic systems analysis methodology is called the ________.
Q: Systems analysis and design is the process of ________ and ________ information systems.
Q: Information systems are used to support ________.
Q: A business process is a set of activities that transforms ________ into ________.
Q: Michael Porter includes procurement in his list of ________ activities.
Q: Michael Porter includes inbound logistics in his list of ________ activities.
Q: Information systems must be both ________ and ________ to help businesses reach their goals and objectives.
Q: A computer-based information system has ________ components.
Q: A(n) ________ is a set of components that interact to achieve some purpose or goal.
Q: One definition of ________ is knowledge derived from data.
Q: ________ is facts and numbers.
Q: Databases are created in a DBMS during the ________ step of the SDLC. A) system definition B) requirements analysis C) component design D) implementation E) systems maintenance
Q: Database designs are created during the ________ step of the SDLC. A) system definition B) requirements analysis C) component design D) implementation E) systems maintenance
Q: Data models are created during the ________ step of the SDLC. A) system definition B) requirements analysis C) component design D) implementation E) systems maintenance
Q: A deliverable from the requirements analysis step is a(n): A) user requirements document (URD). B) user requirements statement (URS). C) statement of work (SOW). D) statement of requirements (SOR). E) A and C
Q: User interviews are conducted during the ________ step of the SDLC. A) system definition B) requirements analysis C) component design D) implementation E) systems maintenance
Q: The classic systems analysis methodology is called the: A) Systems Development Life Cycle (SDLC). B) Analysis Development Life Cycle (ADLC). C) Component Development Life Cycle (CDLC). D) Information Development Life Cycle (IDLC). E) None of the above is correct.
Q: Which of the following is not included in Michael Porter's list of support activities? A) Technology management B) Customer service C) Human resources management D) Firm infrastructure management E) All of above are considered support activities.
Q: Which of the following is not included in Michael Porter's list of primary or operational activities? A) Procurement B) Inbound logistics C) Manufacturing operations D) Outbound logistics E) All of above are considered primary or operational activities.
Q: Which of the following is a component of a computer-based information system? A) Hardware B) Software C) Data D) Procedures E) All of the above
Q: Information can be defined as: A) data presented in a meaningful context. B) knowledge derived from data. C) data processed by summing, ordering, averaging, grouping, comparing or other similar operations. D) A and B E) A, B and C
Q: Data is composed of: A) facts. B) numbers. C) information. D) A and B E) A, B and C
Q: Databases are created in a DBMS during the implementation step.
Q: Database designs are created during the component design step.
Q: Data models are created during the component design step.
Q: One deliverable from the requirements analysis step is a statement of requirements (SOR).
Q: User interviews are conducted during the requirements analysis step.
Q: The classic systems analysis methodology is called the Analysis Development Life Cycle (ADLC).
Q: Systems analysis and design is the process of creating and maintaining information systems.
Q: Information systems are used to support business processes.
Q: A business process is a set of activities that transforms materials into products.
Q: Michael Porter includes manufacturing operations in his list of primary activities.
Q: Information systems must be both developed and used to help businesses reach their goals and objectives.
Q: A computer-based information system has four components.
Q: An information system is a set of components that interact to achieve some purpose or goal.
Q: One definition of information is knowledge derived from data.
Q: Data is facts and numbers.
Q: How are SQL views handled in Microsoft Access?
Q: What are SQL stored procedures and how are they used?
Q: What are SQL triggers and how are they used?
Q: Use the database below to answer the following question. GENERAL SALES DATABASE: SALESREP SalesRepNo RepName HireDate 654 Jones 01/02/1999 734 Smith 02/03/2000 345 Chen 01/25/1998 434 Johnson 11/23/1998 CUSTOMER CustNo CustName Balance SalesRepNo 9870 Winston 500 345 8590 Gonzales 350 434 7840 Harris 800 654 4870 Miles 100 345 Given that a view named CustomerSalesRepView that displays the customer name as CustomerName and the associated sales rep name as SalesRepresentativeName has been created for the GENERAL SALES DATABASE, write the SQL code to use the view to display the customer name and associated sales rep name sorted by customer name.
Q: Use the database below to answer the following question. GENERAL SALES DATABASE: SALESREP SalesRepNo RepName HireDate 654 Jones 01/02/1999 734 Smith 02/03/2000 345 Chen 01/25/1998 434 Johnson 11/23/1998 CUSTOMER CustNo CustName Balance SalesRepNo 9870 Winston 500 345 8590 Gonzales 350 434 7840 Harris 800 654 4870 Miles 100 345 Using the CUSTOMER.Balance column as the column providing the data, create a view to display the results of a computed column. Specifically, assume that all customers are required to maintain a minimum balance of 100, and use the view to display customer name and a number named BalanceOverMinimum that calculates (Balance - 100) for all customers in the GENERAL SALES DATABASE.
Q: Use the database below to answer the following question. GENERAL SALES DATABASE: SALESREP SalesRepNo RepName HireDate 654 Jones 01/02/1999 734 Smith 02/03/2000 345 Chen 01/25/1998 434 Johnson 11/23/1998 CUSTOMER CustNo CustName Balance SalesRepNo 9870 Winston 500 345 8590 Gonzales 350 434 7840 Harris 800 654 4870 Miles 100 345 Write the SQL statement to create a view named CustomerSalesRepView that displays the customer name as CustomerName and the associated sales rep name SaleRepresentativeName from the GENERAL SALES DATABASE.
Q: Use the database below to answer the following question. GENERAL SALES DATABASE: SALESREP SalesRepNo RepName HireDate 654 Jones 01/02/1999 734 Smith 02/03/2000 345 Chen 01/25/1998 434 Johnson 11/23/1998 CUSTOMER CustNo CustName Balance SalesRepNo 9870 Winston 500 345 8590 Gonzales 350 434 7840 Harris 800 654 4870 Miles 100 345 What is an SQL view, and what is it used for? Include an example based on the CUSTOMER table of the General Sales Database.
Q: Microsoft Access ________ can use previously stored view equivalent Access queries the same way an SQL SELECT statement uses SQL views.
Q: Since an SQL view is essentially a stored query, Microsoft Access ________ can be used to implement SQL view equivalents.
Q: SQL views can be used to layer ________.
Q: SQL views can be used to display the results of ________.
Q: SQL views can be used to hide table ________.
Q: The SQL statement ________ is used to delete a view from a database.
Q: The SQL statement ________ is used to modify a view.
Q: The SQL keyword ________ can be used with SELECT statements retrieving view instances to sort the results of the SELECT.
Q: SQL statements used to construct views cannot contain the ________ clause.
Q: The SQL command ________ is used to create a virtual table.
Q: SQL views are constructed from SQL ________ statements.
Q: An SQL virtual table is called a(n) ________.
Q: Microsoft Access queries: A) can use previously stored view equivalent Access queries. B) cannot use previously stored view equivalent Access queries for any purpose. C) cannot use previously stored view equivalent Access queries to hide rows. D) cannot use previously stored view equivalent Access queries to hide columns. E) cannot use previously stored view equivalent Access queries to hide complicated SQL syntax.
Q: Microsoft Access: A) supports standard SQL view statements. B) only supports SQL view statements as QBE constructions. C) can store a view equivalent Access query. D) can store a view equivalent Access query but does not provide a means to use it. E) cannot store any database object that is equivalent to an SQL view.
Q: Because SQL stored procedures allow and encourage code sharing among developers, stored procedures give database application developers the advantages of ________. A) less work B) standardized processing C) specialization among developers D) A and B E) A, B, and C
Q: Stored procedures have the advantage of ________. A) greater security B) decreased network traffic C) SQL optimized by the DBMS compiler D) code sharing E) All of the above
Q: A stored program that is attached to the database is called ________. A) a CHECK constraint B) a view C) embedded SQL D) a trigger E) a stored procedure
Q: SQL triggers are used for ________. A) validity checking B) providing default values C) updating views D) A and B E) A, B, and C
Q: SQL triggers can be used when the DBMS receives a(n) ________ request. A) INSERT B) UPDATE C) DELETE D) A and B E) A, B, and C
Q: Which of the following is an SQL trigger that Microsoft SQL Server supports? A) BEFORE B) INSTEAD OF C) AFTER D) B and C only E) A, B, and C
Q: Which of the following is an SQL trigger that Oracle supports? A) BEFORE B) INSTEAD OF C) AFTER D) B and C only E) A, B, and C
1 2 3 … 1,015

Subjects

Accounting Anthropology Archaeology Art History Banking Biology & Life Science Business Business Communication Business Development Business Ethics Business Law Chemistry Communication Computer Science Counseling Criminal Law Curriculum & Instruction Design Earth Science Economic Education Engineering Finance History & Theory Humanities Human Resource International Business Investments & Securities Journalism Law Management Marketing Medicine Medicine & Health Science Nursing Philosophy Physic Psychology Real Estate Science Social Science Sociology Special Education Speech Visual Arts