Database Processing Assignment Part 2

35) A DBMS and database are synonymous terms that can be used interchangeably. 36) To modify an existing table, a developer can open the metadata form for that table and add a new row of metadata. 37) SQL is an international standard language for processing a database. 38) One of the functions of a DBMS is to provide tools to assist in the administration of a database. 39) A user must have a valid user account to access and process a database. 40) Managing the impact of database structural changes on applications and users is an operational task for a database administrator. 41) Explain how a database management system processes a database. 42) What is database administration? 43) A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data. A) database application B) database design C) data field D) data model E) data bridge 44) Katrina is a sales representative for an online retailer. She needs to update her customer list with new contact information for five customers. Which of the following elements will help Katrina modify her data? A) reports B) forms C) queries D) operations E) triggers 45) ________ are more stringent for browser-based Internet applications than for traditional ones. A) Graphical queries B) Coding standards C) Multi-user processing applications D) Security requirements E) Data consistency checks 46) Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year. She should use a ________ to obtain the information that she wants from the database. A) report B) data model C) database administrative function D) query E) pull function 47) Which of the following is TRUE of single-user databases? A) They are displayed and processed using HTML5, CSS3, and JavaScript. B) They use JavaScript for user-side processing. C) The Internet is used to access the DBMS server computer. D) The application, the DBMS, and the database all reside on the user's computer. E) They run on clustered Linux or Unix systems 48) Which of the following is TRUE of traditional database application programs? A) Application forms, reports, and queries are displayed and processed using a browser application. B) The application logic is contained in a program on the client-side computer. C) They are written in object-oriented languages such as C++ and VisualBasic. D) They are thin-client applications that need not be preinstalled on the users' computers. E) They are cloud-based applications that need not be preinstalled on the users' computers. 49) Traditional database application programs are ________. A) browser-based and display dynamic content B) written in languages such as HTML5 and JavaScript C) entirely dependent on the database server for application logic D) thick applications that need to be installed on users' computers E) cloud-based applications 50) Browser applications are thin-client applications that ________. A) use COBOL as the standard language for user-side processing B) are processed using VisualBasic and C++ C) need not be preinstalled on the users' computers D) depend on internal networks and not the Internet to transmit data E) do not need to be encrypted 51) Which of the following is used to process and display browser database application forms, reports, and queries? A) C++ B) html C) COBOL D) VisualBasic E) DB2 52) Browser-based applications ________. A) are thick-client applications B) can display only static content C) support graphical queries D) process queries using C++ E) process queries without using SQL 53) Browser-based applications ________. A) need to be preinstalled on the users' computers B) run within a corporate network that is protected from the Internet C) eliminate the need to check for data consistency D) are more vulnerable to security threats than are traditional applications E) do not need to be encrypted 54) Charles and Irene are editors at a content development firm. Both of them, unknowingly, are working on the same copy of the annual report. Irene finishes editing the report and saves her copy; Charles saves his report an hour after Irene. Charles's report overwrites Irene's, and her changes are lost. This scenario is an example of the ________. A) lost-update problem B) crow's-foot paradigm C) bullwhip effect D) update query problem E) bait-and-switch problem 55) Reports refer to the structured presentation of data using sorting, grouping, filtering, and other operations. 56) Most traditional databases use the Internet to transmit traffic back and forth between the users' computers and the DBMS server. 57) The lost-update problem can be resolved by implementing single-user database processing. 58) Locking must be used to coordinate the activities of users in order to prevent the lost-update problem. 59) Browser applications are thin-client applications that need to be preinstalled on the users' computers. 60) Single-user databases are an exception to a traditional database because the databases, application, and the DBMS all reside on the user's computer. 61) What is a database application? 62) State the purposes of the four elements of a database application. 63) What are traditional database applications? 64) Explain the functioning of browser applications. 65) What is the disadvantage of multiuser processing? 66) A ________ describes the data and relationships that will be stored in a database. A) data aggregator B) query model C) data model D) data application E) data-tree model 67) Ryan, a database administrator, is in the process of designing his company's database. Which of the following would Ryan have had to create before he began designing? A) data aggregator B) query model C) data model D) data application E) data tunnel outlay 68) A data model is a ________. A) logical representation of database data B) repository of unprocessed data C) collection of isolated databases D) set of programs used to retrieve data E) array of data variables