Exam 11: Building Solutions
A data ______ contains data about each file in the database and each field in those files.
D
List and describe common data types.
Common data types include the following:
• Text: Letters, numeric characters, or special characters
• Number (also called numeric values: Positive or negative numbers, and the number zero, with or without decimal points
• AutoNumber: Unique number automatically assigned by the DBMS to each added record, which provides a value that identifies the record (such as a student ID
• Currency: Dollar and cent amounts or numbers containing decimal values
• Date (also called date/time: Month, day, year, and sometimes time
• Memo (also called long text: Lengthy text entries, which may or may not include separate paragraphs
• Yes/No (also called Boolean : Only the values Yes or No (or True or False
• Hyperlink: Email address or web address that links to a webpage on the Internet or document on a network
• Object (also called BLOB , for binary large object: Photo, audio, video, or a document created in other programs or apps, such as word processing or spreadsheet, stored as a sequence of bytes in the database
• Attachment: Document or image that is attached to the field, which can be opened in the program that created the document or image (functions similarly to email attachments
Database software is another term for a DBMS.
True
______ compares data with a set of rules or values to determine if the data meets certain criteria.
Gantt and PERT are types of ______ used to plan and schedule time relationships among project activities.
Each programming language has its own rules, or ______, for writing instructions.
A(n) ______ database stores data in tables that consist of rows and columns.
With the database approach, the data is independent of the programs that access the data.
COGNITIVE ASSESSMENT Which of the following best defines big data?
COGNITIVE ASSESSMENT Which of the following best describes function creep?
The program specification package identifies required programs and the relationship among each program, as well as the input, output, and database specifications.
Many programs today use ______ on a webpage as their front end.
FIP addresses concerns regarding security of information protocols.
In a typical file processing system, each department or area within an organization has its own set of files.
Monitoring system performance is a part of the support and security phase.
In some database programs, a data file is referred to as a(n) ______.
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)