Database Processing Assignment Part 1

Chapter 5 Database Processing 1) A database is used instead of a spreadsheet when ________. A) lists of data involve a single theme B) structures of data lists are simple C) lists involve data with multiple themes D) users do not want to store all data in one place E) users have a small amount of data to store 2) Larry wants to keep track of his vintage vinyl records, the value of each record, and who he lends the records to for parties. Larry should use a ________. A) database B) spreadsheet C) table in Microsoft Word D) sticky note E) bulletin board 3) Lists that involve data with multiple themes can be stored in a spreadsheet. 4) The purpose of a database is to keep track of lists of data that involve multiple themes. 5) What is the purpose of a database? Answer: The purpose of a database is to keep track of things. Lists of data involving a single theme can be stored in a spreadsheet; while lists that involve data with multiple themes require a database. Thus, the purpose of a database is to keep track of things that involve more than one theme. 6) Which of the following is the smallest element in a database? A) field B) record C) byte D) metadata E) zetta 7) In a database, ________ are grouped into columns. A) fields B) records C) bytes D) files E) nibbles 8) The columns in a database are also called ________. A) records B) tables C) files D) fields E) verticals 9) The rows in a database are also called ________. A) records B) tables C) files D) fields E) laterals 10) A group of similar rows or records is known as ________. A) a prototype B) a table C) a field D) an attribute E) a cluster 11) Which of the following data elements is placed higher than records in the database hierarchy? A) file B) field C) character D) byte E) bit 12) A primary key in a database is a ________. A) group of rows that identifies a unique table or file B) column or group of columns that identifies a unique row in a table C) group of fields or columns that represent metadata D) group of tables or files formed to identify a unique field or row E) group of records that identifies similar attribute 13) Maria creates a relational database to keep track of cars in her repair shop. She stores information about each car in the "vehicle" table, and creates a column labeled "vehicle_ID" where she stores the vehicle VIN number. The "vehicle_ID" column is referred to as a ________. A) primary key B) key attribute C) foreign key D) functionally dependent record E) secondary key 14) Columns that are keys to different tables than the ones in which they reside are called ________. A) attributes B) foreign keys C) primary keys D) internal records E) nonlocal keys 15) Relational databases represent relationships using ________. A) foreign keys B) file systems C) metadata D) primary keys E) trees 16) Metadata is/are ________. A) codes used for server-side processing B) error logs of databases C) data that describes data D) data that are encrypted E) more important data 17) A group of similar rows or records in a table is called a file. 18) Metadata refers to special data that describes the structure of a database. 19) Each table in a database must have at least one foreign key. 20) A foreign key is a key of a different (foreign) table than the one in which it resides. 21) Describe a database and its elements. 22) Define primary key, foreign key, and metadata. 23) Why does the presence of metadata make databases more useful? 24) A(n) ________ is a program used to create, process, and administer a database. A) operating system B) database management system C) information system D) database system E) operating system driver 25) Which of the following is an example of a database management system? A) MS Excel B) BigData C) NoSQL D) Access E) MS Visio 26) Identify an open source DBMS product. A) MySQL B) DB2 C) Access D) Oracle Database E) TableOS 27) Which of the following is TRUE of MySQL? A) It is a Microsoft product. B) It is license-free for most applications. C) It is a paid and proprietary database product. D) It uses Static Query Language (SQL) to manage a database. E) It limits databases to 2 TB in size. 28) The modification or deletion of data in a database is an example of ________ operations of a database management system. A) statistical B) analytical C) administrative D) processing E) technical 29) Which of the following is an international standard language for processing a database? A) Cassandra B) DB2 C) SQL D) MS Access E) Relational LM 30) Which of the following is a developmental task of database administration? A) evaluating an application design B) monitoring backup procedures C) conducting training for users D) managing configuration changes in systems E) testing backup procedures 31) Jed is a database administrator for a mid-sized computer component manufacturer. Part of his duties include managing security, tracking problems, and monitoring the performance of the database. This is an example of Jed's ________ tasks. A) development B) adaptation C) backup and recovery D) operation E) data audit 32) Sonya is the database administrator for RedTriangle media. She is responsible for validating the data model to be used by the DBMS, and specifying the database requirements to endure all appropriate user input is considered. This is an example of Sonya's ________ tasks. A) development B) recovery C) adaptation D) operation E) data audit 33) Which of the following database administration tasks is related to adaptation? A) monitoring backup procedures B) conducting training for users C) monitoring database performance D) managing configuration changes in systems E) conducting data audit requirements 34) All of the following are functions of the DBMS except ________. A) processing the database B) providing tools to administer the database C) creating the database D) modifying the database E) getting the users to use the database