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? – ANSWERAll 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
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)