IT認証試験問題集
毎月、GOWUKAKUは1500人以上の受験者が試験準備を助けて、試験に合格するために受験者にご協力します
 ホームページ / C2090-616 問題集  / C2090-616 問題練習

IBM C2090-616 問題練習

DB2 11.1 Fundamentals for LUW 試験

最新更新時間: 2024/03/19,合計63問。

【2024年3月キャンペーン】:C2090-616 最新真題を買う時、日本語版と英語版両方を同時に獲得できます。

実際の問題集を練習し、試験のポイントを了解し、テストに申し込むするかどうかを決めることができます。

さらに試験準備時間の35%を節約するには、C2090-616 問題集を使用してください。

 / 2

Question No : 1
Which of the following SQL statements will remove all rows from the table T1? (Choose two.)

正解:

Question No : 2
Which of the following authorities is sufficient for connecting to a database?

正解:
Explanation:http://www-01.ibm.com/support/docview.wss?uid=swg21427232

Question No : 3
What is the purpose of a role?

正解:

Question No : 4
What of the following is TRUE about triggers?

正解:
Explanation:https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/
com.ibm.db2.luw.admin.dbobj.doc/doc/c0004113.html

Question No : 5
What type of function is created using the following command?
CREATE FUNCTION TAN (X DOUBLE)
RETURNS DOUBLE
LANGUAGE SQL
CONTAINS SQL
NO EXTERNAL ACTION
DETERMINISTIC
RETURN SIN(X)/COS(X)

正解:
Explanation:https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/
db2z_sql_createfuncinlinesqlscalar.html

Question No : 6
Which operation typically requires a Share (S) lock?

正解:
Explanation:https://www.ibm.com/developerworks/data/library/techarticle/dm-0509schuetz/index.html

Question No : 7
Which of the following authorities are sufficient for creating a database? (Choose two.)

正解:
Explanation:https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/
com.ibm.db2.luw.admin.cmd.doc/doc/r0001941.html

Question No : 8
Which of the following commands can undo the work done by the current unit of work executing UPDATE
statements on a table?

正解:
Explanation:https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/
db2z_sql_rollback.html

Question No : 9
BLU Acceleration is included in which of the following edition of DB2 LUW? (Choose two.)

正解:
Explanation:https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/
com.ibm.db2.luw.licensing.doc/doc/r0053238.html

Question No : 10
Which locking event occurs when two applications lock rows that are needed by the other, such that
neither application can continue executing?

正解:
Explanation:https://www.ibm.com/developerworks/data/library/techarticle/dm-0406whitlark/index.html

Question No : 11
Consider the following sequence of events:
Eddie grants SELECT WITH GRANT OPTION privilege to Mike.
Mike grants SELECT privilege to Jeff.
Eddie revokes SELECT privilege from Mike.
What will happen to Jeff’s SELECT privilege?

正解:
Explanation:https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.sqls.doc/
ids_sqs_0125.htm

Question No : 12
The following statements are executed:
GRANT CREATETAB, DATAACCESS, ON DATABASE TO ROLE role A;
GRANT CREATETAB, BINDADD ON DATABASE TO ROLE role B;
GRANT ROLE role A to USER db2inst3;
GRANT ROLE role B to USER db2inst3;
Which of the following is TRUE if this statement is executed later?
REVOKE ROLE roleB FROM USER db2inst3;

正解:

Question No : 13
How can you tell what privileges on a table or view have been granted to a user? (Choose two.)

正解:
Explanation:https://www.ibm.com/support/knowledgecenter/hr/SSEPGG_9.7.0/
com.ibm.db2.luw.admin.sec.doc/doc/t0005823.html

Question No : 14
Which of the following is TRUE about indexes on column organized tables?

正解:

Question No : 15
Which of the following statements about triggers are TRUE? (Choose two.)

正解:
Explanation:https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/
com.ibm.db2.luw.admin.dbobj.doc/doc/c0004113.html

 / 2