A basic set of database administration standards should be established to ensure the ongoing success of the DBA function. Answer: B However, at some shops the corporate data security unit handles DBMS security. Difficulty: Moderate LO: 1: Define key terms. Which organizational function should set database standards? Database development begins with the design of the database. Difficulty: Moderate Which of the following is NOT an advantage of database systems? Classification: Concept Answer: C Developing separate naming conventions for each is of no real value. B) repository. Data that describe the properties of other data are: A database is an organized collection of ________ related data. LO: 1: Explain the differences among external, conceptual, and internal schemas and the B) Cost of conversion This site currently does not respond to Do Not Track signals. B) Logical D) End Users The systems development life cycle is the traditional methodology used to develop, maintain, and replace information systems. B) The desire to manage increasing complex data types and structures A) enterprise information system. Furthermore, any performance tuning tricks that are documented in the DBA standards should be shared with programmers. A) planning For example, a database that contains information . In two-tier database architectures, little functionality needs to be programmed into the client application. Difficulty: Difficult A) creating data. D) Systems Deployment Life Cycle, The SDLC phase in which every data attribute is defined, every category of data are listed and every business relationship between data entities is defined is called the ________ phase. A) Management B) Application development C) Technical services D) None of the above Answer: D Diff: 2 Page Ref: 12 Topic: Advantages of the Database Approach; Subtopic: Enforcement of Standards. Failure to implement database standards and procedures will result in a database environment that is confusing and difficult to manage. LO: 1: Identify four categories of applications that use databases and their key characteristics. Classification: Concept D) Ties, ) Relational databases establish the relationships between entities by means of common fields included in a file called a(n) ________. 18) Which organizational function should set database standards? In general, do not impose unnecessary restrictions on the names of objects accessed by end users. Construct tables for arithmetic modulo 6 using the least nonnegative residues modulo 6 to represent the congruence classes. 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. Database processing programs are coded and tested during the design stage of the systems development life cycle. A) Database analysts D) crafting. B) Relationships C) fields. Procedures are required for migrating database objects and programs from environment to environment. B) hypertext graphic. D) enterprise data modeling, The traditional methodology used to develop, maintain and replace information systems is called the: For example, embedding a T into the name for test and a P for production is a bad idea. Metadata are data that describe the properties of other data. D) file updating. The desire to require programmers to write all file handling functionality. A) Unstructured and unpredictable use of data The steps of the systems development life cycle can only be viewed as a linear process. Data are logically organized into: 1. Test environments should never contain real production data; synthetic or anonymized datasets should be used instead 4. A) server. D) user snapshot, ) ________ is a tool even non-programmers can use to access information from a database. Difficulty: Moderate We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form. C) analysis B) Systems Development Life Cycle Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Which of the following types of data can be stored in a database? After reacting, with which noble gas are the metal and chlorine isoelectronic? A physical schema contains the specifications for how data from a conceptual schema are stored in a computer's secondary memory. For example, if ORG is the standard abbreviation for organization, do not allow variants such as ORGZ to be used. AACSB: Information Technology, Determining the structure of data and the relationships between data elements either right Answer: C When multiple environments exist, procedures are required for migrating database objects and programs from environment to environment. C) remote PC. A database management system is a software tool that makes it possible to organize data in a database. B) Cost of conversion One reason for improved application development productivity with the database approach is that file design and low-level implementation details do not need to be handled by the application programmer. CASE is a class of tools that: A) assists the database administrator in maintaining a database. Using the bond dissociation enthalpies in Table 8.9, estimate the enthalpy change for this reaction. Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure. A) the need for specialized personnel. The data that you are interested in capturing about an entity is called an instance. Because applications are often developed independently in file processing systems: unplanned duplicate data files are the rule rather than the exception. To ensure the success of the migration, the DBA should document the methods used for the migration and record the verification process. B) Program-data independence Difficulty: Moderate Users can manage and block the use of cookies through their browser. D) providing an integrated development environment. Design reviews are important to ensure proper application design, construction, and performance. Check whether the equation is true or false and explain your answer. The type of object can always be determined by querying the DBMS system catalog or data dictionary. A) logically Classification: Concept 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. An organizational or business function is a core process or set of activities carried out within a department or areas of a company. ________ are established between entities in a well-structured database so that the desired information can be retrieved. Unstructured and unpredictable use of data. 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. processing. Classification: Concept Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law. Database architects establish standards for data in business units. The database naming standard should be designed to minimize name changes across environments. You should document the special development considerations required when writing programs that access databases. C) ASP The database application development standards should function as an adjunct to any standard application development procedures within your organization. Please be aware that we are not responsible for the privacy practices of such other sites. Common functions include operations, marketing, human resources, information technology, customer service, finance and warehousing. In all cases, database naming standards should be developed in cooperation with the data administration department (if one exists) and, wherever possible, should peacefully coexist with other IT standards, but not at the expense of impairing the database environment. A) 1960s. 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. Data are the principal resources of an organization. An organization's corporate functions do not exist in a vacuum; they exist to provide support to the business. Classification: Concept Classification: Concept Construct a table for addition modulo 6. A) Network operating system For example, consider adopting a standard whereby the DBA communicates only with the manager during troubleshooting and emergency remediation. A modern database management system automates more of the backup and recovery tasks than a file system. Comprehensive migration procedures should be developed to address these types of questions. Create a list of standard abbreviations and forbid the use of nonstandard abbreviations. LO: 1: Identify four categories of applications that use databases and their key characteristics. A) ODBC B) Structured query language C) ASP D) Data manipulation query language AACSB: Information Technology, A user view is: Difficulty: Moderate C) loosely AACSB: Information Technology, A major difference between data warehouses and transactional systems as compared to big B) excellent; mainframes D) Ties 14 Assisting w/ the Physical Examination. Pearson may send or direct marketing communications to users, provided that. D) user snapshot C) decision support. System administration standards are needed for many of the same reasons that DBA standards are required. All of the following are primary purposes of a database management system (DBMS) EXCEPT: 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. 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. LO: 1: Explain the roles of individuals who design, implement, use, and administer Basic standards that can be modified to your requirements can be bought from a publisher or software vendor. A) The need to provide greater independence between programs and data D) a procedure stored on the server. A) Entities C) Conversion costs A) Specialized personnel Answer: B Benefits of Data Governance. D) repository. C) 60 percent A) logical data model. C) design web pages. D) typical arrangement. Classification: Concept, Program-data dependence is caused by: Answer: D D ) None of the above . A) enterprise view The period that can be considered a "proof of concept" time was the: Classification: Concept Classification: Concept This article will focus primarily on confidentiality since it's the element that's compromised in most data breaches. LO: 1: Name several limitations of conventional file processing systems. B) provides guidelines for the physical design of a database. Answer: C databases. D) Dissecting Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions. Regardless of whether they are purchased, written in house, or adopted from a user group or committee, each of the following areas should be covered. The most common source of database failures in organizations is: failure to implement a strong database administration function. C) icon. Languages, menus, and other facilities by which users interact with the database are collectively called a(n): D) association. processing. Keep in mind, too, that some database object names will, in some cases, be externalized. processing. Figure 2.7 Database objects map to filenames. A) Corporate data structure C) user view B) Logical A) logically A) entity Occasionally, we may sponsor a contest or drawing. B) Structured query language End users can often retrieve and display data easily with a relational database. processing. Avoid encoding table names to make them shorter. 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. B) order processing. Encoding table names to make them shorter is another arbitrary naming standard that should be avoided. C) data collaborative. The DBA should develop database standards and procedures as a component of corporate-wide IT standards and procedures. Answer: B processing. C) storing data. Classification: Concept A) controlled B) legacy C) database D) mainframe B A database is an organized collection of ________ related data. With this approach, database objects that operate like tables will be defined similarly with a very descriptive name. Difficulty: Easy Organizations that exist in loosely defined or ambiguous environments need to distribute decision-making authority to employees, and thus will often feature a flat organizational structure. LO: 1: Define key terms. C) Lines Difficulty: Moderate A) the data is unstructured in big data systems. They also ensure that work can continue . C) data descriptions being written into programming code. Classification: Concept Answer: A If a DA group exists within your organization, they should develop a basic data administration standards guide to outline the scope of their job role. Answer: B A) Management Difficulty: Easy A) planning Personal databases are designed to support a small group of individuals working together on a project. 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) index. AACSB: Information Technology, The three-schema approach includes which of the following schemas? C) the programming required to access data. is the most popular RDMS data model notation. Organizational commitment to a database project is not necessary for its success. User view 3. A person, place, an object , an event or concept about which the organization wishes to maintain data is called a(n): D) excellent; workgroup computers AACSB: Information Technology, A departmental multi-tiered client/server database is stored on a central device called a: Business rules are now accepted as an underlying requirement of most organizations. If a DA group does not exist, be sure to include DA standards in the DBA standards as appropriate. Once again, standards for system administration or systems programming are required only if your organization separates the SA function from the DBA function. A matrix of database management and administration functions should be developed that documents each support task and who within the organization provides the support. 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. C) fields. LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file Use the formula in the said example to make the following degree conversions. D) implementation A) password. The external schema contains a subset of the conceptual schema relevant to a particular group of users. D) implementation There is no practical reason to impose a limitation on the length of database table names. Database Administration Database Administration 2. 15) Which organizational function should set database standards?A) ManagementB) Application development C) Technical services D) Database Administration Answer: DLO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file. B) design Keeping the names consistent across environments allows the error messages to be consistent. Sign up to hear from us. A) Internal C) PC. Which organizational function should set database standards?A) ManagementB) Application developmentC) Technical services D) None of the above. Classification: Concept, The period that can be considered a "proof of concept" time was the: C) Technical services In prototyping, implementation and maintenance activities are repeated as necessary until the product is correct. A) Management B) Application development C) Technical services D) None of the above D ) None of the above 21) ________ is a tool even non-programmers can use to access information from a database. Cross), Give Me Liberty! purpose of database analysis, design, and implementation activities. B) provides guidelines for the physical design of a database. Database maintenance is typically the longest step of the database development process. A) client. Which of the following is NOT a cost and/or risk of the database approach? A) Management LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file B) various operational data sources. A) application programs. C) 1980s. Ch. 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. C) analysis A well-structured database establishes the entities between relationships in order to derive the desired information. A resource outlining the necessary standards and procedures for administering database security should contain the following information: Outline necessary standards and procedures for administering database security. Be sure to develop a comprehensive set of standards and procedures for each DBMS used by your organization. Be sure to create and publish naming standards for all database objects that can be created within each DBMS used by your organization. Chapter 6, Design Reviews, offers a comprehensive discussion. D) The need to provide ever more powerful platforms for decision support applications. 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. Naming Guidelines: One of the first . 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. failure to implement a strong database administration function. An extranet uses Internet protocols to establish limited access to company data by the company's customers and suppliers. A) 40 percent Which organizational function should set database standards? B) maintenance In 1998, ANSI/SPARC published an import document describing the three-schema architecture. Which of the following types of data can be stored in a database? included in a file called a(n): With the traditional file processing approach, each application shares data files, thus enabling much data sharing. Answer: B Table names should be as descriptive as possible, within reason. An X in the matrix indicates involvement in the process, whereas a P indicates primary responsibility. Element X is a solid metal that reacts with chlorine to produce a water-soluble binary compound. 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. LO: 1: Explain the roles of individuals who design, implement, use, and administer database technology? Without standard database object naming conventions, it will be difficult to identify database objects correctly and to perform the proper administration tasks. A) design called the: B) Relational DBMS Prototyping is a type of rapid application development. California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. D) Database analysts, ________ concentrate on determining the requirements for the database component of an information system. Classification: Concept Redundant data Which of the following is NOT an advantage of database systems? D) automates the design of databases and application programs. C) 60 percent D) Systems Deployment Life Cycle. B) mainframe. Database Administration: Creating the Database Environment, Defining the Organization's DBMS Strategy, Database Administration: The Complete Guide to DBA Practices and Procedures, 2nd Edition, Supplemental privacy statement for California residents, Mobile Application Development & Programming, Database objects and files can be grouped together in, A clear statement of the organizations overall policy with regard to data, including its importance to the company, Guidelines for establishing data ownership and stewardship, Rules for data creation, data ownership, and data stewardship, Conceptual and logical data modeling guidelines, The organizations goals with regard to creating an enterprise data model, Responsibility for creating and maintaining logical data models, Guidelines for tool usage and instructions on how data models are to be created, stored, and maintained, Instructions on how to document when physical databases deviate from the logical data model, Guidelines on communication between data administration and database administration to ensure effective database creation and usage, A checklist of departments to notify for impending changes, DBMS storage, usage, and monitoring procedures, A description of how database access differs from flat file access, Program preparation procedures and guidance on how to embed SQL in an application program, Interpretations of SQLSTATEs and error codes, References to other useful programming materials for teleprocessing monitors, programming languages, and general application development standards, Details on what authority to grant for specific types of situations; for example, if a program is being migrated to production status, what DBMS authorization must be granted before the program will operate successfully in production, Specific documentation of any special procedures or documentation required for governance- and compliance-related requests, A definitive list of who can approve what types of database authorization requests, Information on any interfaces being used to connect DBMS security with operating system security products, Policies on the use of the WITH GRANT OPTION clause of the SQL GRANT statement and how cascading REVOKEs are to be handled, Procedures for notifying the requester that database security has been granted, Procedures for removing security from retiring, relocating, and terminated employees. This set of standards should include. There are around 160 national standardization organizations which are members of ISO (the International Organization for Standardization). A database is an organized collection of ________ related data. Classification: Concept D) The need to provide ever more powerful platforms for decision support applications. ) Several vendors offer "canned" standards and procedures that can be purchased for specific DBMS products. Which organizational function should set database standards? A) planning All of the following are properties of metadata EXCEPT: processing logic. processing. 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. E. F. Codd developed the relational model in the: Classification: Concept, Languages, menus, and other facilities by which users interact with the database are The relational data model is no longer popular in the 21st century. Classification: Concept In a file processing environment, descriptions for data and the logic for accessing the . Redundant data Which of the following is NOT an advantage of database systems? Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing. Database security refers to the range of tools, controls, and measures designed to establish and preserve database confidentiality, integrity, and availability. data is: Which of the following is NOT an advantage of database systems? Design reviews can take many forms. Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising. 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.
which organizational function should set database standards?