CSIT Chapter 12 Exam Questions and Answers

CSIT Chapter 12 Exam Questions and Answers are made up of related records. - Answer-tables create the actual database based on the design generated by the database designer and get it ready for data entry. - Answer-database developers A extracts specific information from a database by specifying particular conditions (called criteria) about the data you would like to retrieve. - Answer-query A is a collection of related fields. - Answer-record A field is also called a . - Answer-column A(n) is a small table consisting only of the primary key field and the location information for each record. - Answer-index Continually evaluating and improving the security measures used with the database is a database activity. - Answer-maintenance In , the table field involved in the changes is locked until the changes to that field have been completed. - Answer-column-level-locking In ASPs, the code to tie the database to the Web site is typically written in JavaScript or . - Answer-VBScript Middleware for cloud database applications is commonly written as —short sections of code written in a programming or scripting language that are executed by another program. - Answer-scripts One of the properties that can be assigned to a field is a(n) to specify the format (such as letters, numbers, or symbols) that must be entered into a field. - Answer-input mask One of the simplest hashing algorithms involves dividing the primary key field by a particular . - Answer-prime number The process of evaluating and correcting the structures of the tables in a database to minimize data redundancy is called - Answer-normalization The term refers to a wide variety of different database technologies that were developed in order to overcome some of the limitations of relational databases. - Answer-NoSQL With a , the databases used by the system are all located on a single computer, such as a server or mainframe computer. - Answer-Centralized Database System True or false. A database typically consists of interrelated tables that contain forms and reports. - Answer-false True or false. a field needs to store decimal places, the Long Integer field size can be used. - Answer-false True or false. Repairing or restoring data that has become corrupt, such as the result of a storage media error or a computer virus, is a database analysis activity. - Answer- false