1. Which of the following are used to enforce businessrules? A. Enforcers B. Functions C. Constraints D....
Question:
1. Which of the following are used to enforce businessrules?
A. Enforcers B.Functions C. Constraints D. Syntax
2. Which keywords identify a column that, if it contains avalue, it must match data contained in another table?
A. Unique B. Foreignkey C. PrimaryKey D. Check
3. In a "one-to-many" relationship, which constraint is usuallyadded to the "many" table?
A.UNIQUE B.NOT NULL C.PRIMARY KEY D.FOREIGN KEY
4. How can constraints be added to a table?
A.as part of the CREATE TABLE commandB.as part of the ALTER TABLE commandC.as part of the PRIMARY KEY commandD.both a and b
5. Which of the following is the standard abbreviation for theconstraint FOREIGN KEY?
A.fk B.fkeyC.fky D.frk
6. When a constraint is created at the _______ level with theCREATE TABLE command, the constraint definition is simply includedas part of the column definition.
A.row B.tableC.column D.database
7. If a constraint applies to more than one column, theconstraint must be created at the ____ level.
A.column B.rowC.database D.table
8. A PRIMARY KEY that consists of more than one column is calleda(n) ____ key.
A. coherent B. comprehensiveC. composite D. multiple
9. A FOREIGN KEY constraint can only reference a column inanother table that has been assigned a(n) ____ constraint.
A. NOT NULL B. UNIQUEC. CHECK D. none of the above
10. Which of the following can be used to provide analternative, simplified name, to identify database objects?
A. sequence B. indexC. view D. synonym
11. Which command will create a synonym for a table?
A. CREATE SYNONYM synonymname IN tablename;B. CREATE SYNONYM synonymname FOR tablename;C. CREATE SYNONYM synonymname ON tablename;D. CREATE SYNONYM synonymname REFERENCEtablename;
12. Which of the following statements about sequences isincorrect?
A. A sequence can be used to generate sequential values forinternal control purposes.
B. A sequence can be used to generate unique names for databaseobjects.
C. A sequence can be used to generate unique values to serve asa primary key.
D. A sequence can be used to generate sequential numbers totrack records like checks, invoices, and purchase orders.
Expert Answer:
The detailed answer for the above question is provided below Answer 1A C D 2B 3D 4D 5A 6C 7D 8C 9B 10C 11B 12B Explanation A 1 A C D A and C are used to enforce business rules A is an enforcer which i... View the full answer
