which organizational function should set database standards?

We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes. A) index. A) server group. D) enterprise data modeling B) 1970s. The more the application programmers understand the nuances of the DBMS and the role of the DBA, the better the working relationship between DBA and development will beresulting in a more efficient database environment. Which of the following is NOT an advantage of database systems? A) on-line transactions. A) what a user sees when he or she looks out the window. 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. A) planning With the traditional file processing approach, each application shares data files, thus enabling much data sharing. A) what a user sees when he or she looks out the window. > Which organizational function should set database standards 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. The term legacy system refers to a newly installed database management system. D ) Database Administration. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions. B) Logical C) provides management reporting tools. Answer: B Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn. Data Mgmt_quiz.docx - 1. Which organizational function should set Failure to implement database standards and procedures will result in a database environment that is confusing and difficult to manage. A QMS helps coordinate and direct an organization's activities to meet customer and regulatory requirements and improve its effectiveness and efficiency on a continuous basis. A) 1950s. A) The need to provide greater independence between programs and data. D) a procedure stored on the server. AACSB: Information Technology, Organizations that utilize the file processing approach spend as much as ________ of their IS C) data collaborative. Pearson does not rent or sell personal information in exchange for any payment of money. A) Internal C) Systems analysts Classification: Concept, Languages, menus, and other facilities by which users interact with the database are Therefore, it may be necessary to make exceptions to existing shop standards for naming database files. It is especially important to avoid this approach for user-visible database objects such as columns, tables, and views. Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance. There are many types of constraintstriggers, unique constraints, referential constraints, check constraintseach of which can be named. Procedures are required for migrating database objects and programs from environment to environment. Comprehensive migration procedures should be developed to address these types of questions. Program-data dependence is caused by: file descriptors being stored in each application. Answer: C A matrix of database management and administration functions should be developed that documents each support task and who within the organization provides the support. A) lack of planning. Answer: D Check whether the equation is true or false and explain your answer. Difficulty: Moderate IMS 14 - Database administration - Standards and procedures for - IBM A) planning Answer: A ISO 9001:2015 Quality management systems The ISO 9000 family is the world's most best-known quality management standard for companies and organizations of any size. B) mainframe. D) providing an integrated development environment. Although database naming standards are important, you will need to develop and maintain other types of database standards. D) a datamart. of an information system. A) Programmers Chapter 6, Design Reviews, offers a comprehensive discussion. Which organizational function should set database standards? A rule that CANNOT be violated by database users is called a: Difficulty: Easy D) implementation B) schema on write. The physical structure and storage organization of the database is decided upon during the implementation phase of the systems development life cycle. Which of the following is software used to create, maintain, and provide controlled access to databases? B) design This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Should data be migrated, or just the database structures? 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. 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. Such marketing is consistent with applicable law and Pearson's legal obligations. Database development begins with the design of the database. Database processing programs are coded and tested during the design stage of the systems development life cycle. Database development begins with ________, which establishes the range and general contents of organizational databases. Keeping the names consistent across environments allows the error messages to be consistent. Data are the principal resources of an organization. A) Internal Answer: D B) server. The scope of an enterprise application is one workgroup or department. Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site. Whenever possible, operational support personnel should be trained to resolve simple database-related problems without involving the DBA because the DBA is a more expensive resource. LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. For example, consider adopting a standard whereby the DBA communicates only with the manager during troubleshooting and emergency remediation. C) 1980s. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. Repositories are always used in file processing systems. LO: 1: Identify four categories of applications that use databases and their key characteristics. An enterprise resource planning system integrates all functions of the enterprise. B) Application development D) Database analysts, ________ concentrate on determining the requirements for the database component of an information system. D) file updating. B) server. Data Governance - Overview, Role and Importance, Benefits C) Data warehouse Classification: Concept, With the database approach, data descriptions are stored in a central location known as a: C) reports. Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. The physical database server and/or the virtual database server . Design reviews can take many forms. Which organizational function should set database standards? Classification: Concept B) reporting document D) Organizational conflict D) automates the design of databases and application programs. A) Management There is no practical reason to impose a limitation on the length of database table names. A database management system is a software tool that makes it possible to organize data in a database. A) controlled B) legacy C) database D) mainframe B A database is an organized collection of ________ related data. Operational support is defined as the part of the IT organization that oversees the database environment and assures that applications are run according to schedule. processing. 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. Because applications are often developed independently in file processing systems: unplanned duplicate data files are the rule rather than the exception. B) updating data. C) The desire to require programmers to write all file handling functionality. Logically 4. Difficulty: Moderate A) Enterprise Resource Model LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file Encoding table names to make them shorter is another arbitrary naming standard that should be avoided. The traditional methodology used to develop, maintain and replace information systems is called the: The SDLC phase in which every data attribute is defined, every category of data is listed and every business relationship between data entities is defined is called the ________ phase. Multitier client/server database applications contain a business logic layer. An equation involving variables should be marked true only if it is an identity. B) order processing. The failure to implement a strong database administrative function is the most common source of database failures in organizations. Naming Guidelines: One of the first . Which organizational function should set database standards? Difficulty: Moderate Bits (characters) 2. data is: B) relationship. D) 1990s. All database applications should be subjected to a design review at various stages of their development. Which of the following is NOT an objective that drove the development and evolution of database technology? The matrix can be created at a departmental level, a job description level, or even by individual name. A) logical data model. purpose of database analysis, design, and implementation activities. Please note that other Pearson websites and online products and services have their own separate privacy policies. Table names should include a 2- or 3-byte application identification prefix, followed by an underscore and then a clear, user-friendly name. Difficulty: Moderate Using standard abbreviations will minimize mistyping and make it easier for users to remember database object names. C) analysis C) analysis A) client. Classification: Concept Procedures are defined, step-by-step instructions that direct the processes required for handling specific events, such as a disaster recovery plan. Data that describe the properties of other data are: A database is an organized collection of ________ related data. AACSB: Information Technology, Database development begins with ________, which establishes the range and general 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. Classification: Concept, A data warehouse derives its data from: Cross), Give Me Liberty! 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. Difficulty: Easy Home Answer: C Benefits of Data Governance. Metadata are data that describe the properties of other data. Classification: Concept ISO 9001:2015, the international standard specifying requirements for quality management systems, is the most prominent approach to quality management systems. reasons for the three-schema architecture for databases. Database Compliance: The Challenges Besides the obvious legal and monetary implications, adhering to the latest compliance standards has become extremely critical in creating a sustainable . LO: 1: Explain the roles of individuals who design, implement, use, and administer phase. A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n): automates the design of databases and application programs. Once again, standards for system administration or systems programming are required only if your organization separates the SA function from the DBA function. database technology? C) user view C) relation Occasionally, we may sponsor a contest or drawing. processing. purpose of database analysis, design, and implementation activities. Classification: Concept Classification: Concept IM - Quiz 1.docx - 1. Systems analyst work directly with This site is not directed to children under the age of 13. The period that can be considered a "proof of concept" time was the: If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. A) creating data. A user view is how the user sees the data when it is produced. D) database management system. For example, you might want to document how and when the DBA group must communicate with the systems programming group when a new DBMS release is being installed. Which organizational function should set database standards? 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. EXCEPT: D) implementation, The SDLC phase in which the detailed conceptual data model is created is the ________ phase. Each member of a workgroup accesses data located on a database server. D) records. Classification: Concept D) Ties, ) Relational databases establish the relationships between entities by means of common fields included in a file called a(n) ________. B) 3 gigabytes of data. C) 60 percent Diff: Moderate Page Ref: 24 Topic: Advantages of the Database ApproachSubtopic: Enforcement of Standards 29. A) database design A) planning C) backup and recovery needs. > D) user snapshot, ) ________ is a tool even non-programmers can use to access information from a database. D) Systems Deployment Life Cycle. To ensure the success of the migration, the DBA should document the methods used for the migration and record the verification process. C) storing data. An X in the matrix indicates involvement in the process, whereas a P indicates primary responsibility. D) MST. User view 3. 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. B) User view Answer: D AACSB: Information Technology, All of the following are primary purposes of a database management system (DBMS) A) Database analysts Each of these objects is basically a collection of data accessible as rows and columns. Developing separate naming conventions for each is of no real value. What is the enthalpy of combustion of one mole of gaseous methanol? object. B) various operational data sources. However, this list is incomplete because each DBMS uses other database objects specific to its operation. (a4b2)1/2=a2b\left(a^4 b^2\right)^{1 / 2}=\left|a^2 b\right|(a4b2)1/2=a2b. processing. B) design C) attribute. Database Security: An Essential Guide | IBM D) entity. Database Administration Database Administration 2. Structured query language ________ is a tool even non-programmers can use to access information from a database. You may need additional tasks, or fewer than in this sample. LO: 1: Define key terms. ISO - Standards For instance, most DBMSs externalize constraint names when the constraint is violated. 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. D) a procedure stored on the server. The instance or subsystem name, rather than the database object names, will differentiate the environments. D) implementation, Organizing the database in computer disk storage is done in the ________ phase. data is called a(n): An additional set of DBA standards that cover database performance monitoring and tuning may be useful to document procedures for overcoming performance problems. Classification: Concept AACSB: Information Technology, A(n) ________ is often developed by identifying a form or report that a user needs on a D) 80 percent D) development environment. purpose of database analysis, design, and implementation activities. Furthermore, any performance tuning tricks that are documented in the DBA standards should be shared with programmers. B) 1960s. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx. The most common source of database failures in organizations is: Answer: D B) workgroup. Figure 2.7 Database objects map to filenames. every business relationship between data entities is defined is called the ________ phase. D) Database Administration An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called: This privacy statement applies solely to information collected by this web site. processing. You might also choose to develop specific standards for communication between groups and specific personnel. B) updating data. A) Redundant data Be sure to create and publish naming standards for all database objects that can be created within each DBMS used by your organization. C) relation. C) data descriptions being written into programming code. B) organizing data. D) Reduced program maintenance. All of the following are properties of metadata EXCEPT: processing logic. D) Dissecting An organizational or business function is a core process or set of activities carried out within a department or areas of a company. Be sure to develop a comprehensive set of standards and procedures for each DBMS used by your organization. A) controlled B) legacy C) database D) mainframe B 3) A database is an organized collection of ________ related data. B) provides guidelines for the physical design of a database. A) 1950s. Before a newly installed DBMS can be used effectively, standards and procedures must be developed for database usage. D) End Users 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. End users can often retrieve and display data easily with a relational database.