Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home IBM C2090-616

IBM C2090-616 Exam Practice Questions (P. 3)

  • Full Access (63 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #11
Which of the following statements about triggers are TRUE? (Choose two.)
  1. A
    There is a limit of 8 for the maximum number of cascading trigger activations
  2. B
    Triggers can be activated as a result of changes due to referential constraint enforcement
  3. C
    Multiple INSTEAD OF triggers are allowed for each kind of operation on a given subject view
  4. D
    Constraints associated with a subject table are applied between execution of BEFORE and AFTER triggers
  5. E
    The activation of the triggers for a particular table, event and activation time are conducted in descending order of trigger creation time

Correct Answer:
BD
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0004113.html

Question #12
Which of the following is TRUE about indexes on column organized tables?
  1. A
    No indexes are allowed
  2. B
    Indexes are only allowed on numeric columns
  3. C
    Indexes are automatically created to enforce unique constraints
  4. D
    An index is only allowed on the synopsis table supporting a column organized table

Correct Answer:
A

Question #13
How can you tell what privileges on a table or view have been granted to a user? (Choose two.)
  1. A
    db2look with the ""x option
  2. B
    db2pd with the ""auth option
  3. C
    Query the SYSCAT.DBAUTH view
  4. D
    Query the SYSCAT.TABLES view
  5. E
    Query the SYSCAT.TABAUTH view CE

Correct Answer:
Explanation
Reference: https://www.ibm.com/support/knowledgecenter/hr/SSEPGG_9.7.0/com.ibm.db2.luw.admin.sec.doc/doc/t0005823.html

Question #14
The following statements are executed:
GRANT CREATETAB, DATAACCESS, ON DATABASE TO ROLE role A;
GRANT CREATETAB, BINDADD ON DATABASE TO ROLE role B;
GRANT ROLE role A to USER db2inst3;
GRANT ROLE role B to USER db2inst3;
Which of the following is TRUE if this statement is executed later?
REVOKE ROLE roleB FROM USER db2inst3;
  1. A
    This statement will succeed and DB2 INST3 will still be able to create in the database
  2. B
    This statement will succeed and DB2 INST3 only retains DATAACCESS privileges on the database
  3. C
    This statement will fail as CREATETAB is granted to two different roles and must be revoked at the same time
  4. D
    This statement will succeed with a warning since CREATETAB cannot be totally revoked. DB2INST3 will retain both roles

Correct Answer:
D

Question #15
Consider the following sequence of events:
Eddie grants SELECT WITH GRANT OPTION privilege to Mike.
Mike grants SELECT privilege to Jeff.
Eddie revokes SELECT privilege from Mike.
What will happen to Jeff's SELECT privilege?
  1. A
    Jeff's SELECT privilege will be revoked
  2. B
    Jeff's SELECT privilege will be retained
  3. C
    Jeff's SELECT privilege will be retained only if he has ACCESSCTRL authority
  4. D
    Jeff's SELECT privilege will be retained only if Eddie has ACCESSCTRL authority

Correct Answer:
A
Reference: https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_0125.htm

Previous Questions Next Questions

All Pages