CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. IBM
  5. C2090-320

Free C2090-320 Exam Braindumps (page: 16)

Page 15 of 31
PDF with 124 Questions

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






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

C2090-320 Exam Discussions & Posts