An additional set of DBA standards that cover database performance monitoring and tuning may be useful to document procedures for overcoming performance problems. Difficulty: Moderate The physical database server and/or the virtual database server . Data are the principal resources of an organization. Answer: B Avoid encoding table names to make them shorter. LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file A constraint is a rule in a database system that can be violated by users. E. F. Codd developed the relational data model during the 1970s. Difficulty: Easy Users can manage and block the use of cookies through their browser. The database naming standard should be designed to minimize name changes across environments. 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) tables on write. C) Technical services The operational support staff is usually the first line of defense against system problems. Which organizational function should set database standards? Many of the disadvantages of file processing systems can also be limitations of databases. Files 5. B) constraint. Furthermore, the same naming conventions should be used for all tablelike objects, including views, synonyms, and aliases, if supported by the DBMS. AACSB: Information Technology, The traditional methodology used to develop, maintain, and replace information systems is Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information. C) The desire to require programmers to write all file handling functionality. C) program. 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. AACSB: Information Technology, The three-schema approach includes which of the following schemas? Difficulty: Moderate D) implementation, The SDLC phase in which database processing programs are created is the ________ phase. LO: 1: Define key terms. collectively called a(n): LO: 1: Distinguish between operational (transactional) and informational (data warehousing processing. Languages, menus, and other facilities by which users interact with the database are collectively called a(n): Database development begins with ________, which establishes the range and general contents of organizational databases. Relational databases are supposed to be user friendly. Structured query language ________ is a tool even non-programmers can use to access information from a database. Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising. Which of the following types of data can be stored in a database? They should be stored together in a central location as a printed document, in an online format, or as both. Occasionally, we may sponsor a contest or drawing. A) enterprise information system. But what topics should be covered in a . development budget on maintenance. Be sure to establish naming conventions for all database objects. Database security refers to the range of tools, controls, and measures designed to establish and preserve database confidentiality, integrity, and availability. An X in the matrix indicates involvement in the process, whereas a P indicates primary responsibility. Design reviews are important to ensure proper application design, construction, and performance. AACSB: Information Technology, A major difference between data warehouses and transactional systems as compared to big A) Specialized personnel needs D) records. Classification: Concept AACSB: Information Technology, Organizations that utilize the file processing approach spend as much as ________ of their IS Adequate standards and procedures improve: The quality of application systems, because setting up and following C) 1970s. purpose of database analysis, design, and implementation activities. AACSB: Information Technology, A departmental multi-tiered client/server database is stored on a central device called a: The relational data model is no longer popular in the 21st century. Classification: Concept D) Ties, ) Relational databases establish the relationships between entities by means of common fields included in a file called a(n) ________. Separation of metadata from application programs that use the data is called data independence. C) analysis failure to implement a strong database administration function. 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. Cost and complexity are just two of the disadvantages of database processing. Difficulty: Moderate Languages, menus, and other facilities by which users interact with the database are collectively called a(n): C) Improved responsiveness Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. C) provides management reporting tools. B) Cost of conversion processing. B) 3 gigabytes of data. Keep up with new releases and promotions. Bits (characters) 2. 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. Naming Guidelines: One of the first . Answer: D LO: 1: Describe the life cycle of a systems development project, with an emphasis on the B) various operational data sources. A) client. C) analysis The data that you are interested in capturing about an entity is called an instance. C) icon. In two-tier database architectures, little functionality needs to be programmed into the client application. Difficulty: Moderate D) enterprise data modeling B) Logical This site is not directed to children under the age of 13. A) relationship. LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file Standards and procedures must be developed for database usage. Older systems that often contain data of poor quality are called ________ systems. C) at least 100 petabytes of data. C) a logical description of some portion of the database. The SDLC phase in which database processing programs are created is the ________ phase. more than: B) database descriptors. A) planning Classification: Concept, Copyright 2023 StudeerSnel B.V., Keizersgracht 424, 1016 GC Amsterdam, KVK: 56829787, BTW: NL852321363B01, 2) Database management involves all of the following EXCEPT. B) hypertext graphic. The database standards and procedures should be a component of corporate-wide IT standards and procedures. Difficulty: Easy Database standards and procedures should be developed by the DBA and stored together in a central place. B) user interface. Furthermore, any performance tuning tricks that are documented in the DBA standards should be shared with programmers. A data warehouse derives its data from: C) Technical services Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. A) logically Common functions include operations, marketing, human resources, information technology, customer service, finance and warehousing. Be sure to develop a comprehensive set of standards and procedures for each DBMS used by your organization. Classification: Concept, The period that can be considered a "proof of concept" time was the: D) The need to provide ever more powerful platforms for decision support applications. ) Classification: Concept ISO/IEC 27001:2022 Information security, cybersecurity and privacy protection Information security management systems - Requirements ISO 14001:2015 Environmental management systems AACSB: Information Technology, ________ are established between entities in a well-structured database so that the desired I can unsubscribe at any time. Difficulty: Difficult The most common source of database failures in organizations is: failure to implement a strong database administration function. C) reports. D) user snapshot Classification: Concept 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. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. Organizations that utilize the file processing approach spend only 20 percent of development time on maintenance. A database is an organized collection of ________ related data. How should existing data in the target environment be treatedshould it be kept, or overlaid with new data? LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file B) maintenance A) Specialized personnel An enterprise resource planning system integrates all functions of the enterprise. With this approach, database objects that operate like tables will be defined similarly with a very descriptive name. Which organizational function should set database standards?A) ManagementB) Application developmentC) Technical services D) None of the above. AACSB: Information Technology, Relational databases establish the relationships between entities by means of common fields LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file 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. B) Predictable use of data A) what a user sees when he or she looks out the window. A) server. B) CAD. D) more than 7 billion exabytes of data. D) a procedure stored on the server. LO: 1: Describe the life cycle of a systems development project, with an emphasis on the The DBA should develop database standards and procedures as a component of corporate-wide IT standards and procedures. A) CASE. When business rules are made right, they provide efficiency, consistency, predictability, and benefits. C) 1980s. A) The need to provide greater independence between programs and data. C) decision support. B) physically C) user view In most cases, for objects not accessed by typical end users, provide a way to differentiate types of database objects. Informal standards - These standards are by SDOs (standards development organizations) such as ASTM, ASME, IEEE, and SAE etc. C) Cross-functional They can be stored in an online format for easy access, as a printed document, or in both ways. Classification: Concept, A data warehouse derives its data from: B) cross-functional analysis B) user interface. Organizational readiness refers to the organization's financial and technological capacities that affect the implementation and use of the technology (Iacovou et al., 1995).Implementing blockchain technology requires investing in various kinds of software and hardware and using sophisticated information systems for A security procedure is a set . B) data descriptions being stored on a server. For example, DB2 uses plans and storage groups; Oracle uses database links and clusters; SQL Server uses filegroups and rules (see the sidebar). 18) Which organizational function should set database standards? AACSB: Information Technology, Determining the structure of data and the relationships between data elements either right A relational database establishes the relationships between entities by means of a common field. C) attribute. Table names should include a 2- or 3-byte application identification prefix, followed by an underscore and then a clear, user-friendly name. Database processing programs are coded and tested during the design stage of the systems development life cycle. reasons for the three-schema architecture for databases. 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. A) link B) group C) class D) body A person, place, an object , an event or concept about which the organization wishes to maintain data is called a(n): processing. D) End Users 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. 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. C) backup and recovery needs. Which organizational function should set database standards? Difficulty: Moderate Classification: Concept C) repository. included in a file called a(n): LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file B) design Keep in mind, too, that some database object names will, in some cases, be externalized. The internal schema consists of the physical schema and the enterprise data model. D) Organizational conflict D) a datamart. B) a table or set of tables. Answer: C B) 1960s. A) the need for specialized personnel. All projects move from the planning-enterprise modeling step to the planning-conceptual data modeling step of the systems development life cycle. A) planning Encoding table names to make them shorter is another arbitrary naming standard that should be avoided. D) file updating. B) cross-functional analysis 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. Unstructured and unpredictable use of data. AACSB: Information Technology, ________ do NOT concentrate on determining the requirements for the database component AACSB: Information Technology, E. F. Codd developed the relational model in the: Answer: B This privacy statement applies solely to information collected by this web site. The scope of an enterprise application is one workgroup or department. A) server group. Difficulty: Easy Answer: C LO: 1: Describe the life cycle of a systems development project, with an emphasis on the B) excellent; mainframes D) caching. Difficulty: Easy The steps of the systems development life cycle can only be viewed as a linear process. Data redundancy is used to establish relationships between data but is never used to improve database performance. 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. 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. One disadvantage of file processing systems is: limited data sharing. C) analysis A) 1950s. A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n): D) implementation, The SDLC phase in which the detailed conceptual data model is created is the ________ phase. A) database design B) inadequate budget. D) entity. Database object naming standards should be developed in conjunction with all other IT naming standards in your organization. D) Database analysts Difficulty: Easy Which organizational function should set database standards? Marketing preferences may be changed at any time. D) all of the above. A) planning D) 1990s. A) Internal C) poor; mainframes LO: 1: Explain the differences among external, conceptual, and internal schemas and the D) database process. LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file Classification: Concept D) entity. Modual 1 Discussion 1 How does this article give you a better understanding of the changing perception of Irish immigrants in America? data is called a(n): object. Which organizational function should set database standards? All database applications should be subjected to a design review at various stages of their development. The conceptual schema is always technology specific. every business relationship between data entities is defined is called the ________ phase. ________ are established between entities in a well-structured database so that the desired information can be retrieved. A) logical data model. B) mainframe. Failure to implement database standards and procedures will result in a database environment that is confusing and difficult to manage. Which of the following is software used to create, maintain, and provide controlled access to databases? Data. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions. Although you should keep the database object names as English-like as possible, you will inevitably encounter situations that require abbreviations. In prototyping, implementation and maintenance activities are repeated as necessary until the product is correct. B) the complexity of the database environment. A) Management B) database descriptors. Standards for SA may include, The development of database applications differs from typical program development. Because applications are often developed independently in file processing systems: unplanned duplicate data files are the rule rather than the exception. Classification: Concept The need for consensus on data definitions is an example of which type of risk in the database environment? D) 1990s. C) a logical description of some portion of the database. Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. A) creating data. Program failures, hardware failures, and other problems are first identified by operational support before specialists are called to resolve the problems. Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing. 2) Which organizational function should set database standards? If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account. 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. The DBA should develop database standards and procedures as a component of corporate-wide IT standards and procedures. AACSB: Information Technology, Which of the following is NOT an objective that drove the development and evolution of Explain how to identify the opposite and adjacent legs of a given acute angle. Classification: Concept, Languages, menus, and other facilities by which users interact with the database are D) records. 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. Answer: C C) data can always be shared with others. The period that can be considered a "proof of concept" time was the: A relatively small team of people who collaborate on the same project is called a(n): A workgroup database is stored on a central device called a(n): Which of the following is an integrated decision support database with content derived from various operational databases? Define standards for the code elements (views, functions etc), database naming; naming conventions for columns, tables; type conventions for columns; coding templates. purpose of database analysis, design, and implementation activities. Classification: Concept 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. B) Application development 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. built into: D) None of the above. LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file Which organizational function should set database standards? Include DA standards in the DBA standards as appropriate. LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file Participation is voluntary. Classification: Concept B) Systems Development Life Cycle. In practice, databases today may contain either data or information. With the database approach, data descriptions are stored in a central location known as a(n): AACSB: Information Technology, Legacy systems often contain data of ________ quality and are generally hosted on ________. LO: 1: Define key terms. You should document the special development considerations required when writing programs that access databases. Table names should be as descriptive as possible, within reason. Which of the following is NOT an advantage of database systems? The standards serve as a guide to the DBA services offered and to specific approaches to supporting the database environment. data is: D) Client-server system. An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called: The three-schema approach includes which of the following schemas? Design reviews can take many forms. Answer: A Difficulty: Moderate A) the data is always non-redundant. AACSB: Information Technology, The SDLC phase in which database processing programs are created is the ________ phase. Difficulty: Easy Standards should be developed to ensure that the operational support staff understands the special requirements of database applications. A) Specialized personnel LO: 1: Identify four categories of applications that use databases and their key characteristics. A data warehouse derives its data from: various operational databases. Answer: D We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey. Difficulty: Moderate The database application development standards should function as an adjunct to any standard application development procedures within your organization. Business rules are now accepted as an underlying requirement of most organizations. 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. A) Management Personal databases are designed to support a small group of individuals working together on a project. It is possible to make all the database object names the same by assigning each environment to a different instance or subsystem. D) data cohabiting with programs. C) on demand paging. I would like to receive exclusive offers and hear about products from InformIT and its family of brands. A) Programmers It is often referred to by its acronym, DBMS. Unless you use all three of DB2, Oracle, and SQL Server, some of the database objects that are specific to only one of these database systems probably will be unfamiliar to you. C) PC. ________ concentrate on determining the requirements for the database component of an information system. Classification: Concept Chapter 6, Design Reviews, offers a comprehensive discussion. B) organizing data. A) file descriptions being stored in each database application. Answer: D A database is an organized collection of ________ related data. The repository is populated during the analysis phase of the systems development life cycle. D) All of the above, Chapter 1 - Large-scale organisations in cont. Answer: C C) icon. A) Database analysts C) Improved responsiveness Answer: D D) network. An up-to-date matrix makes it easier to define roles within the organization and to effectively apportion database-related workload. D) Data manipulation query language. B) design To ensure the success of the migration, the DBA should document the methods used for the migration and record the verification process. processing. B) relationship. 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. The user interface includes languages, menus, and other facilities by which users interact with various system components. Answer: B D) failure to implement a strong database administration function.