UTA INSY 2303 EXAM 3 LATEST 2023-2024 REAL
EXAM 160 QUESTIONS AND CORRECT
ANSWERS|AGRADE
The goal of the planning phase for an information system project is to create a(n) ___. - ANSWER- Project Development Plan
A transaction processing system is characterized by its ability to: - ANSWER- All of them (Collect, display, and modify a transaction. Store transactions. List transactions.)
The process of designing, entering, and testing the rules in an expert system is referred to as ____. - ANSWER- Knowledge Engineering
The planning phase of a SDLC includes all of the following except ____. - ANSWER- Writing a requirements report
The scope of an information system includes which of the following? - ANSWER- All of them. (computers, communications network, and data. People and projects.Policies and procedures.
A hierarchical data base allows one to many relationships but not one to one relationships. - ANSWER- False
The goal of normalization is to minimize data redundancy. - ANSWER- True
Modern database tools support ___. Which entails separating data from the programs that manipulate data. - ANSWER- Independence
A computed ___ is a calculation that a DBMS performs. Similar to the way a spreadsheet computes a formula. - ANSWER- Field
The acronym ___ refers to the software that manages data stored in a database. -
ANSWER- DBSM
A(n) _____ is a field that contains data unique to a record - ANSWER- Primary Key
- / 2
Which of the following would not be considered a database data type? -
ANSWER- SELECT
Which SQL keyword is used to search for records? - ANSWER- SELECT
A(n) ___ database is used to collect data that will be used for spotting trends that offer insights. - ANSWER- Analytical
The relationship between record types can be depicted graphically with a(n) ___. -
ANSWER- ERD
The SQL ___ command allows you to temporarily join and simultaneously access the data in more than one table; - ANSWER- JOIN
In a database, a(n) ___ contains the smallest unit of meaningful information. - ANSWER- Field
A simple example of a repetition control structure is the if...else command. - ANSWER- False
A low-level language uses command words and grammar based on human languages. - ANSWER- False
Algorithms are usually written in a format that is specific to a particular programming language. - ANSWER- False
Process of planning a computer program begins with a problem statistic that clearly defines the program's purpose - ANSWER- True
Prolog and other declarative languages were classified as fifth-generation languages - ANSWER- True
Generally speaking, in an object-oriented program the objects don't interact - ANSWER- False
In prolog, the __ describes the relationship between __. - ANSWER- Predicate, Argument
Which of the following is a scripting language? - ANSWER- All of them (ruby, perl, PHP)
- / 2