Download Database Fundamentals and Concepts and more Exams Business Administration in PDF only on Docsity!
BUSI 2400 C5 With Complete Solutions Latest
Update
A database is a self-describing collection of integrated records. (T/F) - ANS T Special data called structured data describes the structure of the database. (T/F) - ANS F Metadata is data about data. (T/F) - ANS T The name of the field, its data type, and description are examples of metadata. (T/F) - ANS T A DBMS is software that helps manage the operating system. (T/F) - ANS F A database application system consists of forms, reports, and database programs. (T/F) - ANS T Most large companies develop their own DBMSs. (T/F) - ANS F IBM makes a DBMS called SQL Server. (T/F) - ANS F MySQL is an open-source DBMS product. (T/F) - ANS T
Oracle makes a DBMS packaged called DB2. (T/F) - ANS F SQL Server is an open-source DBMS package that is free for most database applications. (T/F) - ANS F A DBMS and a database are two different things. (T/F) - ANS T A DBMS is a collection of tables, relationships, and metadata. (T/F) - ANS F SQL is an international standard language for processing a database. (T/F) - ANS T SQL stands for "Standard Query Language." (T/F) - ANS F SQL can be used to add a new column to a table. (T/F) - ANS T A database can have one and only one application. (T/F) - ANS F A database application can have one or more users. (T/F) - ANS T A database form translates inputted changes into a SQL query in order for the database to process them. (T/F) - ANS T
What does CMS stand for? A) Content Management System B) Copy Management System C) Customer Management System D) Customer Manipulation System E) Content Manipulation System - ANS A A ________ is a self-describing collection of integrated records. A) column B) table C) row D) field E) database - ANS E A group of similar rows or records is called a(n) A) database. B) table. C) instance. D) attribute. E) column. - ANS B ________ describe(s) the structure of the database.
A) Metadata B) Tables C) Columns D) A relationship diagram E) Fields - ANS A A database consists of A) rows, tables, instructions. B) metadata, keyboard, relationships. C) tables, instructions, relationships. D) relationships, rows tables. E) CPU, tables, rows. - ANS D A ________ is a column or group of columns that identifies a unique row in a table. A) record B) relationship C) row D) key E) field - ANS D ________ are keys in a different table from the one in which they reside. A) Secondary keys
B) Description C) File name D) Data type E) Field name - ANS C ________ consists of forms, formatted reports, queries, and application programs. A) A database application B) A DBMS program C) A Visual Basic application D) A database E) A Windows application - ANS A Which of the following is a personal DBMS product? A) Microsoft Access B) Oracle C) SQL D) Microsoft SQL Server E) IBM DB2 - ANS A Which of the following is an international standard language for processing a database? A) VBA
B) C++
C) Visual Basic D) Standard Query Language E) Structured Query Language - ANS E A database application is a collection of programs, forms, reports, and A) queries. B) tables. C) metadata. D) keys. E) printers. - ANS A ________ are used to display formatted data and to generate paper copies of the data. A) Tables B) Forms C) Views D) Reports E) Queries - ANS D Which of the following techniques is used to resolve the lost-update problem? A) Preemptive updating
C) .doc D) .pdf E) .bmp - ANS B Which of the following is a file extension name of a word-processing document? A) .mpg B) .docx C) .bmp D) .xlsx E) .wav - ANS B Which of the following are NOT users of a content management system? A) Customers B) Web masters C) Copy editors D) Managers E) Employees - ANS A The company that digitized the Oxford English Dictionary is called A) IBM. B) Nortel. C) Microsoft.
D) Open Text. E) Research in Motion. - ANS D Columns are also called A) rows. B) databases. C) fields. D) relations. E) tables. - ANS C In a relational database, a collection of related records is a(n) A) row. B) attribute. C) table. D) column. E) field. - ANS C A collection of records in a relational database can be called a A) matrix. B) column. C) field. D) row.
E) DBM - ANS C
Content management is indexing the right information, processing, sorting it, and then A) getting it printed when needed. B) hiring good programmers. C) editing right employee input. D) making it available in the right format at the right time. E) giving it to employees with "strong" passwords. - ANS D ________ is a record in a relational database. A) A field B) A table C) A column D) A row E) A key - ANS D ________ is an example of a personal DBMS. A) Access B) SQL Server C) DB D) SQL
E) Oracle - ANS A ________ is an example of an enterprise DBMS. A) Access B) DB C) FoxPro D) Quattro Pro E) Paradox - ANS B MySQL is popular because it is a(n) ________ DBMS. A) open-source B) work-group C) personal D) enterprise E) powerful - ANS A One example of a DBMS is A) SQL Server. B) .NET. C) Java. D) OEM. E) Excel. - ANS A
________ is an international standard language for processing a database. A) VBA B) SQL C) Java D) .NET E) MySQL - ANS B The ________ problem is unique to a multi-user database environment. A) redundancy B) lost-update C) locked file D) security E) data integrity - ANS B Users process data in the database using A) files. B) logic. C) programs. D) reports. E) queries. - ANS E
The name of the field, the data type, and the number of characters allowed are examples of A) attributes. B) characters. C) content. D) overhead. E) metadata. - ANS E ________ describe(s) the structure of a database. A) Logic B) Metadata C) Models D) Protocols E) Content - ANS B In today's business world content is just not about collection and distribution. It is also about A) the accuracy of the content. B) the organization of the content. C) the content management system. D) the relevance of the content. E) presenting the content appropriately for the audience. - ANS E
One of the DMBS administrative functions includes A) building the database. B) backing up the database. C) collecting user requirements for the database. D) planning the database. E) entering new data into the database. - ANS B A database differs from a spreadsheet by A) involving lists of a single theme. B) having only columns. C) having lists of multiple rows and columns. D) involving lists of multiple themes. E) having only rows. - ANS D In databases, names of clients can be troublesome since they may not be A) relevant. B) simple. C) reconciled. D) unique. E) normalized. - ANS D
In a relational database application, a(n) ________ key is used to link one table with another. A) primary B) index C) secondary D) foreign E) composite - ANS D Some employees are frustrated with database applications or are unwilling to share their data, so they prefer to store their data in a(n) ________ instead of a database application. - ANS spreadsheet If a user stores their data in a spreadsheet, it is unavailable to other users unless it is stored in the company's ________. - ANS CMS ________ describes the data in a database. - ANS Metadata ________ DBMS like DB2 are designed for large, corporate database applications. - ANS Enterprise For applications that need to process databases over the Internet, the application serves as an intermediary between the ________ and the database. - ANS web server
