click below
click below
Normal Size Small Size show me how
M6 - CCS0001
INTRODUCTION TO COMPUTING
| Question | Answer |
|---|---|
| TRUE OR FALSE: A company can use thousands of computer system in a single computer-based information system. | TRUE |
| A(n) ____________ is a window on the screen that provides areas for entering or changing data in a database. | FORM |
| A ____________ is a field or set of fields in your table that acts as a unique identifier for every row. | PRIMARY KEY |
| ____________ is an element of an information system which refers to the physical component of a computer system. | HARDWARE |
| What kind of relationship is observed in the situation: A customer to products that can be ordered. | ONE TO MANY |
| CBIS is an acronym which stands for ____________. | COMPUTER BASED INFORMATION SYSTEM |
| This element of a CBIS tells hardware how to function. | SOFTWARE |
| It is the most overlooked element of a CBIS. | PEOPLE |
| A(n) ____________ is an organized collection of information which can easily be retrieved. | DATABASE |
| It is a collection of unprocessed information. | DATA |
| These are all types of information systems EXCEPT: | FILE PROCESSING SYSTEM |
| ____________is a set of data related for a specific purpose or topic. | DATABASE |
| It is an element of CBIS that is responsible in disseminating information to other people faster and safer. | COMMUNICATION |
| What kind of relationship is observed in the situation: Suppliers to products. | MANY TO MANY |
| ____________ are designed in a way that it can be printed just like a file done in word processing software. | REPORTS |
| Every row in a database table is also called ____________. | RECORD |
| These are used to retrieve data from a database. | QUERY |
| When compared with a file processing system, a database offers all of the following except _________. | LESS REQUIRED MEMORY, STORAGE, AND PROCESSING POWER |
| You can create a _______ to perform a specific series of actions in a database. | MACRO |
| The tables or queries from which a query gets its data are referred to as its _______ | RECORD SOURCE |
| It is considered as the bloodline of all CBIS, these needs to be processed first before they become meaningful. | DATA |
| TRUE OR FALSE: Some companies develop their own software that their CBIS uses. | TRUE |
| TRUE OR FALSE: Databases can be used to sort, summarize, and filter information. | TRUE |
| TRUE OR FALSE: Queries can be used to retrieve data from one or more tables. | TRUE |
| It comprises rules, descriptions and instructions for how things are done. | PROCEDURES |
| A(n) ____________ is a collection of multiple hardware, software, and communication networks that people needs to create, collect, and distribute useful data. | INFORMATION SYSTEMS |
| ____________ allow relational databases to split and store data in different tables, while linking disparate data items. | RELATIONSHIPS |
| Every item data stored in a table is called ____________. | DATA VALUE |
| A ____________ is a kind of user interface so that users can easily interact with the database. | FORM |
| This is added to every table in a database to make every record unique. | PRIMARY KEYS |
| A ____________ is another database object which can be use to summarize information from a table or query. | REPORT |
| TRUE OR FALSE: Companies of the same business type uses the same software. | FALSE |
| Difficulty to access data stored in separate files in different departments. | DATA ISOLATION |
| TRUE OR FALSE: You can choose which fields you want in your report. | TRUE |
| It is the repository of related data in a database. | TABLE |
| What kind of relationship is observed in the situation: Person to email address. | ONE TO MANY |
| TRUE OR FALSE: A visually attractive form have no effect on working with the database. | FALSE |
| Each column in a database table is also called _____. | FIELD |
| Where do we usually find procedures covering how hardware and software are used? | USER MANUALS |
| A ______ can be used to create an action or set of actions that can be used to automate a task. | MACRO |
| What kind of relationship is observed in the situation. People to address. | MANY TO MANY |
| The information part of an information system, and whether that is statistical data, sets of instructions, lists of names or even graphics and animation. | DATA |
| ________ is a database object that can be used to extract or show information in Datasheet view. | QUERY |
| A _______ is a situation that exists between two relational database tables. | RELATIONSHIPS |
| TRUE OR FALSE: Forms cannot help in preventing incorrect data to be entered to the CBIS. | FALSE |
| _______ can be embedded with forms and reports. | MACRO |
| All of the following are component of a computer-based Information System EXCEPT: | FILE SYSTEM |
| Editing an entry from a duplicated file mean that you will have to edit all other files where the edited data appeared. | INTEGRITY PROBLEMS |
| TRUE OR FALSE: Primary keys are also useful for designing relational databases. | TRUE |
| ____________ gathers, organizes and manipulates data and carries out instructions. | SOFTWARE |
| TRUE OR FALSE: Relational databases requires that tables to be related to other tables must have primary keys. | TRUE |