CIS105 - Chapter 11-15

Card Set Information

Author:
mportales7
ID:
83646
Filename:
CIS105 - Chapter 11-15
Updated:
2011-05-03 23:52:04
Tags:
Final Exam CIS105 Chapter
Folders:

Description:
CIS105 - Chapter 11-15
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user mportales7 on FreezingBlue Flashcards. What would you like to do?


  1. __ is concerned with risk management, confidentiality, integrity, and the availability of electronic information processed and stored on a computing system.

    A. Computer Security
    B. Internet Fraud
    C. Piracy
    D. Computer Privacy
    A. Computer Security
    (this multiple choice question has been scrambled)
  2. Computer __ may hijack information, computing processing cycles and speed, or storage space.

    A. hackers
    B. spammers
    C. firewalls
    D. worms
    A. hackers
    (this multiple choice question has been scrambled)
  3. A firewall controls the flow of data between networks by opening and closing __ for various transmission protocols.

    A. servers
    B. ports
    C. doors
    D. links
    B. ports
    (this multiple choice question has been scrambled)
  4. __, which includes viruses, worms, and spyware, are programs specifically intended to penetrate or damage a computer system without the user's knowledge.

    A. spam
    B. malware
    C. caches
    D. firewalls
    B. Malware
    (this multiple choice question has been scrambled)
  5. Any unsolicited email should be considered __.

    A. covert
    B. trivial
    C. spyware
    D. spam
    D. Spam
    (this multiple choice question has been scrambled)
  6. What type of software attempts to identify, prevent, and eliminate computer viruses and malware?

    A. virus
    B. spam
    C. anti-virus
    D. password
    C. Anti-Virus
    (this multiple choice question has been scrambled)
  7. __ typically uses a legitimate-looking email to masquerade as a legitimate business organization and gain private information, such as usernames, PIN's, passwords, and account numbers.

    A. Hacking
    B. Click Fraud
    C. Phishing
    D. Data mining
    C. Phishing
    (this multiple choice question has been scrambled)
  8. __ can be defined as the ability to keep your personal information out of public view.

    A. Privacy
    B. Hacking
    C. Integrity
    D. Data mining
    A. Privacy
    (this multiple choice question has been scrambled)
  9. The advantage to a __ is that the user does not have to fill out tedious information twice into the same web page.

    A. cookie
    B. chip
    C. virus
    D. password
    A. Cookie
    (this multiple choice question has been scrambled)
  10. __ refers to a crime in which someone wrongfully obtains and uses another person's personal information, typically for economic gain.

    A. Identity theft
    B. Identity coding
    C. Data mining
    D. Purchase scams
    A. Identity theft
    (this multiple choice question has been scrambled)
  11. What would be the output of the expression 2+2*3?

    A. 8
    B. 15
    C. 11
    D. 12
    A. 8
    (this multiple choice question has been scrambled)
  12. An expression may include indentifiers, operators, functions, and __.

    A. units
    B. brackets
    C. text
    D. constants
    D. Constants
    (this multiple choice question has been scrambled)
  13. What is the general syntax for a calculated field?

    A. [InputField1] operator [InputField2]=CalculatedFieldName
    B. CalculatedFieldName=[InputField1] operator [InputField2]
    C. CalculatedFieldName: [InputField1] operator [InputField2]
    D. =CalculatedFieldName:[InputField1] operator [InputField2]
    C. CalculatedFieldName: [InputField1] operator [InputField2]
    (this multiple choice question has been scrambled)
  14. An expression for a calculated field is entered into the __ row.

    A. show
    B. sort
    C. field
    D. table
    C. Field
    (this multiple choice question has been scrambled)
  15. The __ builder is a tool that helps you create a formula that performs calculations.

    A. function
    B. expression
    C. value
    D. formula
    B. Expression
    (this multiple choice question has been scrambled)
  16. A(n) __ is an input component required to produce the output for a function.

    A. argument
    B. operator
    C. operand
    D. value
    A. Argument
    (this multiple choice question has been scrambled)
  17. The __ function evaluates a condition, executing one action when the condition is true and an alternate action when the condition is false.

    A. IIf
    B. Record
    C. Sum
    D. Pmt
    A. IIf
    (this multiple choice question has been scrambled)
  18. The function DatePart("yyyy",[BirthDate]) will return a value of 2006 if the Bithdate is __.

    A. 02/05/2006
    B. 10/06/2010
    C. 05/17/2010
    D. 06/20/2009
    A. 02/05/2006
    (this multiple choice question has been scrambled)
  19. The __ row displays as the last row and displays a variety of summary statistics.

    A. sum
    B. aggregate
    C. total
    D. data
    C. Total
    (this multiple choice question has been scrambled)
  20. A totals query organizes the results of a query into __ to perform aggregate calculations.

    A. groups
    B. sections
    C. parties
    D. totals
    A. Groups
    (this multiple choice question has been scrambled)
  21. It is the job of the __ department to administer people.

    A. marketing
    B. human resources
    C. production
    D. accounting
    B. Human Resources
    (this multiple choice question has been scrambled)
  22. The __ department measures and provides financial information about an organization primarily for its decision makers, investors, and taxing authorities.

    A. accounting
    B. marketing
    C. research and development
    D. human resources
    A. Accounting
    (this multiple choice question has been scrambled)
  23. Making goods and services to be sold is the job of the __ department.

    A. production
    B. marketing
    C. human resources
    D. research and development
    A. Production
    (this multiple choice question has been scrambled)
  24. Which department lets the world know about a product through advertising and branding?

    A. production
    B. human resources
    C. accounting
    D. marketing
    D. Marketing
    (this multiple choice question has been scrambled)
  25. The focus of the __ department is to evolve a business' original ideas and devise new ones.

    A. production
    B. accounting
    C. marketing
    D. research and development
    D. research and development
    (this multiple choice question has been scrambled)
  26. Business departments need to communicate with one another through data and information sharing called __.

    A. organizing
    B. accounting
    C. computing
    D. collaboration
    D. Collaboration
    (this multiple choice question has been scrambled)
  27. Many reports are __ in nature, meaning that they are produced at given intervals.

    A. ad hoc
    B. periodic
    C. sequential
    D. valuable
    B. Periodic
    (this multiple choice question has been scrambled)
  28. __ processing systems and the data they provide are the groundwork for all other reports.

    A. transit
    B. management
    C. transaction
    D. temporary
    C. Transaction
    (this multiple choice question has been scrambled)
  29. __ reports lend themselves to graphical reporting which can reveal trends within a business.

    A. detailed
    B. summarized
    C. ad hoc
    D. reconciled
    B. Summarized
    (this multiple choice question has been scrambled)
  30. Management reporting is summarized from __ reports and can sometimes be used for the strategic decisions, but generally is used for tactical decisions that require specific actions.

    A. demand
    B. executive
    C. uml
    D. tps
    D. TPS
    (this multiple choice question has been scrambled)
  31. A __ is a printed document that displays information from a database.

    A. query
    B. form
    C. report
    D. table
    C. Report
    (this multiple choice question has been scrambled)
  32. Which view allows you to alter the report design while viewing the data?

    A. layout view
    B. design view
    C. print preview
    D. report view
    A. Layout View
    (this multiple choice question has been scrambled)
  33. Which view displays the report as it will be printed?

    A. print preview
    B. design view
    C. report view
    D. layout view
    A. Print Preview
    (this multiple choice question has been scrambled)
  34. Which view displays the report's infrastructure, but no data?

    A. design view
    B. print preview
    C. report view
    D. layout view
    A. Design View
    (this multiple choice question has been scrambled)
  35. To use the Report tool, first determine the __ and open in datasheet view.

    A. report
    B. record source
    C. table
    D. design
    B. Record Source
    (this multiple choice question has been scrambled)
  36. You can only see sectional boundaries when you display the report in __.

    A. report view
    B. print preview
    C. design view
    D. layout view
    D. Layout View
    (this multiple choice question has been scrambled)
  37. The report footer section __ .

    A. appears once for each record in the underlying record source.
    B. appears once at the start of each new grouping level.
    C. appears once at the end of each report.
    D. appears once at the beginning of each report.
    C. Appears once at the end of each report.
    (this multiple choice question has been scrambled)
  38. Most __ controls display as two small boxes in desing view with the left box containing the control's label and the right box displaying the records value.

    A. calculated
    B. summary
    C. unbound
    D. bound
    D. Bound
    (this multiple choice question has been scrambled)
  39. To display the __ pane at the bottom of a report, click Group & Sort in the Grouping & Totals group on the Format tab.

    A. Grouping and Details
    B. Properties
    C. Navigation
    D. Group, Sort, and Total
    D. Group, Sort and Total
    (this multiple choice question has been scrambled)
  40. The __ Wizard ask questions and then, depending on the answers, generates the report.

    A. Query
    B. Report
    C. Label
    D. Print
    B. Report
    (this multiple choice question has been scrambled)
  41. IT stands for __.

    A. Information Technology
    B. Integrated Transactions
    C. Intelligence Topology
    D. Informal Typing
    A. Information Technology
    (this multiple choice question has been scrambled)
  42. The board-level head of an IT department within a business organization is called a __.

    A. CFO
    B. COO
    C. CEO
    D. CIO
    D. CIO
    (this multiple choice question has been scrambled)
  43. Many times a head application developer must modify an existing system also known as a __ system.

    A. language
    B. legacy
    C. unified
    D. modeled
    B. Legacy
    (this multiple choice question has been scrambled)
  44. A database administrator, or __ , categorizes data requirements and creates database entities and models.

    A. DaAd
    B. DAd
    C. DBA
    D. DA
    C. DBA
    (this multiple choice question has been scrambled)
  45. Which IT professional is responsible for the smooth operation and maintenance of a business' networks?

    A. Network Auditor
    B. Network Analyst
    C. Data Modeler
    D. Network Administrator
    D. Network Administrator
    (this multiple choice question has been scrambled)
  46. A senior __ may be asked to rewrite a legacy system, making it browser-based so it can be deployed on the World Wide Web.

    A. web designer
    B. web developer
    C. web deployer
    D. web detailer
    B. Web Developer
    (this multiple choice question has been scrambled)
  47. __ software is a business-wide computer system that uses shared data stores.

    A. ERP
    B. ESP
    C. Effected Temp
    D. ad hoc
    A. ERP
    (this multiple choice question has been scrambled)
  48. One of the advantages of ERP is __.

    A. they can be very expensive
    B. they are difficult to modify or customize after implementation
    C. businesses often must re-engineer their own processes
    D. functional departments can share information
    D. functional departments can share information
    (this multiple choice question has been scrambled)
  49. UML is typically used with __ programming languages, which encourage the programmer to reuse parts of an application.

    A. object-oriented
    B. procedural
    C. case
    D. ad hoc
    A. Object-Oriented
    (this multiple choice question has been scrambled)
  50. The first step of the System Development Life Cycle tries to determine the __ of the project and whether it is feasible.

    A. goals
    B. demands
    C. rewards
    D. steps
    A. Goals
    (this multiple choice question has been scrambled)
  51. A company performs data mining to __.

    A. identify patterns and relationships in data
    B. design large databases
    C. find data integrity issues
    D. describe population segments by age, race, education, etc...
    A. identify patterns and relationships in data
    (this multiple choice question has been scrambled)
  52. After a PivotTable is constructed, __.

    A. a new query with the same fields must be constructed
    B. the PivotChart view can not be displayed
    C. it is very easy to alter
    D. you can not change it easily
    C. it is very easy to alter
    (this multiple choice question has been scrambled)
  53. To organize data in a PivotTable, drag fields to the __ zones.

    A. drop
    B. pivot
    C. field
    D. active
    A. Drop
    (this multiple choice question has been scrambled)
  54. The largest drop zone contains the __ field.

    A. filter
    B. column
    C. detail
    D. row
    C. Detail
    (this multiple choice question has been scrambled)
  55. Which aggregate function may be used for a text field?

    A. average
    B. count
    C. report
    D. sum
    B. Count
    (this multiple choice question has been scrambled)
  56. A detail data point must be activated for the __ feature to engage.

    A. Drop Zones
    B. Field List
    C. Design View
    D. AutoCalc
    D. Auto Calc
    (this multiple choice question has been scrambled)
  57. A __ chart displays quantitative values veritcally to compare values across categories.

    A. bar
    B. column
    C. line
    D. pie
    B. Column
    (this multiple choice question has been scrambled)
  58. A __ chart describes part in relation to a whole.

    A. line
    B. column
    C. bar
    D. pie
    D. Pie
    (this multiple choice question has been scrambled)
  59. When editing an element in an Access PivotChart, you must select it __.

    A. using the property sheet
    B. by double clicking it
    C. by clicking it
    D. in the PivotTable
    A. Using the property sheet
    (this multiple choice question has been scrambled)
  60. A(n) __ field is useful to generate custom total calculations.

    A. calculated total
    B. query
    C. AutoCalc
    D. detail
    A. Calculated Total
    (this multiple choice question has been scrambled)
  61. In a __ database, tables are connected to other tables with related information.

    A. relation
    B. related
    C. relationship
    D. relational
    D. Relational
    (this multiple choice question has been scrambled)
  62. A database __ is a "map" of data tables and their relationships to each other.

    A. diagram
    B. schema
    C. network
    D. model
    B. Schema
    (this multiple choice question has been scrambled)
  63. Database designers construct a conceptual representation of a database using __.

    A. HTML
    B. ERM
    C. SQL
    D. Access
    B. ERM
    (this multiple choice question has been scrambled)
  64. A(n) __ check ensures that a field contains only numbers.

    A. alphabetic
    B. consistency
    C. range
    D. numeric
    D. Numeric
    (this multiple choice question has been scrambled)
  65. A column in a table is called a __.

    A. record
    B. form
    C. field
    D. trace
    C. Field
    (this multiple choice question has been scrambled)
  66. A well-thought out DBMS helps a business avoid data __, or repetition.

    A. redundacy
    B. validation
    C. integrity
    D. accuracy
    A. Redundancy
    (this multiple choice question has been scrambled)
  67. Different levels of __ can be implemented in a DBMS by determining who has access to see what in a business.

    A. redundancy
    B. security
    C. validation
    D. integrity
    B. Security
    (this multiple choice question has been scrambled)
  68. SQL is the most widely used standard computer language for __ databases that allows a programmer to manipulate and query data.

    A. hierarchical
    B. derivative
    C. object-oriented
    D. relational
    D. Relational
    (this multiple choice question has been scrambled)
  69. What results will the following SQL statement give?
    SELECT Title FROM Book WHERE Price<200 ORDER BY Title

    A. Books that cost less than $100
    B. Books that cost more than $100
    C. Books that cost more than $200
    D. Books that cost less than $200
    D. Books that cost less than $200
    (this multiple choice question has been scrambled)
  70. __ practice is a managment process, technique, or method that is most effective at arriving at a desired outcome.

    A. Traditional
    B. Effective
    C. Best
    D. Superlative
    C. Best
    (this multiple choice question has been scrambled)
  71. You use a(n) __ query when you want the user to interactively select one or more criteria.

    A. crosstab
    B. find unmatched
    C. action
    D. parameter
    D. Parameter
    (this multiple choice question has been scrambled)
  72. A(n) __ query alters data in a database, whereas a select query does not.

    A. crosstab
    B. find duplicates
    C. find unmatched
    D. action
    D. Action
    (this multiple choice question has been scrambled)
  73. To identify duplicated values in a table, you should use the __ query.

    A. parameter
    B. crosstab
    C. action
    D. find duplicates
    D. Find Duplicates
    (this multiple choice question has been scrambled)
  74. Which query summarizes values by two sets of unrelated facts?

    A. find unmatched
    B. parameter
    C. find duplicates
    D. crosstab
    D. Crosstab
    (this multiple choice question has been scrambled)
  75. By comparing records in two related tables, a(n) __ query will return the records found in one table, but not found in both.

    A. parameter
    B. crosstab
    C. find unmatched
    D. find duplicates
    C. Find Unmatched
    (this multiple choice question has been scrambled)
  76. An append query will __.

    A. select at least one record and add it to a different existing table
    B. change values in at least one record in a table.
    C. select at least one record and use the record(s) to create a new table
    D. select at least one record and remove the record(s) from the database
    A. Select at least one record and add it to a different existing table
    (this multiple choice question has been scrambled)
  77. When entered in the criteria row of a parameter query, which of the following would ask the user to enter a city name?

    A. (Enter the city name)
    B. Enter the city name
    C. [Enter the city name]
    D. {Enter the city name}
    C. [Enter the city name]
    (this multiple choice question has been scrambled)
  78. In a crosstab query, column headings describe __.

    A. the list of facts listed vertically
    B. how often values appear for each grouping level
    C. the type of aggregation to perform
    D. the list of facts listed horizontally
    A. The list of facts listed veritcally
    (this multiple choice question has been scrambled)
  79. In order for a find unmatched query to work, the two tables must __.

    A. have at least one numerical field
    B. share a common field
    C. have duplicate values
    D. share the same primary key
    B. Share a common field
    (this multiple choice question has been scrambled)
  80. You might run a find duplicated query to __.

    A. Increase a product's price by 15%
    B. Identify any repeating values in a primary key field
    C. Sum each saleperson's revenue by product category
    D. allow the user to enter a starting date
    B. Identify any repeating values in a primary key field
    (this multiple choice question has been scrambled)

What would you like to do?

Home > Flashcards > Print Preview