IBM C2090-320 DB2 11 Fundamentals for z/OS Dumps

C2090-320 DB2 11 Fundamentals for z/OS is an entry level exam for a user of any of the DB2 for z/OS family of product. When looking for valid exam dumps for good preparation, I recommend you DumpsBase IBM C2090-320 DB2 11 Fundamentals for z/OS Dumps to get real C2090-320 exam questions and answers. We provide real exam dumps with 123 exam questions and answers to ensure that you can pass C2090-320  DB2 11 Fundamentals for z/OS Exam.

Free C2090-320 DB2 11 for z/OS exam dumps online

1. Given a non-partitioned table space TS1 is built with LOCKSIZE ROW, LOCKMAX 1000 and SEGSIZE 64.

If a unit of work acquires 1001 locks against table space TS1, the lock will be escalated to which of the following levels?

 
 
 
 

2. Which of the following are contained in the PLAN_TABLE? (Choose two.)

 
 
 
 
 

3. Which privilege will user smith be able to grant to another user on table emp when the following SQL is executed?

GRANT ALL ON TABLE emp TO smith WITH GRANT OPTION;

 
 
 
 

4. Which of the following utilities CANNOT be executed from the DB2 utilities panel in DB2I?

 
 
 
 

5. Which of the following locking scenarios requires the least amount of real storage in the IRLM address space?

 
 
 
 

6. Which of the following is NOT TRUE?

 
 
 
 

7. Given the following CREATE TABLE statement, and a unique index on column EMPID, which set of SQL statements is valid?

 
 
 
 

8. 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?

 
 
 
 
 
 
 
 
 
 
 
 

9. Which of the following elements is affected by a ROLLBACK statement?

 
 
 
 

10. Which statement is TRUE regarding ROLLBACK processing?

 
 
 
 

11. Which of the following SQL constructs does NOT provide information about the success or failure of the SQL statement that was just executed?

 
 
 
 

12. Your current authorization ID is DBA. Only one of your secondary authorization IDs, DB2, has the privilege to create an index DB2.AAA on a table. The appropriate SQL statement starts with “CREATE INDEX AAA ON…”.

Which of the following statements must precede the CREATE statement so that you can create the index?

 
 
 
 

13. The metadata for which of the following objects is NOT stored in the DB2 catalog table SYSIBM.SYSTABLES?

 
 
 
 

14. In a unique referential constraint, which type of key does a foreign key reference?

 
 
 
 

15. 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?

 
 
 
 

16. If a scrollable cursor is INSENSITIVE, which of the following applies?

 
 
 
 

17. You want to reduce lock contention that results from uncommitted insert and delete operations by enabling transactions that read data to access only the currently committed data rather than waiting for the uncommitted changes to be resolved.

How can you accomplish this?

 
 
 
 

18. Given the following CREATE VIEW statement and sample data; your login id is “ROGER”.

What will be the result for this query?

 
 
 
 

19. Assume DELETE triggers exist on the employee table.

Which of the following statements will delete all the rows in the employee table and ignore any DELETE triggers?

 
 
 
 

20. Which of the following is a characteristic of a stand-alone utility?

 
 
 
 

21. 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?

 
 
 
 

22. Which package level privileges does the user smith have when the following statement is executed?

GRANT ALL ON PACKAGE clct1.pkg1 TO smith;

 
 
 
 

23. Which of the following can activate a trigger?

 
 
 
 

24. In which address space would a native SQL stored procedure run?

 
 
 
 

25. 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?

 
 
 
 

26. Which of the following statements about a table with a LOB column is TRUE?

 
 
 
 

27. Which catalog table provides information about the validity of a bound package?

 
 
 
 
 
 
 
 

28. Which of the following statements concerning a bi-temporal table is TRUE?

 
 
 
 

29. What is the result XQuery FLWOR expression when running the following scenario?

 
 
 
 

30. Given the following table and index definitions, what type of index will be created?

 
 
 
 

31. While DSN is running, which of the following commands CANNOT be successfully executed?

 
 
 
 

32. Which of the following is TRUE for using LOAD on a partition-by-growth table space?

 
 
 
 

33. Which of the following can be defined on the basis of a query?

 
 
 
 

34. Assuming column hire date is a DATE data type, which SQL statement will retrieve the maximum salary (salary) and minimum salary(salary) for each job(job) from EMPLOYEE table for those hired(hiredate) before 1965?

 
 
 
 

35. In order to run a DB2 program, the user issues the following commands:

TSO prompt: READY

USER enters: DSN SYS(SSTR)

USER enters: RUN PROGRAM(MYPROG)

USER enters: END

What is the result?

 
 
 
 

36. Which of the following describes OLTP workload rather than an analytics workload?

 
 
 
 

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.

A.

B.

C.

D.

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

 
 
 
 
 

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

 
 
 
 
 

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

 
 
 
 

41. Which types of user-defined data types are supported? (Choose two.)

 
 
 
 
 

42. Which BIND option determines when DB2 will do authorization checking?

 
 
 
 

43. COL1 is defined as CHAR(05) and contains CHAR(‘12345’).

Which of the following expressions returns the digits 12345 for further calculation?

 
 
 
 

44. Which DB2 address space manages DB2 locking?

 
 
 
 

45. What are two major encoding schemes? (Choose two.)

 
 
 
 
 

46. We want to increase the salary for each employee (EMP) in the department (WORKDEPT) D11 and we want to see the new salaries (SALARY) for each of them.

Which single SQL statement will do this?

 
 
 
 

47. You want to limit the access of a table to allow users to only see certain columns and/or rows.

Which of the following options CANNOT be used to accomplish this?

 
 
 
 

48. Which of the following tables can be used to set the default of the special register CURRENT APPLICATION COMPATIBILITY for remote users?

 
 
 
 
 
 
 

49. Which statement is TRUE regarding catalog table SYSIBM.SYSROUTINES?

 
 
 
 

Updated IBM C2010-555 Real Exam Dumps V9.02

Add a Comment

Your email address will not be published. Required fields are marked *