IBM C2090-320 DB2 11 Fundamentals for z/OS exam Online Training
IBM C2090-320 Online Training
The questions for C2090-320 were last updated at Nov 22,2024.
- Exam Code: C2090-320
- Exam Name: DB2 11 Fundamentals for z/OS exam
- Certification Provider: IBM
- Latest update: Nov 22,2024
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 . REAL
- B . BIGINT
- C . DECIMAL
- D . INTEGER
Which package level privileges does the user smith have when the following statement is executed?
GRANT ALL ON PACKAGE clct1.pkg1 TO smith;
- A . GRANT, COPY, BIND, RUN
- B . BIND, EXECUTE, COPY, RUN
- C . CREATE, COPY, RUN, EXECUTE
- D . COPY, BINDADD, SQL, EXECUTE
Which of the following can activate a trigger?
- A . A row is inserted
- B . A table or view is created
- C . A check constraint is defined
- D . A referential constraint is violated
In which address space would a native SQL stored procedure run?
- A . WLM
- B . DIST
- C . DBM1
- D . The address space of the calling program
You want to see all messages that were generated by one specific DB2 subsystem such as log switches and timeout messages.
Which job log would show all of these?
- A . MSTR
- B . DBM1
- C . DIST
- D . IRLM
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 LOB
- B . It must also have a ROWID column and an auxiliary table
- C . It doesn’t need a ROWID column (implicit or explicit) if a LOB locator will be used
- D . It must be in a partitioned by growth (PBG) universal table space with a ROWID column
Which catalog table provides information about the validity of a bound package?
- A . SYSIBM.SYSPACKLIST
- B . SYSIBM.SYSPACKAGE
- C . SYSIBM.SYSPACKDEP
- D . SYSIBM.SYSPACKAUTH
Which of the following statements concerning a bi-temporal table is TRUE?
- A . It provides business history, but is not useful for audit purposes
- B . It is defined with both an application period and a system period
- C . It is useful for audit purposes, but is not useful for business history
- D . It contains data reflecting two different times C current time and one previous time
What is the result XQuery FLWOR expression when running the following scenario?
- A . Joe Smith
- B . <name> Joe Smith </name>
- C . <employeeinfo><name> Joe Smith </name></employeeinfo>
- D . <name> Joe Smith </name><department name>DB2</department name>
Given the following table and index definitions, what type of index will be created?
- A . Non-partitioned index
- B . Non-partitioned secondary index
- C . Data-partitioned secondary index
- D . Data-partitioned partitioning index
Latest C2090-320 Dumps Valid Version with 123 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
