A table has had check constraint enforcement turned off, and additional data has been inserted. Which of the following will perform data validation to ensure that column values are valid?
A. Add a trigger
B. Collect statistics
C. Reorganize the table
D. Enable check constraints
A user creates the table TABLE1 with a referential constraint defined over column COL1. Which of the following statements would explicitly give USER1 the ability to read rows from the table?
A. GRANT SELECT ON TABLE table1 TO user1
B. GRANT ACCESS ON TABLE table1 TO user1
C. GRANT REFERENCES TO user1 ON TABLE table1
D. GRANT UPDATE (col1) TO user1 ON TABLE table1
我的答案是 A,C但是觉得不太正确,各位指点一二
1. d, check SET INTEGRITY statement
2. A, abviously b/d are not valid. REFERENCES is used to reference another table, it has nothing to do with READ from TABLE1.