1) You are planning on executing the following SQL statement: SET CONSTRAINTS, INDEXES FOR mytab FILTERING WITH ERROR; Which of the following SQL statements must you execute before running this SET statement? (Choose all that apply) *This question is required

Subject:Computer SciencePrice:2.87 Bought7

Share With

1) You are planning on executing the following SQL statement:

SET CONSTRAINTS, INDEXES FOR mytab FILTERING WITH ERROR;

Which of the following SQL statements must you execute before running this SET statement? (Choose all that apply) *This question is required.

a. START VIOLATIONS TABLE FOR mytab;

b. START DIAGNOSTICS TABLE FOR mytab;

c. GRANT INSERT ON mytab_vio TO PUBLIC;

d. GRANT INSERT ON mytab_dia TO PUBLIC;

2. Which of the following statements applies to enabling a filtering constraint? *This question is required.

a. Existing rows are checked to see if they satisfy the constraint. If any rows do not satisfy the constraint, they are removed from the table

b. Existing rows are checked to see if they satisfy the constraint. If any rows do not satisfy the constraint, an error is returned and the constraint remains disabled

c. Existing rows are not checked to see if they satisfy the constraint

d. A disabled constraint cannot be enabled if the table contains existing rows. The rows must be unloaded, the constraint enabled, and then the rows can be loaded back into the table. If any rows do not satisfy the constraint, they will not be reloaded into the table

 

3. You have just created a new table named test. You issue the following SQL statements:

   REVOKE ALL ON test FROM PUBLIC;
   GRANT SELECT ON TEST TO sam WITH GRANT OPTION;

User sam issues the following SQL statement:

   GRANT SELECT ON TEST TO graham;

Later, you issue the following SQL statement:

   REVOKE SELECT ON TEST FROM sam;

Which of the following statements describes what happens? *This question is required.

a. User sam can SELECT from the TEST table, but user graham cannot

b. User sam can no longer SELECT from the TEST table, but user graham can

c. Users sam and graham can no longer SELECT from the TEST table

d. User sam can SELECT from the TEST table, but cannot grant this privilege to any other user

4. In which areas does OPTCOMPIND influence the Optimizer? *This question is required.

a. In the choice of access plan only

b. In the choice of join plan only

c. In the choice of both access plan and join plan for any isolation level

d. In the choice of both access plan and join plan for isolation level Repeatable Read only