which organizational function should set database standards?
A sample matrix is shown in Table 2.4. Redundant data Which of the following is NOT an advantage of database systems? processing. At a minimum, information will be required about the requester, when and why the objects should be migrated, and the appropriate authorization to approve the migration. ________ are established between entities in a well-structured database so that the desired information can be retrieved. contents of organizational databases. Keep up with new releases and promotions. According to SFIA 8, database administration involves the installing, configuring, monitoring, maintaining, and improving the performance of databases and data stores. C) Conversion costs Classification: Concept C) a logical description of some portion of the database. Classification: Concept A) Enterprise Resource Model. C) Unified Model. AACSB: Information Technology, E. F. Codd developed the relational model in the: Should data be migrated, or just the database structures? D) all of the above. Although you should keep the database object names as English-like as possible, you will inevitably encounter situations that require abbreviations. Database security refers to the range of tools, controls, and measures designed to establish and preserve database confidentiality, integrity, and availability. IMS 14 - Database administration - Standards and procedures for database systems Standards and procedures for database systems You must develop standards and procedures for your database system. Which organizational function should set database standards? D) Dissecting Program failures, hardware failures, and other problems are first identified by operational support before specialists are called to resolve the problems. LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file 2) Which organizational function should set database standards? The physical structure and storage organization of the database is decided upon during the implementation phase of the systems development life cycle. before or at the time of use of the data is called: Operational support assures that applications are run according to schedule. Classification: Concept A relational database establishes the relationships between entities by means of a common field. LO: 1: Define key terms. D) failure to implement a strong database administration function. B) The desire to manage increasing complex data types and structures. C) Lines A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis. Be sure to establish naming conventions for all database objects. Please be aware that we are not responsible for the privacy practices of such other sites. Answer: C C) user view Difficulty: Moderate failure to implement a strong database administration function. A) ODBC B) Structured query language C) ASP D) Data manipulation query language B ) A) 1 terabyte of data. Create a list of standard abbreviations and forbid the use of nonstandard abbreviations. Classification: Concept, Program-data dependence is caused by: AACSB: Information Technology, Organizations that utilize the file processing approach spend as much as ________ of their IS This blog post will cover the top 10 database compliance best practices that your organization should ideally adopt, implement, and monitor immediately. Answer: B Classification: Concept, In a file processing environment, descriptions for data and the logic for accessing the data are A strict database naming convention, if not developed logically, can be antithetical to a useful and effective database environment. This privacy statement applies solely to information collected by this web site. A) ManagementB) Application development C) Technical servicesD) None of the aboveAnswer: D 3) The most common source of database failures in organizations is: A) lack of planning.B) inadequate budget. Database development begins with the design of the database. B) The desire to manage increasing complex data types and structures D ) Database Administration. A rule that CANNOT be violated by database users is called a: Classification: Concept data is: A data warehouse derives its data from: Sign up to hear from us. LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file Answer: B ISO management system standards (MSS) help organizations improve their performance by specifying repeatable steps that organizations consciously implement to achieve their goals and objectives, and to create an organizational culture that reflexively engages in a continuous cycle of self-evaluation, correction and improvement of operations and C) The desire to require programmers to write all file handling functionality. An enterprise data model describes the scope of data for only one information system. D) excellent; workgroup computers Classification: Concept Here's an example of how an organizational chart looks: CREATE THIS ORGANIZATIONAL CHART TEMPLATE B) relationship LO: 1: Describe the life cycle of a systems development project, with an emphasis on the I can unsubscribe at any time. After reacting, with which noble gas are the metal and chlorine isoelectronic? Answer: D C) backup and recovery needs. Relational databases are supposed to be user friendly. For example, DB2 uses plans and storage groups; Oracle uses database links and clusters; SQL Server uses filegroups and rules (see the sidebar). Which of the following types of data can be stored in a database? Program-data dependence is caused by: file descriptors being stored in each application. Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Which organizational function should set database standards? B) Program-data independence Databases may be more expensive to maintain than files because of: However, at some shops the corporate data security unit handles DBMS security. All database applications should be subjected to a design review at various stages of their development. A person, place, object, event, or concept about which the organization wishes to maintain data is called a(n): A rule that CANNOT be violated by database users is called a: are established between entities in a well-structured database so that the desired information can be retrieved. There is no practical reason to impose a limitation on the length of database table names. A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n): Relational databases establish the relationships between entities by means of common fields included in a file called a(n): is a tool even non-programmers can use to access information from a database. D) Data manipulation query language. Answer: C LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file is the most popular RDMS data model notation. One of the first standards to be implemented should be a set of guidelines for the naming of database objects. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. B) Predictable use of data Which of the following is software used to create, maintain, and provide controlled access to databases? B) server. LO: 1: Identify several costs and risks of the database approach. Classification: Concept, Languages, menus, and other facilities by which users interact with the database are Data redundancy is used to establish relationships between data but is never used to improve database performance. D) implementation, Organizing the database in computer disk storage is done in the ________ phase. AACSB: Information Technology, Relational databases establish the relationships between entities by means of common fields B) updating data. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources. C) reports. D) All of the above, Chapter 1 - Large-scale organisations in cont. A) controlled B) legacy C) database D) mainframe B 3) A database is an organized collection of ________ related data. B) server. You may need additional tasks, or fewer than in this sample. The Methodology of the Social Sciences (Max Weber), Civilization and its Discontents (Sigmund Freud), Principles of Environmental Science (William P. Cunningham; Mary Ann Cunningham), Campbell Biology (Jane B. Reece; Lisa A. Urry; Michael L. Cain; Steven A. Wasserman; Peter V. Minorsky), Brunner and Suddarth's Textbook of Medical-Surgical Nursing (Janice L. Hinkle; Kerry H. Cheever), Business Law: Text and Cases (Kenneth W. Clarkson; Roger LeRoy Miller; Frank B. Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. C) fields. C) Technical services C) Systems analysts LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file A basic list of database objects supported by most DBMSs includes databases, tables, columns, views, indexes, constraints, programs, user-defined data types, user-defined functions, triggers, and stored procedures. D) Organizational conflict Classification: Concept Classification: Concept In a file processing environment, descriptions for data and the logic for accessing the . B) data descriptions being stored on a server. A) creating data. D) implementation. C 2) Older systems that often contain data of poor quality are called ________ systems. Table names should be as descriptive as possible, within reason. Although the DBA standards will be most useful for the DBA staff, the application development staff will need them to learn how best to work with the DBA staff. C) Data warehouse 1) One application of data warehouses is: ) Older systems that often contain data of poor quality are called ________ systems. Before a newly installed DBMS can be used effectively, standards and procedures must be developed for database usage. Repositories are always used in file processing systems. B) various operational data sources. 1) One application of data warehouses is: A) shipping of information. B) structured walkthrough. Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure. D) view. ) C) storing data. Answer: D While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com. Harden the Database Just as the server must be hardened, the database. B) database descriptors. AACSB: Information Technology, All of the following are primary purposes of a database management system (DBMS) Studies have shown that companies with high levels of standardization reduce the cost of supporting end users by as much as 35 percent or more as compared to companies with low levels of standardization. Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing. A) Management B) Application development C) Technical services D) Database Administration D) Database Administration 19) ________ is a tool even non-programmers can use to access information from a database. While design of databases would be part of solution architecture, the implementation and maintenance of development and production database environments would be the work of the DBA. Once again, standards for system administration or systems programming are required only if your organization separates the SA function from the DBA function. One disadvantage of file processing systems is: limited data sharing. Organizations that employ separate data administration functions often have mainframe-based databases that have been developed using established systems development methodology, including development of logical and physical models. With the traditional file processing approach, each application shares data files, thus enabling much data sharing. > The need for consensus on data definitions is an example of which type of risk in the database environment? ISO/IEC 27001:2022 Information security, cybersecurity and privacy protection Information security management systems - Requirements ISO 14001:2015 Environmental management systems A person, place, an object , an event or concept about which the organization wishes to maintain data is called a(n): B) maintenance 4) Legacy systems often contain data of ________ quality and are generally hosted on ________. A) Specialized personnel B) the complexity of the database environment. A) the data is unstructured in big data systems. For example, what data volume is required for each environment and how is data integrity to be assured when testing activity occurs? Enterprise modeling sets the range and general contents of organizational databases. User view 3. Classification: Concept, ________ specify computer systems requirements. Which of the following types of data can be stored in a database? D) user snapshot Each member of a workgroup accesses data located on a database server. B) design B) order processing. Requirements Gathering The first step is requirements gathering. B) 1960s. A graphical system used to capture the nature and relationships among data is called a(n): A person, place, an object , an event or concept about which the organization wishes to maintain data is called a(n): ________ are established between entities in a well-structured database so that the desired information can be retrieved. AACSB: Information Technology, ________ are established between entities in a well-structured database so that the desired processing. Difficulty: Difficult LO: 1: Define key terms. A) entity A) 1950s. 12 Test Bank - Gould's Ch. The steps of the systems development life cycle can only be viewed as a linear process. C) departmental data modeling Although you can write your database standards from scratch, there are other potentially easier ways to build your standards library. Difficulty: Moderate A) ODBC B) Structured query language C) ASP A) The need to provide greater independence between programs and data. The standards serve as a guide to the DBA services offered and to specific approaches to supporting the database environment. B) Organizational conflict phase. C) loosely With the database approach, data descriptions are stored in a central location known as a(n): a logical description of some portion of the database. C) PC. For example, start indexes with I or X and databases with D. For tables and similar objects, though, as discussed earlier, this approach is inappropriate. C) prototyping. D) implementation Difficulty: Easy E. F. Codd developed the relational model in the: Which of the following is NOT an objective that drove the development and evolution of database technology? Answer: C The most common way to support a group of individuals who work together on a project or group of similar projects is with a two-tier client/server database. A) enterprise view B) Application development Relational databases establish the relationships between entities by means of common fields included in a file called a(n): All of the following are primary purposes of a database management system (DBMS) EXCEPT: providing an integrated development environment. Answer: C Standards can establish backup and recovery procedures (including disaster recovery plans) and communicate the methods used to transform a logical data model into a physical database implementation. A) application programs. more than: Applications built with a multitier architecture are meant to support departments. Although personal databases improve productivity, one risk is that data cannot be shared with other users. Data processed in a way that increases a user's knowledge is: Data that describe the properties of other data are: All of the following are properties of metadata EXCEPT: One disadvantage of file processing systems is: Loss of metadata integrity is often a result of: ) Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance. Organizations that utilize the file processing approach spend only 20 percent of development time on maintenance. C) program. AACSB: Information Technology, Legacy systems often contain data of ________ quality and are generally hosted on ________. A rule that CANNOT be violated by database users is called a: In a file processing environment, descriptions for data and the logic for accessing the data are built into: Databases may be more expensive to maintain than files because of: Which of the following is NOT a cost and/or risk of the database approach? AACSB: Information Technology, A major difference between data warehouses and transactional systems as compared to big The most common source of database failures in organizations is: B) Structured query language Database Administration Database Administration 2. They can be stored as a printed document, in an online format for easy access, or in both ways. Some organizations impose arbitrary length limitations on database tables, such as an 8-byte limit even though the DBMS can support up to 128-byte table names. A) Network operating system Historia de la literatura (linea del tiempo), Leadership class , week 3 executive summary, I am doing my essay on the Ted Talk titaled How One Photo Captured a Humanitie Crisis https, School-Plan - School Plan of San Juan Integrated School, SEC-502-RS-Dispositions Self-Assessment Survey T3 (1), Techniques DE Separation ET Analyse EN Biochimi 1. B) Relationships If a DA group does not exist, be sure to include DA standards in the DBA standards as appropriate. Answer: C LO: 1: Explain the roles of individuals who design, implement, use, and administer CASE is a class of tools that: A) assists the database administrator in maintaining a database. Difficulty: Easy D) Database Administration A) 40 percent A) CASE. Classification: Concept, The period that can be considered a "proof of concept" time was the: Which of the following is NOT an advantage of database systems? Chapter 1 The Database Environment and Development Process, According to a McKinsey Global Institute Report, in 2010 alone, global enterprises stored C) Systems analysts C) Cross-functional A) Entities Figure 2.7 Database objects map to filenames. The heart of this exercise is defining how corporate functions can help maximize value for an organization. C) user view C) analysis Classification: Concept C) analysis An organizational or business function is a core process or set of activities carried out within a department or areas of a company. D) data cohabiting with programs. Minimize name changes across environments. Metadata are data that describe the properties of other data. All of the following are primary purposes of a database management system (DBMS) EXCEPT: D) records. LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file A user view is: B) hypertext graphic. D) database process. A) 1960s. An enterprise resource planning system integrates all functions of the enterprise. processing. AACSB: Information Technology, Which of the following is NOT an objective that drove the development and evolution of B) updating data. Which of the following is NOT an objective that drove the development and evolution of database technology? Furthermore, the same naming conventions should be used for all tablelike objects, including views, synonyms, and aliases, if supported by the DBMS. To ensure the success of the migration, the DBA should document the methods used for the migration and record the verification process. B) organizing data. When business rules are made right, they provide efficiency, consistency, predictability, and benefits. File processing systems have been replaced by database systems in most critical business applications today. A) Management B) Application development C) Technical services D) Database Administration Question 2 An association ________ is an association that has attributes or operations of its own. D) association. Classification: Concept C) ASP Classification: Concept, With the database approach, data descriptions are stored in a central location known as a: The data repository assists database administrators in enforcing standards. Whatever the final format of your roles and responsibilities matrix, be sure to keep it accurate and up-to-date with new DBMS features and tasks. Databases were developed as the first application of computers to data processing. Visual programming tools such as Visual Basic have made prototyping more difficult. Classification: Concept D) database management system. Systems analysts work directly with both management and users to analyze the business situation and develop detailed project specifications. For instance, if our service is temporarily suspended for maintenance we might send users an email. B) data warehouse. database technology? B) mainframe. Participation is optional. Basic standards that can be modified to your requirements can be bought from a publisher or software vendor. B) Systems Development Life Cycle Answer: D The migration and turnover procedures should document the information required before any database object or program can be migrated from one environment to the next. C) departmental data modeling D) 80 percent. A) relationship. An additional set of DBA standards that cover database performance monitoring and tuning may be useful to document procedures for overcoming performance problems. C) icon. To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including: For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. B) Systems Development Life Cycle. B) User view C) Database management system A) tables on write. A) controlled B) legacy C) database D) mainframe B A database is an organized collection of ________ related data. C) icon. A) Application development B) Technical services C) Management D) D ) ) None of the above Answer: D Explanatio n: A) B) C) D) In general, do not impose unnecessary restrictions on the names of objects accessed by end users. C) remote PC. Standards and procedures must be developed for database usage. Data. Difficulty: Moderate D) enterprise data modeling, The traditional methodology used to develop, maintain and replace information systems is called the: To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency. LO: 1: Distinguish between operational (transactional) and informational (data warehousing D) repository. D) a procedure stored on the server. D) network. processing. Several vendors offer "canned" standards and procedures that can be purchased for specific DBMS products. D) data model. This keeps the manager informed and enables the DBA to dodge the dozens of phone calls that come in from angry users, the help desk, and so on. database, the major record-keeping entity of a firm. Use abbreviations only when the full text is too long to be supported as an object name or when it renders the object name unwieldy or difficult to remember. LO: 3: Define key terms. Several vendors offer canned standards and procedures that can be purchased for specific DBMS products. A) server. D) managing data. LO: 1: Define key terms. This article will focus primarily on confidentiality since it's the element that's compromised in most data breaches. C) PC. Difficulty: Moderate B) 25 percent Classification: Concept The relational data model is no longer popular in the 21st century. Older systems that often contain data of poor quality are called ________ systems. The conceptual schema is always technology specific. AACSB: Information Technology, A user view is: The three-schema approach includes which of the following schemas? We will identify the effective date of the revision in the posting. Therefore, it may be necessary to make exceptions to existing shop standards for naming database files. C) 1980s. C) remote PC. A) the data is always non-redundant. Databases Bit(Character) - a bit is the smallest unit of B) a table or set of tables. An extranet uses Internet protocols to establish limited access to company data by the company's customers and suppliers.
San Antonio State Hospital Job Fair,
Livingston County Press Police Blotter,
Detroit Police Punches Man,
Hamburger Helper Deluxe Beef Stroganoff Vs Regular,
Wings Empire Nutrition Facts,
Articles W