ISM 4212 Exam 2 - Armstrong
Assuming all 1st regular form necessities are met and you do no longer have a ______ you are
in 2nf. - ANS-Composite PK
Data warehouse have ___________. - ANS-Centralized good judgment.
Give the fundamental form for creating a desk in SQL. - ANS-CREATE TABLE tblname
(columnname1 datatype not null primary key,.....)
How do you upload a FK to a desk? - ANS-ALTER TABLE tblname ADD FOREIGN KEY
(blankid) references tblname2(blankid)
How do you add a number one key it's composite? - ANS-ALTER TABLE xyz ADD
CONSTRAINT xxxxxID primary key (pkname1, pkname2)
how do you create a database? - ANS-CREATE DATABASE dbname
How do you delete a whole desk from a DB? - ANS-DROP TABLE tblname
How do you delete all rows from a desk? - ANS-DELETE FROM tblname
How do you delete positive rows from a desk? - ANS-DELETE FROM tblname WHERE
situation.
How do you insert a complete row of statistics into a table? - ANS-INSERT INTO tblname
VALUES (1, 'Dodgers', '01/02/1980')
How do you insert a partial row of records? - ANS-INSERT INTO tblname (columnname1,
comulmnname2) VALUES ('no',1)
How do you update statistics in a desk? - ANS-UPDATE tblname SET column1 = new price
WHERE circumstance.
If a organization is not satisfied with their commercial enterprise intelligence, in which is the
problem normally mendacity? - ANS-In the information warehouses or facts marts.
What are application programs? - ANS-Software using the records to govern the DB and bring
data to customers.
What are assertions? - ANS-Integrity controls that implement database situations.
, What are authorization regulations?
What do they do? - ANS-Controls which might be integrated into the DBMS.
They furnish get right of entry to, specify which moves and constraints govern the person get
right of entry to.
What are CASE gear? - ANS-Computer aided software engineering. Used to layout DB and
application packages.
What are foreign keys? - ANS-They're identifiers that enable a structured dating (on the various
aspect) to consult its parent relation (on the only side)
What are functions? - ANS-Routines that go back values.
What are logical controls? (examples) - ANS-Hiring practices, worker monitoring, security
schooling, separation of responsibilities.
What are bodily get entry to controls? (EXAMPLES) - ANS-Swipe playing cards, device locking,
display screen placement, and many others.
What are tactics? - ANS-Routines that don't return values.
What are some records mining techniques? - ANS-1. Regression
2. Clustering and signal processing
three. Decision tree
4. Affinity
5. Sequence affiliation
6. Case-primarily based reasoning
7. Rule discovery
8. Fractals
9. Neural nets
What are some restoration centers? - ANS-Backup, Journalizing, Recovery Manager, Chekpoint
What are the benefits of embedded SQL? - ANS-1. Can create greater flexible, on hand
interfaces
2. Possible overall performance improvement
three. DB safety improvement (grant get admission to simplest to application in preference to
customers)
What are the traits of a information call? - ANS-1. Related to enterprise
2. Meaningful
three. Self-documenting
4. Written in popular syntax
Assuming all 1st regular form necessities are met and you do no longer have a ______ you are
in 2nf. - ANS-Composite PK
Data warehouse have ___________. - ANS-Centralized good judgment.
Give the fundamental form for creating a desk in SQL. - ANS-CREATE TABLE tblname
(columnname1 datatype not null primary key,.....)
How do you upload a FK to a desk? - ANS-ALTER TABLE tblname ADD FOREIGN KEY
(blankid) references tblname2(blankid)
How do you add a number one key it's composite? - ANS-ALTER TABLE xyz ADD
CONSTRAINT xxxxxID primary key (pkname1, pkname2)
how do you create a database? - ANS-CREATE DATABASE dbname
How do you delete a whole desk from a DB? - ANS-DROP TABLE tblname
How do you delete all rows from a desk? - ANS-DELETE FROM tblname
How do you delete positive rows from a desk? - ANS-DELETE FROM tblname WHERE
situation.
How do you insert a complete row of statistics into a table? - ANS-INSERT INTO tblname
VALUES (1, 'Dodgers', '01/02/1980')
How do you insert a partial row of records? - ANS-INSERT INTO tblname (columnname1,
comulmnname2) VALUES ('no',1)
How do you update statistics in a desk? - ANS-UPDATE tblname SET column1 = new price
WHERE circumstance.
If a organization is not satisfied with their commercial enterprise intelligence, in which is the
problem normally mendacity? - ANS-In the information warehouses or facts marts.
What are application programs? - ANS-Software using the records to govern the DB and bring
data to customers.
What are assertions? - ANS-Integrity controls that implement database situations.
, What are authorization regulations?
What do they do? - ANS-Controls which might be integrated into the DBMS.
They furnish get right of entry to, specify which moves and constraints govern the person get
right of entry to.
What are CASE gear? - ANS-Computer aided software engineering. Used to layout DB and
application packages.
What are foreign keys? - ANS-They're identifiers that enable a structured dating (on the various
aspect) to consult its parent relation (on the only side)
What are functions? - ANS-Routines that go back values.
What are logical controls? (examples) - ANS-Hiring practices, worker monitoring, security
schooling, separation of responsibilities.
What are bodily get entry to controls? (EXAMPLES) - ANS-Swipe playing cards, device locking,
display screen placement, and many others.
What are tactics? - ANS-Routines that don't return values.
What are some records mining techniques? - ANS-1. Regression
2. Clustering and signal processing
three. Decision tree
4. Affinity
5. Sequence affiliation
6. Case-primarily based reasoning
7. Rule discovery
8. Fractals
9. Neural nets
What are some restoration centers? - ANS-Backup, Journalizing, Recovery Manager, Chekpoint
What are the benefits of embedded SQL? - ANS-1. Can create greater flexible, on hand
interfaces
2. Possible overall performance improvement
three. DB safety improvement (grant get admission to simplest to application in preference to
customers)
What are the traits of a information call? - ANS-1. Related to enterprise
2. Meaningful
three. Self-documenting
4. Written in popular syntax
