Exam Code: C2090-312 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: IBM DB2 11 DBA for z/OS
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-312 Exam.
2021 May C2090-312 Study Guide Questions:
Q21. Which type of stored procedures do NOT require a WLM-managed stored procedure address space?
A. External stored procedures.
B. Native SQL stored procedure.
C. External SQL stored procedures.
D. DB2 supplied stored procedures.
Answer: B
Q22. Consider a logical data model that includes an Employees entity and a Projects entity. In this model, employees work on many projects and projects are worked on by many employees.
The Employees and Projects entity is considered what kind of relationship?
A. A one-to-one relationship.
B. A one-to-many relationship.
C. A many-to-one relationship.
D. A many-to-many relationship.
Answer: D
Q23. What subsystem parameter in DDF specifies the maximum number of inactive or new connections queued that can be waiting for a DBAT to process the request?
A. IDTHTOIN
B. MAXDBAT
C. CONDBAT
D. MAXCONQN
Answer: D
Far out C2090-312 test engine:
Q24. You analyze an accounting report. You see a high "NOT ACCOUNTED" time. Which two events can contribute to this high value?
A. CPU wait time.
B. I/O read wait time.
C. Log write wait time.
D. Real storage paging wait time.
E. Execution unit switch wait time.
Answer: C,E
Q25. Which DB2 subsystem parameter is used to control the number of concurrent inbound DDF connections?
A. MAXDBAT
B. CTHREAD
C. CONDBAT
D. CONTSTOR
Answer: C
Q26. The data of a critical table space seems inconsistent. It is suspected that someone has accidentally issued a DB2 command to start the object with MODE(FORCE).
Where can this be verified?
A. In the DSN1PRNT job output of the header page.
B. In the DB2 MSTR address space joblog as all DB2 commands are shown there.
C. In the DB2 recovery log as all DB2 commands are written to the DB2 recovery log.
D. In the z/OS system log (SYSLOG), as all commands including DB2 commands are written to the z/OS system log.
Answer: B
Real C2090-312 testing engine:
Q27. What is required before you begin your installation of DB2 11?
A. Data sets for catalog and directory tables must be user-managed.
B. Data sets for only the catalog tables must be SMS-managed and include a data class for allocating the data sets in extended format.
C. Data sets for only the directory tables must be SMS-managed and include a data class for allocating the data sets in extended format.
D. Data sets for catalog and directory tables must be SMS-managed and include a data class for allocating the data sets in extended format.
Answer: A
Q28. From where does the cross-loader function allow you to load data?
A. From an input file including all columns.
B. From a cursor including LOB columns but not including XML columns.
C. From a cursor including XML columns but not including LOB columns.
D. From a cursor including all LOB and XML columns except the ROWID column.
Answer: A
Q29. Which technique can be utilized for the reporting of real-time statistics?
A. Call stored procedure SYSPROC.DSNACCOX.
B. Call stored procedure SYSPROC.ADMINJNFOJHOST.
C. Query the SYSI BM.SYSTABSTATS system catalog table.
D. Query the SYSIBM.SYSTABLES_PROFILES system catalog table.
Answer: D
Q30. When defining a check constraint on a populated table and the value of the special register CURRENT RULES is 'DB2’.
What is the result of executing the DDL statement?
A. It is rejected by the database system.
B. The table space is placed in CHKP status.
C. It is checked against only all existing rows in the table.
D. It is checked against only new rows as they are added to the table.
Answer: C