ISM 4212 final
A constraint that states that the overseas key values of a table need to fit the number one key
values of a related desk is called: - ANS-referential integrity
a statistics mart is a: - ANS-records warehouse this is confined in scope
a records warehouse is a subject-oriented, incorporated, time-version, non-updatable collection
of statistics used in help of management choice-making proccesses - ANS-proper
a statistics warehouse is important for agencies for all the following reasons EXCEPT:
-can not have stronger enterprise intelligence with out it
-its unbiased of the organisation's enterprise strategy
-saves time (all facts in a single location)
-complements information satisfactory and consistency (standardizing more than one db) -
ANS-its independent of the enterprise's enterprise method
a records warehouse presents an included, enterprise-huge view of great data from various
databases - ANS-real
a relational database management gadget (DBMS) is a software package deal that manages
the relationship among the database and the schema - ANS-false
a trigger can be used as a protection degree wherein of the subsequent approaches?
-to motive special coping with processes to be done
-to layout a database
-to check for viruses
-to conduct a statistics drift evaluation - ANS-to reason unique managing approaches to be
accomplished
a union be a part of is: - ANS-a question that includes all columns from each table in the be a
part of, and an instance for each row of every table
all of the following statements approximately an inner be part of are actual EXCEPT:
-all of them are genuine
-the keyword SELECT must be included in the square declaration
-rows have to have matching values which will appear in the result
-the question groups each row of table A with every row of desk B to discover all pairs of rows
which satisfy the be a part of circumstance - ANS-all of these are genuine
A constraint that states that the overseas key values of a table need to fit the number one key
values of a related desk is called: - ANS-referential integrity
a statistics mart is a: - ANS-records warehouse this is confined in scope
a records warehouse is a subject-oriented, incorporated, time-version, non-updatable collection
of statistics used in help of management choice-making proccesses - ANS-proper
a statistics warehouse is important for agencies for all the following reasons EXCEPT:
-can not have stronger enterprise intelligence with out it
-its unbiased of the organisation's enterprise strategy
-saves time (all facts in a single location)
-complements information satisfactory and consistency (standardizing more than one db) -
ANS-its independent of the enterprise's enterprise method
a records warehouse presents an included, enterprise-huge view of great data from various
databases - ANS-real
a relational database management gadget (DBMS) is a software package deal that manages
the relationship among the database and the schema - ANS-false
a trigger can be used as a protection degree wherein of the subsequent approaches?
-to motive special coping with processes to be done
-to layout a database
-to check for viruses
-to conduct a statistics drift evaluation - ANS-to reason unique managing approaches to be
accomplished
a union be a part of is: - ANS-a question that includes all columns from each table in the be a
part of, and an instance for each row of every table
all of the following statements approximately an inner be part of are actual EXCEPT:
-all of them are genuine
-the keyword SELECT must be included in the square declaration
-rows have to have matching values which will appear in the result
-the question groups each row of table A with every row of desk B to discover all pairs of rows
which satisfy the be a part of circumstance - ANS-all of these are genuine
