Test 000-730: DB2 9 Family Fundamentals
測試信息:
題目數量:64
考試時間以分鐘為單位:90
必填及格分數:59%
IBM 000-730安全(11%):
知識的DB2產品(客戶端,服務器等);
知識和權力的不同權限;
知識的加密選項(數據和網絡);
鑑於一個 DDL SQL語句,知識,以確定結果(授予/撤銷/連接語句)。
標籤: 000-730
000-730
DB2 000-730考試考古題由“KillTest認證題庫網”資深IT認證講師和DB2產品專家結合Prometric或VUE的真實考試環境最新原題精心打造。000-730考古題助您一次輕鬆通過考試。本站所售考古題含蓋了當前最新的真實考題,並且全部附有正確答案,我們承諾對DB2 000-730(DB2 9 Fundamentals)考試原題完整覆蓋。如果您正在準備000-730考試,它將是最佳的學習助手,是您通過考試取得證照的捷徑。
000-730 Exam考古題由我們的資深IT認證講師和DB2產品專家精心打造,包括了當前最新的真實000-730考試題目,全部附有正確答案。所有購買我們“000-730考古題”的客護,都將獲得60天免費昇級的售後服務,確保客護的壹次通過率。本站不提供考點信息質詢,若需瞭解考試中心地址或預約相關考試,請直接訪問PROMETRIC或VUE官方網站。我們提供部分考古題DEMO免費試用,幫助您瞭解000-730考試題目的真實面貌,使您在確定購買之前可以先知悉我們的專業品質。頁面部分不提供圖片,如需查看DEMO詳情,請通過以下鏈接進行下載。
A user invoking a user-defined function requires which DB2 privilege?
A.CALL
B.USAGE
C.EXECUTE
D.REFERENCES
Correct:C
Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?
A.REVOKE ADD, DELETE FROM USER tom ON TABLE tab1
B.REVOKE ADD, DELETE ON TABLE tab1 FROM USER tom
C.REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1
D.REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom
Correct:D
Which of the following privileges permits a user to update the comment on a sequence?
A.CONTROL
B.UPDATE
C.USAGE
D.ALTER
Correct:D
Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?
A.REVOKE ALL PRIVILEGES FROM USER tom
B.REVOKE ALL ON EMPLOYEE FROM USER tom
C.REVOKE EXECUTE ON EMPLOYEE FROM USER tom
D.REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom
Correct:B
What is the lowest privilege and/or authority required to execute the following SQL statement? CREATE VIEW view1 AS SELECT * FROM table1 WHERE STATE = ‘TX’
A.DBADM authority
B.SYSADM authority
C.SELECT privilege on TABLE1
D.REFERENCES privilege on TABLE1
Correct:C