IBM DB2 11 Fundamentals for z/OS - C2090-320무료 덤프문제 풀어보기
Consider the following scenario:
User1 creates table USER1.TABLE1 in DATABASE1
User1 grants ALL PRIVILEGES on TABLE1 to User2
User2 grants ALL PRIVILEGES on TABLE1 to User3
User1 revokes ALL PRIVILEGES on TABLE1 to User2
User3 has DBCTRL authority on DATABASE1
Is User3 able to retrieve rows from TABLE1?
User1 creates table USER1.TABLE1 in DATABASE1
User1 grants ALL PRIVILEGES on TABLE1 to User2
User2 grants ALL PRIVILEGES on TABLE1 to User3
User1 revokes ALL PRIVILEGES on TABLE1 to User2
User3 has DBCTRL authority on DATABASE1
Is User3 able to retrieve rows from TABLE1?
정답: B
Given the following:
ALTER TABLE POLICY_INFO_AET ENABLE ARCHIVE USE POLICY_INFO_ARC:
SET SYSIBMADM.MOVE_TO_ARCHIVE = T; ***
Which of the following occurs automatically when rows are deleted from POLICY_INFO_AET?
ALTER TABLE POLICY_INFO_AET ENABLE ARCHIVE USE POLICY_INFO_ARC:
SET SYSIBMADM.MOVE_TO_ARCHIVE = T; ***
Which of the following occurs automatically when rows are deleted from POLICY_INFO_AET?
정답: A
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?
Which of the following processes can be used on subsystem DSN to access MYUSER.EMP table at MYREMOTE location?
정답: B
Which isolation level is described by the following?
The ISOLATION (..) option allows maximum concurrency with data integrity. Under the ISOLATION (..) option, a transaction holds locks only on its uncommitted changes and on the current row of each of its cursors.
The ISOLATION (..) option allows maximum concurrency with data integrity. Under the ISOLATION (..) option, a transaction holds locks only on its uncommitted changes and on the current row of each of its cursors.
정답: A
Which of the following is used to identify valid source and target combinations and to perform the conversion from one coded character set to another?
정답: D
Which of the following tables can be used to set the default of the special register CURRENT APPLICATION COMPATIBILITY for remote users?
정답: B
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?
정답: C
While DSN is running, which of the following commands CANNOT be successfully executed?
정답: A
Which CREATE TABLESPACE option specifies that a table space is partition-by-growth?
정답: C