UTA INSY 2303 FINAL CERTIFICATION
SCRIPT 2026 QUESTIONS WITH SOLUTIONS
GRADED A+
◍ Syntax/Run-Time/Logic Errors.
Answer: Syntax: Refers to the grammar rules that create valid program
statementsRun Time:An error that occurs when a computer program is run.
Logic Errors:A run-time error in the logic or design of a computer program.
◍ parallel processing.
Answer: The simultaneous use of more than one processor to execute a
program.
◍ TPS vs. DSS.
Answer: A transaction processing system is a system that keeps track of
transactions for an organization by providing ways to collect, display,
modify, and cancel transactions, and a decision support system is a
computer system that allows decision makers to manipulate data directly, to
incorporate data from external sources, and to create data models or
"what-if" scenarios
◍ Attribute.
Answer: In the context of object-oriented programming, a characteristic that
defines the members of a class. Similar to a field in a database
◍ 4G.
Answer: Computers, such as today's personal computers, servers, and
mainframes, that use a general-purpose microprocessor for data processing.
◍ serial processing.
Answer: Processing data one instruction at a time, completing one
instruction before beginning another
,◍ Systems Analyst.
Answer: A computer professional responsible for analyzing requirements,
designing information systems, and supervising the implementation of new
information systems.
◍ Mini computer.
Answer: a computer of medium power, more than a microcomputer but less
than a mainframe.
◍ Encapsulation.
Answer: An object-oriented technique in which the internal details of an
object are "hidden" in order to simplify their use and reuse.
◍ memory leak.
Answer: An undesirable state in which a program requests memory but
never releases it, which can eventually prevent other programs from running
◍ Convergence.
Answer: a process by which several technologies with distinct
functionalities evolve to form a single product
◍ LAN.
Answer: Local area networks are often referred to as LANs. They are
designed to provide connectivity for devices within a limited area, typically
within the premises of a home, office building, business, or school.
◍ Operating System.
Answer: The software that controls the computer's use of its hardware
resources, such as memory and disk storage space. Also called an OS.
◍ Declarative Paradigm (pg. 803,804).
Answer: An approach to the programming process in which a programmer
writes a program by specifying a set of statements and rules that define the
conditions for solving a problem.
◍ Knowledge Base.
Answer: The collection of facts and rules obtained from experts that are
, incorporated into an expert system
◍ What the design phase of a SDLC.
Answer: The third phase describes the necessary specifications, features and
operations that will satisfy the functional requirements of the proposed
system which will be in place
◍ SQL/SQL Commands.
Answer: • CREATE - An SQL command that produces a new table in a
database.• INSERT - An SQL keyword that adds a record to a table.•
UPDATE - An SQL keyword used to alter the values in a database record.•
DELETE - An SQL keyword that removes a record from a table.• JOIN -
An SQL command that temporarily joins data from more than one table in
order to allow simultaneous access to both tables.• SELECT - An SQL
keyword that queries for a particular record or group of records from a table.
◍ OLAP.
Answer: provides a way to collect, process, store, display, modify, or cancel
transactions
◍ Batch Processing vs. OLTP.
Answer: Batch processing is a processing system that involves holding a
group of transactions for processing until the end of a specified period of
time, whereas online transaction processing is an interactive online
transaction processing methods that use a "commit or rollback" strategy to
ensure accurate transaction processing
◍ Magnetic Storage.
Answer: A technology for recording data onto disks or tape by magnetizing
particles of an oxide-based surface coating.
◍ ERP.
Answer: suite of software modules that integrate major business activities
◍ SQL Key words.
Answer: You use the keywords to construct statements known as
queriesQueries are sent to the DBMS as instructions to process dataThe
SCRIPT 2026 QUESTIONS WITH SOLUTIONS
GRADED A+
◍ Syntax/Run-Time/Logic Errors.
Answer: Syntax: Refers to the grammar rules that create valid program
statementsRun Time:An error that occurs when a computer program is run.
Logic Errors:A run-time error in the logic or design of a computer program.
◍ parallel processing.
Answer: The simultaneous use of more than one processor to execute a
program.
◍ TPS vs. DSS.
Answer: A transaction processing system is a system that keeps track of
transactions for an organization by providing ways to collect, display,
modify, and cancel transactions, and a decision support system is a
computer system that allows decision makers to manipulate data directly, to
incorporate data from external sources, and to create data models or
"what-if" scenarios
◍ Attribute.
Answer: In the context of object-oriented programming, a characteristic that
defines the members of a class. Similar to a field in a database
◍ 4G.
Answer: Computers, such as today's personal computers, servers, and
mainframes, that use a general-purpose microprocessor for data processing.
◍ serial processing.
Answer: Processing data one instruction at a time, completing one
instruction before beginning another
,◍ Systems Analyst.
Answer: A computer professional responsible for analyzing requirements,
designing information systems, and supervising the implementation of new
information systems.
◍ Mini computer.
Answer: a computer of medium power, more than a microcomputer but less
than a mainframe.
◍ Encapsulation.
Answer: An object-oriented technique in which the internal details of an
object are "hidden" in order to simplify their use and reuse.
◍ memory leak.
Answer: An undesirable state in which a program requests memory but
never releases it, which can eventually prevent other programs from running
◍ Convergence.
Answer: a process by which several technologies with distinct
functionalities evolve to form a single product
◍ LAN.
Answer: Local area networks are often referred to as LANs. They are
designed to provide connectivity for devices within a limited area, typically
within the premises of a home, office building, business, or school.
◍ Operating System.
Answer: The software that controls the computer's use of its hardware
resources, such as memory and disk storage space. Also called an OS.
◍ Declarative Paradigm (pg. 803,804).
Answer: An approach to the programming process in which a programmer
writes a program by specifying a set of statements and rules that define the
conditions for solving a problem.
◍ Knowledge Base.
Answer: The collection of facts and rules obtained from experts that are
, incorporated into an expert system
◍ What the design phase of a SDLC.
Answer: The third phase describes the necessary specifications, features and
operations that will satisfy the functional requirements of the proposed
system which will be in place
◍ SQL/SQL Commands.
Answer: • CREATE - An SQL command that produces a new table in a
database.• INSERT - An SQL keyword that adds a record to a table.•
UPDATE - An SQL keyword used to alter the values in a database record.•
DELETE - An SQL keyword that removes a record from a table.• JOIN -
An SQL command that temporarily joins data from more than one table in
order to allow simultaneous access to both tables.• SELECT - An SQL
keyword that queries for a particular record or group of records from a table.
◍ OLAP.
Answer: provides a way to collect, process, store, display, modify, or cancel
transactions
◍ Batch Processing vs. OLTP.
Answer: Batch processing is a processing system that involves holding a
group of transactions for processing until the end of a specified period of
time, whereas online transaction processing is an interactive online
transaction processing methods that use a "commit or rollback" strategy to
ensure accurate transaction processing
◍ Magnetic Storage.
Answer: A technology for recording data onto disks or tape by magnetizing
particles of an oxide-based surface coating.
◍ ERP.
Answer: suite of software modules that integrate major business activities
◍ SQL Key words.
Answer: You use the keywords to construct statements known as
queriesQueries are sent to the DBMS as instructions to process dataThe
