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: 11)

Page 10 of 31
PDF with 124 Questions

Given the tables:



Which SQL statement would join the tables on product number (prod#) and provide a table of what products (product), if any, the parts (part) are used? Limit the result to only parts where suppliers (supplier) do not start with the letter A.





Answer(s): A



Which of the following are advantages of DB2 for z/OS data sharing over a standalone DB2 subsystem implementation? (Choose two.)

  1. Reduced active logs
  2. Reduced storage use
  3. Higher transaction rates
  4. Reduced lock contention
  5. Increased data availability

Answer(s): C,E



The maximum size for each partition of a partition-by-range table space, with fewer than 255 partitions, is determined by which combination of options? (Choose two.)

  1. DSSIZE
  2. PRIQTY
  3. NUMPARTS
  4. BUFFERPOOL
  5. MAXPARTITIONS

Answer(s): A,C


Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/ db2z_sql_createtablespace.html



Which of the following statements about a system-period temporal table is TRUE?

  1. Rows can be archived into a history table which is always read only
  2. Every row has a pair of timestamps which is set and managed by the application
  3. AN SQL query for auditing can be run against current data or history data, but not both
  4. The table contains only the current active rows

Answer(s): B

Explanation:

In a system-period temporal table, every row has a pair of timestamps, which are set by the DB2 system and recorded in the begin_column and end_column columns. DB2 uses the SYSTEM_TIME period to audit the data changes. It provides the application with the database managed row begin and row end timestamp maintenance, providing non-overlapping time periods with no gaps in time.


Reference:

https://www.ibm.com/developerworks/data/library/techarticle/dm-1410temporal-tables-db2zos/ index.html






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

C2090-320 Exam Discussions & Posts