question archive 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
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
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
Purchase A New Answer
Custom new solution created by our subject matter experts
GET A QUOTE
Answer Preview
Answer:
- SET CONSTRAINTS, INDEXES FOR mytab FILTERING WITH ERROR Statement allows you to set constraints and indices on the table named mytab.A constraint or unique index in a filtering mode can insert into an associated violations table any rows that fail to comply with the constraint or index during DML operation.so before running above statement, we have to run following statement START VIOLATIONS TABLE FOR mytab. This will create a violation table for table mytab.This mode supports WITH ERROR and WITHOUT ERROR options for processing referential-integrity violations from INSERT, DELETE, MERGE, and UPDATE statements.
- By enabling filtering constraints the database server enforces the constraint or the unique-index requirement by writing any failed rows to the violations table.
- REVOKE ALL ON test FROM PUBLIC; This line will revoke al permission granted to the public for this table.
GRANT SELECT ON TEST TO sam WITH GRANT OPTION; This line grant select permission to a user named SAM.With this, he can run the various query on the table also grant permission to others as he has grant option also.GRANT SELECT ON TEST TO Graham Through this statements sam intended to grant select permission to Graham as he has the authorization to select and grant permission.So till now, Grahm have select authorization while Sam has select and grant authorization.In next statement, select permission has been revoked from sam so now he has only grant permission.So final conclusion is that Sam doesn't have select permission but have grant permission and Graham have only select permission. - OPTCOMPIND is a configuration parameter in Informix DB server.OPTCOMPIND is used to specify information that helps the optimizer choose an appropriate query plan for your application.It has three values to be set o,1 and 2.So OPTCOMPIND influences the nature of hash joins and isolation level.By setting OPTCOMPIND to 0 you had the chance to force the optimizer to do whatever you wanted.
