{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

BCIS Ch. 5-8 vocab. - Ch 5 6 7 and 8 Exam 2 Review Chapter...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Ch. 5 , 6 , 7 , and 8 Exam 2 Review Chapter 5: Questions 1. T/F - databases are required to keep track of lists with multiple themes? True 2. In a database columns are also called? Fields 3. In a database the rows are also called the what? Records 4. Which of the following best describes the metadata in a database? Special data that describes metadata is data that describes something 5. Databases that carry their data in the forms of tables and represent relationships using foreign keys are called what kind of databases? Relational database 6. T/F - a database is a self-describing collection of integrated records? True 7. A _______________ is a program that is used to create process and administer a collection of self- describing integrated records. Database management system. 8. The database management system provides applications for processing operations such as? Inserting or deleting information 9. SQL stands for? Structured Query Language 10. T/F - most organizations develop their own database management systems? False 11. T/F - Hypertext markup language is an international language for processing a database? False 12. T/F - The administrative function of DBMS include backing up database data? True 13. T/F - A database application serves as an intermediary between the users and the database data? True 14. Which of the following is true of the relational database processing model? Chapter 5: Vocab. 1. Access : a popular personal and small workgroup DBMS product from Microsoft. 123 2. Bigtable : A non-relational data store developed by Google. 132 3. Byte : Characters of data. 119 4. Cassandra : A durable, non-relational data store that operates over hundreds or thousands of servers. Originally developed by Facebook but later turned over to the open source community; has become an Apache Top-Level Project (TLP). 132 5. Columns : Also called fields, or groups of bytes. A database table has multiple columns that are used to represent the attributes of an entity. Examples are PartNumber, EmployeeName, and SalesDate. 119 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
6. Database : A self-describing collection of integrated records. 119 7. Database administration : A person or department that develops procedures and practices to ensure efficient and orderly multiuser process of the database, to control changes to database structure, and to protect the database.125 8. Database application : A collection of forms, reports, queries, and application programs that facilitates users’ processing of a database. A database can be processed by many different database applications. 126 9. Database management system (DBMS ): A program for creating, processing, and administering a database. A DBMS is a large and complex program that is licensed like an operating system. Microsoft Access and Oracle Database are example of DBMS products. 123 10. DB2 : A popular, enterprise-class DBMS product from IBM. 123 11. Dynamo : A non-relational data store developed by Amazon.com. 132 12. Fields : Also called columns, groups of bytes in a database table. A database table has multiple columns that are used to represent the attributes of an entity. Examples are PartNumber,
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}