Free C2090-320 Exam Braindumps
DB2 11 Fundamentals for z/OS exam Questions 56–60 (page: 13)

A summary table can be easily maintained using which of the following?

  1. An auxiliary table
  2. A partitioned table
  3. A bi-temporal table
  4. A materialized query table

Answer(s): D


Reference:

http://www.informit.com/articles/article.aspx?p=2755707&seqNum=3



In the parent table of a referential constraint, a parent key must be which of the following? (Choose two.)

  1. A unique key
  2. A foreign key
  3. A primary key
  4. A duplicate key
  5. A secondary key

Answer(s): A,C


Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/ com.ibm.db2.luw.admin.dbobj.doc/doc/c0020153.html



How can a stored procedure be invoked?

  1. Via an SQL SELECT statement
  2. Via a CALL statement using SPUFI
  3. Directly via a RUN PROGRAM command
  4. Via a CALL statement from within an application program

Answer(s): D


Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/ db2z_sql_call.html



Consider the following scenario:
User1 creates table USER1.TABLE1 in DATABASE1
User1 grants ALL PRIVILEGES on TABLE1 to User2
User2 grants ALL PRIVILEGES on TABLE1 to User3
User1 revokes ALL PRIVILEGES on TABLE1 to User2
User3 has DBCTRL authority on DATABASE1

Is User3 able to retrieve rows from TABLE1?

  1. No
  2. Yes
  3. No, if the revoke used INCLUDING DEPENDENT PRIVILEGES
  4. Yes, if User3 was granted DBCTRL prior to the creation of table USER1.TABLE1

Answer(s): B



Given the following INDEX definition, which attributes apply to this index? (Choose two.)

  1. The index is partitioned
  2. The index data sets are user-managed
  3. The index data sets are DB2-managed
  4. The index is unique and in ascending order
  5. The maximum total size of the index is 1 GB

Answer(s): A,B



Viewing page 13 of 26
Viewing questions 61 - 65 out of 124 questions


Post your Comments and Discuss IBM C2090-320 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!