WGU D322 INTRODUCTION TO IT
EXAMS WITH ACTUAL CORRECT
QUESTIONS AND VERIFIED
DETAILED ANSWERS ALREADY
GRADED A+ GUARANTEED PASS
Language Translators
A program that takes one program, written in a high level language, and creates a machine language
program as output
Compiled Language
Translates the entire program using a compiler, creating an executable program which can be run at a
later time; the program can then be run as many times as one likes, without having to re-translate each
time.
Interpreted Language
Takes the most recently entered instruction, translates it into machine language, and executes it; must
be translated manually each time.
Script
A computer language with a series of commands within a file that is capable of being executed without
being compiled.
Algorithms
A formula or procedure for solving a problem. Can also be described as a set of steps that are followed
in order to complete a process
Multi-tier Development
Separation of different aspect of a system
N-tier Development
,Often used to indicate that the number of tiers a system will be broken down into will vary between
different software development projects
Presentation Tier
Tier where the user interface for the system is developed; shields the user from the underlying logic of
the systems as well as the underlying data structures
Logic Tier
Tier that sits between the user interface and the data.
Data Tier
Tier where data is stored, retrieved and updated from database tables
Model-View-Controller (MVC)
A development technique used in the implementation of user interfaces
The Model
Can take on different forms depending on the complexity of the application; in certain instances, it is an
actual object that is an actual implementation of the application
The View
The part of the application that represents the user interface; used to capture input from the user to be
passed on via the controller to the model
The Controller
The part of an application that interacts with the user and passes the user requests to the model
Data Validation
Ensuring that users enter the correct data type
String Data
Alphanumeric or text character
Floating-point
Number with a decimal point
Boolean/Logical
True/False; applying AND/OR when searching for data.
Flat File Database
One large single table; used if the amount of data that is being recorded is fairly minimal
Relational Database
, Has multiple tables (relations) with interrelated fields; most common structure for databases
Hierarchical Database
Organizes data using a tree like or organizational chart type structure
Database Management System (DBMS)
Used to create, manipulate, and access the data in a database
Relation
Often presented as a table; for example: name and phone number
Tuples
Rows of a relation in a database
Attributes
Columns of the relation
Field
Contains the data of an attribute for a record within a relation
Query
A search of data in the relation or relations that fit specific parameters
Projection
A query that returns all of the records from the relation, but only select attributes or fields
Sort
Sorting records based on some field(s) such as ascending order by last name
Join
Withdraws information from multiple relations and combines them.
Primary Key
A field in the relations that contains a unique value, such as a license plate, phone number, or Social
Security Number.
Business Intelligence
A specific information system to help an organization reach its strategic goals
Data Warehouse
A collection of organized databases
Database Information Processing (OLAP)
EXAMS WITH ACTUAL CORRECT
QUESTIONS AND VERIFIED
DETAILED ANSWERS ALREADY
GRADED A+ GUARANTEED PASS
Language Translators
A program that takes one program, written in a high level language, and creates a machine language
program as output
Compiled Language
Translates the entire program using a compiler, creating an executable program which can be run at a
later time; the program can then be run as many times as one likes, without having to re-translate each
time.
Interpreted Language
Takes the most recently entered instruction, translates it into machine language, and executes it; must
be translated manually each time.
Script
A computer language with a series of commands within a file that is capable of being executed without
being compiled.
Algorithms
A formula or procedure for solving a problem. Can also be described as a set of steps that are followed
in order to complete a process
Multi-tier Development
Separation of different aspect of a system
N-tier Development
,Often used to indicate that the number of tiers a system will be broken down into will vary between
different software development projects
Presentation Tier
Tier where the user interface for the system is developed; shields the user from the underlying logic of
the systems as well as the underlying data structures
Logic Tier
Tier that sits between the user interface and the data.
Data Tier
Tier where data is stored, retrieved and updated from database tables
Model-View-Controller (MVC)
A development technique used in the implementation of user interfaces
The Model
Can take on different forms depending on the complexity of the application; in certain instances, it is an
actual object that is an actual implementation of the application
The View
The part of the application that represents the user interface; used to capture input from the user to be
passed on via the controller to the model
The Controller
The part of an application that interacts with the user and passes the user requests to the model
Data Validation
Ensuring that users enter the correct data type
String Data
Alphanumeric or text character
Floating-point
Number with a decimal point
Boolean/Logical
True/False; applying AND/OR when searching for data.
Flat File Database
One large single table; used if the amount of data that is being recorded is fairly minimal
Relational Database
, Has multiple tables (relations) with interrelated fields; most common structure for databases
Hierarchical Database
Organizes data using a tree like or organizational chart type structure
Database Management System (DBMS)
Used to create, manipulate, and access the data in a database
Relation
Often presented as a table; for example: name and phone number
Tuples
Rows of a relation in a database
Attributes
Columns of the relation
Field
Contains the data of an attribute for a record within a relation
Query
A search of data in the relation or relations that fit specific parameters
Projection
A query that returns all of the records from the relation, but only select attributes or fields
Sort
Sorting records based on some field(s) such as ascending order by last name
Join
Withdraws information from multiple relations and combines them.
Primary Key
A field in the relations that contains a unique value, such as a license plate, phone number, or Social
Security Number.
Business Intelligence
A specific information system to help an organization reach its strategic goals
Data Warehouse
A collection of organized databases
Database Information Processing (OLAP)
