← Back to exam page

C2090-558 – Informix 11.70 Fundamentals

Loading demo links...

Showing 1–3 of 10 questions

Question 1 (Volume A)

Click the Exhibit button.

C:\Pasban Work\Cert Paper Exams\IBM\000-558\000-558-Extracted\000-558-Extracted\ib558a\55.JPG

The tables shown in the exhibit have been created for a class enrollment system where a course can be assigned to many classes. The class table joins to the course table on the course_num columns. Which two of the following SQL statements are required to establish a referential integrity relationship between these tables? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    ALTER TABLE class ADD CONSTRAINT (PRIMARY KEY (class_id));
  • ○

    ALTER TABLE class ADD CONSTRAINT (PRIMARY KEY (course_num));
  • ○

    ALTER TABLE course ADD CONSTRAINT (PRIMARY KEY (course_num));
  • ○

    ALTER TABLE class ADD CONSTRAINT (FOREIGN KEY (course_num) REFERENCES course);
  • ○

    ALTER TABLE course ADD CONSTRAINT (FOREIGN KEY (course_num) REFERENCES class);
Question 2 (Volume B)

What are the three major steps in implementing Label-Based Access Control (LBAC) in an instance environment? (Choose three.)

Select all that apply, then click Submit answer.

  • ○

    Define a security policy with access rules.
  • ○

    Assign security labels to users and data elements
  • ○

    Create security label definitions using set, tree, and/or array components
  • ○

    Disable role separation since LBAC supersedes anything role separation might provide and it interferes with LBAC.
  • ○

    Create and install either general or user-specific sysdbopen() functions so that LBAC is active when users connect to the instance.
Question 3 (Volume B)

Which two statements cause Stored Procedure Language (SPL) routine optimization? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    CALL PROCEDURE
  • ○

    CREATE PROCEDURE
  • ○

    OPTIMIZE PROCEDURE
  • ○

    EXECUTE PROCEDURE
  • ○

    UPDATE STATISTICS FOR PROCEDURE