IBM C2090-546 問題集

質問 1：
Which two authorities can grant SELECT privilege on a table? (Choose two.)
A. DATAACCESS authority on the database.
B. SECADM authority on the database.
C. ACCESSCTRL authority on the database.
D. DBADM authority on the database.
E. SYSADM authority on the instance.
正解：B,C

質問 2：
You are creating a table with 1 LOB column. The size of the LOB column is less than the size of the LOB descriptor. When creating this table you did not specify an INLINE LENGTH. Which option is correct?
A. Only the LOB data will be stored in the base table.
B. The ALTER TABLE .. INLINE LENGTH .. command is required so the LOB data can be included in the base table.
C. Only the LOB descriptor will be stored in base table and the LOB data will be stored in the LOB storage object.
D. Both the LOB descriptor and the LOB data will be stored in the base table.
正解：A

質問 3：
Which command is utilized to deactivate the CognosAPP statistics event monitor and stop it from collecting extended aggregate activity data for a given workload?
A. DROP WLM EVENT MONITOR CognosAPP
B. DROP WLM MONITOR CognosAPP
C. SET EVENT MONITOR CognosAPP STATE = 1
D. SET EVENT MONITOR CognosAPP STATE = 0
正解：D

質問 4：
When a database is created who is granted SECADM by default?
A. Members of the SYSADM_GROUP.
B. The database creator and members of the SYSADM_GROUP.
C. The database creator.
D. Members of the SECADM_GROUP.
正解：C

質問 5：
Which statements about Explain administration authority (EXPLAIN) are true?
A. EXPLAIN authority allows a user to explain query plans by gaining limited access to data for a specific database. DBADM can grant this authority and this authority can be granted to PUBLIC.
B. EXPLAIN authority allows a user to explain query plans without gaining access to data for a specific database. SECADM can grant this authority and this authority can be granted to PUBLIC.
C. EXPLAIN authority allows a user to explain query plans by gaining limited access to data for a specific database. SECADM can grant this authority and this authority cannot be granted to PUBLI
D. EXPLAIN authority allows a user to explain query plans without gaining access to data for a specific database. SECADM and DBADM can grant this authority and this authority cannot be granted to PUBLIC.
正解：B

質問 6：
How would you set the client information for a particular activity in a database using Workload Manager (WLM)?
A. Use the WLM_SET_CLIENT_INFO table function
B. Use the WLM_SET_CLIENT_INFO special register
C. Use the WLM_SET_CLIENT_INFO audit function
D. Use the WLM_SET_CLIENT_INFO stored procedure
正解：D

質問 7：
Which SQL statement must be executed in order to give a user named USER1 the ability to query the system catalog tables and views?
A. GRANT ACCESSCTRL ON DATABASE TO user1
B. GRANT DATAACCESS ON DATABASE TO user1
C. GRANT SQLADM ON DATABASE TO user1
D. GRANT WLMADM ON DATABASE TO user1
正解：B

質問 8：
If table TAB_A is created as follows:

Assuming the cardinality of the columns is the same, which statement will create an index that will benefit the most from compression?
A. CREATE INDEX taba_idx ON tab_a (c4)
B. CREATE UNIQUE INDEX taba_idx ON tab_a (c2)
C. ALTER TABLE tab_a ADD PRIMARY KEY (c1)
D. CREATE INDEX taba_idx ON tab_a (c2)
正解：D