C2090-320 exam

The following definition for COL1 is given by this statement: CREATE TABLE… (COL1 BINARY (05)) Which of the following statements will successfully insert data into the table?A . INSERT INTO… (COL1) VALUES(HEX(‘12345’));B . INSERT INTO… (COL1) VALUES(BLOB(‘12345’));C . INSERT INTO… (COL1) VALUES(CHAR(‘12345’));D . INSERT INTO… (COL1) VALUES(BINARY(‘123456’));View AnswerAnswer: C

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.)A . DSSIZEB . PRIQTYC . NUMPARTSD . BUFFERPOOLE . MAXPARTITIONSView AnswerAnswer: AC Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/ db2z_sql_createtablespace.html

The metadata for which of the following objects is NOT stored in the DB2 catalog table SYSIBM.SYSTABLES?A . A viewB . A temporal tableC . A created global temporary tableD . A declared global temporary tableView AnswerAnswer: B

Which of the following describes OLTP workload rather than an analytics workload?A . Extreme data volumeB . Temporary or intermediate staging of dataC . Set-oriented processing and bulk operationsD . A large number of short, discrete, atomic transactionsView AnswerAnswer: D Explanation: Reference: http://www.ibmbigdatahub.com/sites/default/files/document/IBM-Netezza-Understanding-Analytic-Workloads-eBook.pdf

The DB2 subsystem DSN has been correctly configured to access a remote DB2 location MYREMOTE. Which of the following processes can be used on subsystem DSN to access MYUSER.EMP table at MYREMOTE location?A . SELECT * FROM MYUSEB . EMP;C . CONNECT TO MYREMOTE; SELECT * FROM MYUSED . EMP;E...

Which of the following statements about a table with a LOB column is TRUE?A . It doesn’t need an auxiliary table if it has an inline LOBB . It must also have a ROWID column and an auxiliary tableC . It doesn’t need a ROWID column (implicit or explicit) if...

You are designing a payroll table that will contain a salary column. Which of the following is the appropriate built-in data type for a salary column?A . REALB . BIGINTC . DECIMALD . INTEGERView AnswerAnswer: C Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SS6NHC/ com.ibm.swg.im.dashdb.sql.ref.doc/doc/r0000791.html

Which of the following are contained in the PLAN_TABLE? (Choose two.)A . RUNSTATS recommendationsB . Access to LOB values, which are stored separately from the base tableC . Access to parent or dependent tables needed to enforce referential constraintsD . Whether an index access or table space scan is used...

Given the following CREATE VIEW statement and sample data; your login id is “ROGER”. What will be the result for this query?A . 6B . 5C . 4D . 2View AnswerAnswer: C

Which of the following statements concerning a bi-temporal table is TRUE?A . It provides business history, but is not useful for audit purposesB . It is defined with both an application period and a system periodC . It is useful for audit purposes, but is not useful for business historyD...