MIS 315 UNCW
Storing the same data value in multiple places is known as: - ✔️✔️Data redundancy
The amount pf data that is regularly stored increases over time - ✔️✔️True
Which of the following is an operation that could be used to convert data into
information? - ✔️✔️Sorting, Filtering, Formatting, Graphing (All the above is the
answer)
Which of the following is raw #'s and characters not very useful for decision making? -
✔️✔️Data
Which of the following is the main resource for organizations that provide services? -
✔️✔️Data
A primary key must be: - ✔️✔️both unique and NOT null
An attribute is a characteristic of an entity: - ✔️✔️True
In the data model given, PersonID is an example of a: - ✔️✔️Key
Logical models are typically created by database experts - ✔️✔️False
OLTP - ✔️✔️Online Transaction Processing
SQL stands for: - ✔️✔️Structured Query Language
To change the name of a column in a SELECT clause, you would use - ✔️✔️AS
Based on the column names below, which is likely to be key? - ✔️✔️CustomerID
Based on the name, which of the following is likely an entity? - ✔️✔️Customer
Which of the following is the "blueprint" for the database? - ✔️✔️Physical Model
The WHERE clause is which: - ✔️✔️Rows you would like to see
All WHERE clauses must contain a logical expression. - ✔️✔️True
What does this logical expression evaluate to?
, NOT (35 > 55) - ✔️✔️True
What does this logical expression evaluate to?
(35 < 88) OR (3 IN (1, 2, 3, 5)) - ✔️✔️True
Consider this SQL statement with numbered blanks. What should go into the first blank
area?
SELECT (1)
FROM (2)
WHERE (3)
ORDER BY (4) - ✔️✔️The fields to be displayed.
It is possible to ORDER BY a column that is not listed in the SELECT clause: -
✔️✔️True
The IN statement can be restated as a sequence of OR statements? - ✔️✔️True
What records will be in the result set with this WHERE clause?
SELECT *
FROM Person
WHERE Weight > 120 OR Gender = 'M" - ✔️✔️All men, and anyone else over 120
pound
Which last names will match on this LIKE statement?
LIKE '%n%' - ✔️✔️Both Johnson and Jones
Aggregation is used to perform a calculation over some group of records - ✔️✔️True
HAVING filters groups, whereas WHERE filters records. - ✔️✔️True
The following SELECT statement will return what?
SELECT SUM (weight)
FROM Person - ✔️✔️None of the above
Compared to 50 years ago, todays organizations tend to... - ✔️✔️Have fewer layers in
hierachy
Compared to organizations 50 years ago, the management "span of control" in today's
organization is: - ✔️✔️Larger
Storing the same data value in multiple places is known as: - ✔️✔️Data redundancy
The amount pf data that is regularly stored increases over time - ✔️✔️True
Which of the following is an operation that could be used to convert data into
information? - ✔️✔️Sorting, Filtering, Formatting, Graphing (All the above is the
answer)
Which of the following is raw #'s and characters not very useful for decision making? -
✔️✔️Data
Which of the following is the main resource for organizations that provide services? -
✔️✔️Data
A primary key must be: - ✔️✔️both unique and NOT null
An attribute is a characteristic of an entity: - ✔️✔️True
In the data model given, PersonID is an example of a: - ✔️✔️Key
Logical models are typically created by database experts - ✔️✔️False
OLTP - ✔️✔️Online Transaction Processing
SQL stands for: - ✔️✔️Structured Query Language
To change the name of a column in a SELECT clause, you would use - ✔️✔️AS
Based on the column names below, which is likely to be key? - ✔️✔️CustomerID
Based on the name, which of the following is likely an entity? - ✔️✔️Customer
Which of the following is the "blueprint" for the database? - ✔️✔️Physical Model
The WHERE clause is which: - ✔️✔️Rows you would like to see
All WHERE clauses must contain a logical expression. - ✔️✔️True
What does this logical expression evaluate to?
, NOT (35 > 55) - ✔️✔️True
What does this logical expression evaluate to?
(35 < 88) OR (3 IN (1, 2, 3, 5)) - ✔️✔️True
Consider this SQL statement with numbered blanks. What should go into the first blank
area?
SELECT (1)
FROM (2)
WHERE (3)
ORDER BY (4) - ✔️✔️The fields to be displayed.
It is possible to ORDER BY a column that is not listed in the SELECT clause: -
✔️✔️True
The IN statement can be restated as a sequence of OR statements? - ✔️✔️True
What records will be in the result set with this WHERE clause?
SELECT *
FROM Person
WHERE Weight > 120 OR Gender = 'M" - ✔️✔️All men, and anyone else over 120
pound
Which last names will match on this LIKE statement?
LIKE '%n%' - ✔️✔️Both Johnson and Jones
Aggregation is used to perform a calculation over some group of records - ✔️✔️True
HAVING filters groups, whereas WHERE filters records. - ✔️✔️True
The following SELECT statement will return what?
SELECT SUM (weight)
FROM Person - ✔️✔️None of the above
Compared to 50 years ago, todays organizations tend to... - ✔️✔️Have fewer layers in
hierachy
Compared to organizations 50 years ago, the management "span of control" in today's
organization is: - ✔️✔️Larger
