QUESTION: 37

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

Reveal Solution Next Question

QUESTION: 38

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

Reduced active logs
Reduced storage use
Higher transaction rates
Reduced lock contention
Increased data availability

Answer(s): C,E

Reveal Solution Next Question

QUESTION: 39

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.)

DSSIZE
PRIQTY
NUMPARTS
BUFFERPOOL
MAXPARTITIONS

Answer(s): A,C

Reference:

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

Reveal Solution Next Question

QUESTION: 40

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

Rows can be archived into a history table which is always read only
Every row has a pair of timestamps which is set and managed by the application
AN SQL query for auditing can be run against current data or history data, but not both
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

Reveal Solution Next Question

Free C2090-320 Exam Braindumps (page: 10)

QUESTION: 37

QUESTION: 38

QUESTION: 39

Reference:

QUESTION: 40

Explanation:

Reference: