Deck 5 Flashcards
Get That MONEY!!!
Pass and Advanced
- What are the most high-level language translators called?
Compiler programs.
Pass and Advanced
- What are the three categories programming languages can be divided into?
Machine languages, assembly languages, and high-level languages.
Pass and Advanced
- What languages consists of a combination of 0s and 1s that is used to indicate OFF and ON states of electricity?
Machine language.
Pass and Advanced
- What is the ONLY form the computer is able to understand?
Binary form.
Pass and Advanced
- Why would you use assembly languages?
To avoid having to code directly into machine code (0?s and 1?s).
Pass and Advanced
- What type of high-level language was developed for business applications?
COBOL.
Pass and Advanced
- What high-level language was designed as a teaching language to help beginning programmers write programs?
BASIC.
Pass and Advanced
- What high-level language was initiated by the U.S. Department of Defense (DOD)?
Ada.
Pass and Advanced
- What will be the first program you will need to know about because you must install it before other programs?
The operating system.
Pass and Advanced
- What action is taken when you install a user/application software package on a system?
You need to provide the software with information about your microcomputer configuration.
Pass and Advanced
- When working with end users how can you be of help to them?
Troubleshoot and identify problems and teach them what you know.
Pass and Advanced
- What are the general operations with using software packages?
Access, create, save, delete, print, stop, and terminate.
Pass and Advanced
- What is a major consideration for a person working with packaged software?
File management.
Pass and Advanced
- What are a few ways to tell software what to do when interacting with software packages?
Direct commands, menus, function keys, and programs/macros.
Pass and Advanced
- What type of software package enables you to create, modify (insert, delete, rearrange), save, copy, and print documents?
Word processing packages.
Pass and Advanced
- What is the usual method of entering a document?
Type it on a keyboard.
Pass and Advanced
- How do you start creating a new document?
Tell the system you want to create a document.
Pass and Advanced
- Regardless of how the original document is entered, how is it normally stored as a data file?
On a secondary storage media.
Pass and Advanced
- What mode of operation should you use when you are using a word processing program and want to add new material to a document?
Insert mode.
Pass and Advanced
- What feature of word processing enables you to continue typing without regard for where a line ends?
Word-wrap.
Pass and Advanced
- What feature of word processing should you use to underline, center, tab or indent material?
Function keys.
Pass and Advanced
- What features do many word processing programs include that enable you to check for correct spelling, and to look for synonyms?
Dictionaries and a thesaurus.
Pass and Advanced
- What type of software package can enable you to define columns and rows and perform some arithmetic functions?
Spreadsheet package.
Pass and Advanced
- What is a record represented by on a spreadsheet?
A line (row) of data items of information, which is the horizontal component of a spreadsheet
Pass and Advanced
- What does a data cell on a spreadsheet contain?
One piece of information associated with a particular record.
Pass and Advanced
- A record/row that contains seven pieces of information will have how many data cells?
Seven.
Pass and Advanced
- How is a data cell symbolically identified?
By using some type of common notation, usually column, row.
Pass and Advanced
- What is the entire collection of data cells often referred to as?
A matrix or an array.
Pass and Advanced
- When entering data, is it necessary to enter it in alphabetical or numerical order?
No, the software package will normally arrange the data in whatever sequence you desire.
Pass and Advanced
- Spreadsheet software packages normally includes ways to do what functions?
Enter labels, enter values, enter formulas, insert and delete columns and rows, copy and move ranges of data cells/records from one area of a worksheet to another, erase part or all of a worksheet, change the way values are represented on part or all of a worksheet, split the viewing screen, save, retrieve, rename, erase, and copy tiles, and print a worksheet.
Pass and Advanced
- What is a database?
The filing cabinet and its contents.
Pass and Advanced
- What makes the database system much more powerful than a comparable filing cabinet system?
The ability to retrieve the data and calculate statistics quickly and easily without regard to which folder or drawer contains the information.
Pass and Advanced
- What type of media is the database normally stored on?
Secondary storage medium (usually disk), where the information is simply held until you need it.
Pass and Advanced
- What features of the database packages can you have the computer display or print the requested information in the format specified?
Query and report features.
Pass and Advanced
- What is a field also referred to as in database software?
A data item or a data element.
Pass and Advanced
- In database software what is a pointer?
A data item in one record that identifies the storage location of another logically related record.
Pass and Advanced
- What does the primary key in a database consist of?
A unique identifier for a particular record and should only point to a single record in the data base being indexed.
Pass and Advanced
- What is the major advantage of a database?
It permits the maintenance of a related set of tiles or tables that can provide information to several different users.
Pass and Advanced
- What type of database links records together through the use of pointers?
List databases.
Pass and Advanced
- What type of database consist of elements that act in a superior subordinate or parent-child relationship?
Hierarchical databases.
Pass and Advanced
- What is the main advantage of relational databases?
Relationships between the data can be established whenever you (the user) request information.
Pass and Advanced
- What are the common operations you can expect to perform when using a database software package?
Create, insert, update, and delete, create and run forms and reports, design and print labels, query, create and run/execute applications programs, and import and export tiles.
Pass and Advanced
- With database software, what name is given to the type of language used to retrieve information from a database?
Query language.
Pass and Advanced
- What packages are used primarily for designing and publishing professional looking documents?
Desktop publishing (DTP).
Pass and Advanced
- What are the typical applications of desktop publishing packages?
Newsletters, advertisements, letterheads, reports, presentations, catalogs, books, brochures, or flyers, forms, business cards, contracts, magazines, and overhead displays.
Pass and Advanced
- What tasks are involved in desktop publishing layout?
Arranging text, drawing borders, and incorporating illustrations.
Pass and Advanced
- What are the features you will find most in desktop publishing packages?
Lay out pages and edit page layouts; incorporate text and graphics; multiple columns, column widths, and heights; vertical/horizontal printing; fit copy to page; automatic page numbering; and headers and footers.
Pass and Advanced
- What are the graphic features you can expect to find in DTP packages?
Graphic images, shrink/expand and edit images, accept images from scanners or other draw programs, and layered output for color printing.
Pass and Advanced
- What size processor, at a minimum, is required to effectively use desktop publishing software?
486 sixteen-bit.
Pass and Advanced
- What type and size monitor should be used with desktop publishing software?
A high-resolution 19-inch monitor.
Pass and Advanced
- What type of printer is the best choice when it comes to preparing quality text and graphics with desktop publishing?
Laser.
Pass and Advanced
- What can satisfy the need for more computer power, overall performance, internal security, file and data management, and backup capabilities?
Software utilities.
Pass and Advanced
- What are the eight categories the various utility software/programs can be organized into?
Keyboard enhancement, desktop organizer, backup, file management, tile maintenance, DOS shell, printer, and virus utilities.
Pass and Advanced
- What type of utility usually includes a calculator, notepad, phone directory, and appointment book?
Desktop organizer utilities.
Pass and Advanced
- What functions do file management utilities perform?
It provides file recovery and manipulates files and documents.
Pass and Advanced
- What type of utility is designed to keep out the malicious logic that attack computer system software?
Virus utilities.
Pass and Advanced
- When starting to determine the system software requirements, what is looked at to determine whether a commercial software package is available to accomplish the job or if you will need to develop an in-house program?
The pseudo code and the user?s requested end product(s).
Pass and Advanced
- What are the factors to be combined when calculating memory requirements?
The operating system, the program, and the data to be input.
Pass and Advanced
- What can be done once you _ develop the pseudo code and identify the software and hardware requirements?
Begin developing the I/O and program specifications.
Pass and Advanced
- Who is the primary source in determining the input data and output material?
Users.
Pass and Advanced
- What are the three file organization methods used?
Sequential, indexed sequential, and direct.
Pass and Advanced
- What is a software package that provides an integrated source of data for multiple users, while presenting different views of that data of different users?
Database management system (DBMS).
Pass and Advanced
- How can database management systems (DBMSS) be characterized?
As generalized software that provides a single flexible facility for accommodating different data files and operations, while demanding less programming effort than conventional programming languages.
Pass and Advanced
- What is a complete description of a database, and consists of data definition language (DDL) entries?
A schema.
Pass and Advanced
- What is the applications programmer?s view of the data within the database pertinent to the specific application?
A subschema.
Pass and Advanced
- What is conceptually a loading and unloading zone, where all data provided by the DBMS in response to a CALL for data is delivered and is also where all data to be picked up by the DBMS must be placed?
The user working area (UWA).
Pass and Advanced
- What is used for describing a database, which may be shared by many programs written in many languages?
The schema data definition language (DDL), which is in terms of the names and characteristics of the data items, data aggregates, records, areas, and sets included in the database, and the relationships that exist and must be maintained between occurrences of those elements in the database.
Pass and Advanced
- What is a data item?
An occurrence of the smallest unit of named data.
Pass and Advanced
- What is an occurrence of a named collection of data items within a record?
A data aggregate.
Pass and Advanced
- What are the two kinds of data aggregate?
Vectors and repeating groups.
Pass and Advanced
- What is an occurrence of a named collection of records?
A set.
Pass and Advanced
- What determines a type of set, of which there may be an arbitrary number of set occurrences (sets) in the database?
Each set entry in the schema for a database.
Pass and Advanced
- What must each set occurrence (set) contain?
One occurrence of its defined owner type of record and may contain an arbitrary number of occurrences of each of its defined member type of record types.
Pass and Advanced
- What is a named collection of records that need not preserve owner/member relationships?
An area.
Pass and Advanced
- What may an area contain?
Occurrences of one or more record types, and a record type may have occurrences in more than one area.
Pass and Advanced
- What is a language used to cause data to be transferred between a run unit and the database?
A data manipulation language (DML).
Pass and Advanced
- Does a schema DDL entry include the references to a physical device or media space?
No, therefore a schema written using a DDL is a description of a database that is not affected by the devices or media used to store the data.
Pass and Advanced
- What concept allows the separation of the logical description of the entire database from the storage description of the same?
The concept of separate schema and storage schema.
Pass and Advanced
- What describes the representation of stored data in device independent terms?
The storage schema.
Pass and Advanced
- Who may allocate media and devices with differing characteristics to suit the c0mmand?s operational requirements, without alteration to the storage schema?
The database administrator.