MIS 564 Final Exam Practice 1 Week 7 with Answers


Category: Test Bank


MIS 564 Final Exam Practice 1 – Week 7

Final Exam Practice

  1. (CO A) A reference repository that holds metadata about all the databases, their component parts, the data in the databases, and the security details.
  2. (CO A) Responsible for data strategy, information architecture, and establishing the policies and procedures used by an entire organization for its data use and management.
  3. (CO A) Responsible for the development and day-to-day administration and maintenance of a database.
  4. (CO A) Responsible for the efficiency and optimization, access rights, and monitoring of a specific database, as well as participating in the DDLC for new databases.
  5. (CO A) An organization where the DA reports to a project manager and a data administration manager.
  6. (CO A) Between a DA and a DBA, excellent communication skills are critical for which position?
  7. (CO A) The DDLC is what and composed of what states?
  8. (CO D) A query language used to locate and retrieve nodes in an XML document:
  9. (CO D) XSL is comprised of what three parts?
  10. (CO D) An XML based web feed used to publish dynamic material
  11. (CO D) A database management system optimized to store, retrieve, and update XML documents natively:
  12. (CO D) A language used to describe another language
  13. (CO D) Embeds information about the data it holds in a hierarchical format which is self describing.
  14. (CO D) A closed markup language used to render data on a web browser.
  15. (CO D) Embeds XML file that associates a namespace with an XML document and describes the legal format, structure, content, and semantics of the document.
  16. (CO F) Techniques and technologies used to exploit large data stores in order to support decision making
  17. (CO F) OLAP
  18. (CO F) The two approaches that are used to exploit a datastore
  19. (CO F) A RDBMS where the multidimensional model is imposed on a relational model.
  20. (CO F) Name two ROLAP schemas.
  21. (CO F) The five data mining functions include:
  22. (CO F) An exchange of information, or conversation, between two applications is called
  23. (CO F) A computer host or small network inserted as a “neutral zone” between a company’s private network and the outside public network.
  24. (CO F) A small data item stored on the user’s computer by a web browser used for session tracking, authentication, storing site preferences, etc.
  25. (CO F) An application that manages the content of a website, including concurrent updates, imposing format consistency, and content versioning.
  26. (CO F) A web application is an example of what kind of architecture?
  27. (CO F) Name at least 3 web browser-to-DBMS server connectivity tools.
  28. (CO A) Domain
  29. (CO A) Primary Key
  30. (CO A) List the Relational Algebra Operators
  31. (CO A) A Join is
  32. (CO A) The SQL Constraints are
  33. (CO A) A View
  34. (CO A) NULL
  35. (CO A) What are the SQL Security Commands?
  36. (CO B) File servers, DBMS servers, 2-tiered, and 3-tiered are examples of
  37. (CO B) Super computers are used in which architecture?
  38. (CO B) A Distributed Database
  39. (CO B) Distributed Database Fragmentation techniques
  40. (CO B) Replication database
  41. (CO D) What is a TPS?
  42. (CO D) What are the desirable corporate data attributes? (Sharable, transportable, secure, accurate, timely, and relevant)
  43. (CO D) An Attribute
  44. (CO D) An Entity
  45. (CO D) Four building blocks of a data model:
  46. (CO D) Data Modeling
  47. (CO D) Describe the cardinality relationships.
  48. (CO D) A Generalization
  49. (CO D) Functional Dependency.
  50. (CO D) A relation is in 2-NF if,
  51. (CO D) A relation is in 3-NF if,
  52. (CO D) Goals of Normalization
  53. (CO E) The transaction manager
  54. (CO E) Used to solve concurrency issues
  55. (CO E) When 2 users lock resources needed by each other so neither can progress it is called
  56. (CO E) The 4 primary attributes a DBMS Transaction Manager enforces for any transaction
  57. (CO E) When an outcome is determined by the sequence or timing of events instead of deterministic processing, it is called a
  58. (CO E) A recovery procedure which backs out unwanted change in a database is called
  59. (CO E) A recovery procedure which uses a prior saved database state and applies after image records from update transactions
  60. (CO E) Verifying a user is who they say they are is
  61. (CO E) Authorization is
  62. (CO G) What managers are involved in database access?
  63. (CO G) An attribute used to narrow down the search space when accessing a row with a specific value for the attribute.
  64. (CO G) When we access the disk, we are accessing what kind of memory?
  65. (CO G) An index structure that is efficient for both sequential and direct file access is
  66. (CO G) A standard format used to represent written text in many different languages
  67. (CO G) A redundant array of independent disks
  68. (CO G) Which RAID levels are not good for applications with heavy update requirements?
  69. (CO G) What technique uses a function to convert a field into an address to promote direct accessing?