ISM 4212 Exam #2
A information mart is a(n):
A) facts warehouse that is restrained in scope
B) accepted on-line buying site
C) Wal Mart's information warehouse
D) gadget built upon file processing generation. - ANS-A) information warehouse that is
restricted in scope
A data warehouse is a topic-oriented, incorporated, time-variant, non-updatable collection of
records utilized in aid of control selection-making procedures.
True/False - ANS-True
A facts warehouse gives an integrated, business enterprise-huge view of brilliant facts from
various databases.
True/False - ANS-True
A record is desired that lists all clients, the overall in their open/notable orders and consists of
clients who did no longer plaec an order. - ANS-OUTERJOIN declaration/instructions
A trigger can be used as a safety degree wherein of the subsequent approaches?
A) To design a database
B) To motive unique managing techniques to be performed
C) To take a look at for viruses
D) To conduct a statistics waft evaluation - ANS-B) To reason special dealing with methods to
be accomplished
A union join is:
A) A query that compares each row of one desk with every row of another table to discover all
rows of records which fulfill the be a part of situation.
B) A query in which the rows from the two tables that do not have matching values in common
columns are still included inside the result.
C) A question that includes all columns from each table inside the join, and an instance for
every row of each table.
D) None of these alternatives are correct. - ANS-C) A question that includes all columns from
every table within the join, and an example for each row of each table.
An example of Explicit Join Notation is:
A information mart is a(n):
A) facts warehouse that is restrained in scope
B) accepted on-line buying site
C) Wal Mart's information warehouse
D) gadget built upon file processing generation. - ANS-A) information warehouse that is
restricted in scope
A data warehouse is a topic-oriented, incorporated, time-variant, non-updatable collection of
records utilized in aid of control selection-making procedures.
True/False - ANS-True
A facts warehouse gives an integrated, business enterprise-huge view of brilliant facts from
various databases.
True/False - ANS-True
A record is desired that lists all clients, the overall in their open/notable orders and consists of
clients who did no longer plaec an order. - ANS-OUTERJOIN declaration/instructions
A trigger can be used as a safety degree wherein of the subsequent approaches?
A) To design a database
B) To motive unique managing techniques to be performed
C) To take a look at for viruses
D) To conduct a statistics waft evaluation - ANS-B) To reason special dealing with methods to
be accomplished
A union join is:
A) A query that compares each row of one desk with every row of another table to discover all
rows of records which fulfill the be a part of situation.
B) A query in which the rows from the two tables that do not have matching values in common
columns are still included inside the result.
C) A question that includes all columns from each table inside the join, and an instance for
every row of each table.
D) None of these alternatives are correct. - ANS-C) A question that includes all columns from
every table within the join, and an example for each row of each table.
An example of Explicit Join Notation is:
