ACCTMIS 3600 Exam 1 SG || with Complete Solution.
relational data model correct answers A two-dimensional table representation of data; each row
represents a unique entity (record) and each column is a field where record attributes are stored.
Data differ from information in which way? correct answers Information is data organized to
provide meaning
As a new sales manager, Sylvia is processing the monthly sales report numbers to determine the
top three salespersons of the year. At which stage of the DIKW hierarchy is Sylvia working?
correct answers Information
Which of the following is not a characteristic that makes information useful? correct answers It
is inexpensive
In which cycle does a company ship goods to customers? correct answers revenue cycle
Which of the following is a function of an AIS? correct answers Transforming data into useful
information
Which of the following is not a step in the data processing cycle? correct answers Data survey
design
Which of the following is not an advantage of an ERP system? correct answers Simplicity and
reduced costs
How does the chart of accounts list general ledger accounts? correct answers The order in which
they appear in financial statements
Which of the following is a primary activity in the value chain? correct answers Post-sales
service
,In the value-chain concept, upgrading IT is considered what kind of activity? correct answers
support activity
The term data generally refers to: correct answers raw facts about concrete or abstract entities
and events
A database management system is correct answers a software system that facilitates the process
of defining, constructing, manipulating and controlling a database for various applications.
The teacher of a class of third graders records the height of each student. Indicate which level of
measurement is being used in this scenario correct answers Ratio
"Customer satisfaction" measured on a 3-point scale (negative, neutral, positive) is an example of
an attribute/variable that is correct answers discrete, qualitative, ordinal
In a database table, the field or fields that uniquely identify a record is referred to as: correct
answers Primary key
This is a collection of data items organized as a set of formally-described tables from which data
can be accessed or reassembled in many different ways without having to reorganize the
database tables. correct answers relational database
A database query is correct answers a question you pose to the database system
Which of the following is not a property of the mathematical concept of a "set": correct answers
there is a foreign key in each element that refers to the primary key of that element
The term Data Warehouse is used to refer to: correct answers an enterprise-level archival
database designed and fine-tuned for analysis and decision making
, Unlike traditional databases, a data warehouse is correct answers tends to have a broad,
enterprise-wide scope
SQL is a programming language. correct answers false
What is each row in a relational database called? correct answers tuple
Which of the following attributes would most likely be a primary key? correct answers supplier
number
To select records with strings that match a wildcard value, use the following keyword in your
filter: correct answers LIKE
Which of the following is not a basic requirement of a relational database? correct answers -
Foreign keys, if not null, must have values that correspond to the value of some other primary
key in another table
- Every column in a row must be single valued
- All non-key attributes in a table should describe a characteristic about the object identified by
the primary key
- Primary keys cannot be null
Which of the following clauses properly filters the rows in an (SQL) query to values greater than
3 in field Field4 from Table3? correct answers WHERE Table3.Field4 >3
The constraint that all foreign keys must have either null values or the value of a primary key in
another table is referred to as which of the following? correct answers referential integrity rule
The relational data model portrays data as being stored in ________. correct answers tables
relational data model correct answers A two-dimensional table representation of data; each row
represents a unique entity (record) and each column is a field where record attributes are stored.
Data differ from information in which way? correct answers Information is data organized to
provide meaning
As a new sales manager, Sylvia is processing the monthly sales report numbers to determine the
top three salespersons of the year. At which stage of the DIKW hierarchy is Sylvia working?
correct answers Information
Which of the following is not a characteristic that makes information useful? correct answers It
is inexpensive
In which cycle does a company ship goods to customers? correct answers revenue cycle
Which of the following is a function of an AIS? correct answers Transforming data into useful
information
Which of the following is not a step in the data processing cycle? correct answers Data survey
design
Which of the following is not an advantage of an ERP system? correct answers Simplicity and
reduced costs
How does the chart of accounts list general ledger accounts? correct answers The order in which
they appear in financial statements
Which of the following is a primary activity in the value chain? correct answers Post-sales
service
,In the value-chain concept, upgrading IT is considered what kind of activity? correct answers
support activity
The term data generally refers to: correct answers raw facts about concrete or abstract entities
and events
A database management system is correct answers a software system that facilitates the process
of defining, constructing, manipulating and controlling a database for various applications.
The teacher of a class of third graders records the height of each student. Indicate which level of
measurement is being used in this scenario correct answers Ratio
"Customer satisfaction" measured on a 3-point scale (negative, neutral, positive) is an example of
an attribute/variable that is correct answers discrete, qualitative, ordinal
In a database table, the field or fields that uniquely identify a record is referred to as: correct
answers Primary key
This is a collection of data items organized as a set of formally-described tables from which data
can be accessed or reassembled in many different ways without having to reorganize the
database tables. correct answers relational database
A database query is correct answers a question you pose to the database system
Which of the following is not a property of the mathematical concept of a "set": correct answers
there is a foreign key in each element that refers to the primary key of that element
The term Data Warehouse is used to refer to: correct answers an enterprise-level archival
database designed and fine-tuned for analysis and decision making
, Unlike traditional databases, a data warehouse is correct answers tends to have a broad,
enterprise-wide scope
SQL is a programming language. correct answers false
What is each row in a relational database called? correct answers tuple
Which of the following attributes would most likely be a primary key? correct answers supplier
number
To select records with strings that match a wildcard value, use the following keyword in your
filter: correct answers LIKE
Which of the following is not a basic requirement of a relational database? correct answers -
Foreign keys, if not null, must have values that correspond to the value of some other primary
key in another table
- Every column in a row must be single valued
- All non-key attributes in a table should describe a characteristic about the object identified by
the primary key
- Primary keys cannot be null
Which of the following clauses properly filters the rows in an (SQL) query to values greater than
3 in field Field4 from Table3? correct answers WHERE Table3.Field4 >3
The constraint that all foreign keys must have either null values or the value of a primary key in
another table is referred to as which of the following? correct answers referential integrity rule
The relational data model portrays data as being stored in ________. correct answers tables
