Which of the following SQL statements will remove all rows from the table T1? (Choose two.)
A. DELETE FROM t1
B. DELETE* TABLE t1
C. TRUNCATE TABLE t1
D. TRUNCATE TABLE t1 IMMEDIATE
E. DELETE* FROM t1
正解:A,E
質問 2:
Consider the following SQL statement:
SELECT workdept, empno, lastname, salary,
RANK() OVER (PARTITION BY workdept ORDER BY salary) AS rank_salary
FROM employee
ORDER BY workdept, lastname
What does the RANK() OVER (PARTITION BY workdept ORDER BY salary) clause do?
A. It generates a blank output line after each group of rows with the same WORKDEPT, and ranks these groups by SALARY
B. It tells the optimizer to physically partition the EMPLOYEE table by the WORKDEPT column for runtime execution, and ranks each WORKDEPT by SALARY
C. It ranks the rows in each WORKDEPT by SALARY
D. It groups all rows by WORKDEPT, then ranks all rows in the complete result set by SALARY
正解:D
質問 3:
The current user wants to produce a list of all user privileges she has been granted. Which table or view can be queried to produce the desired result?
A. SYSIBMADM.PRIVILEGES
B. SYSIBMADM.GRANTS
C. SYSCAT.DBAUTH
D. SYSCAT.USER_TAB_PRIVS
正解:C
質問 4:
What happens when you run the following statement if MYUSER holds no privileges on table MYTABLE?
REVOKE SELECT ON TABLE mytable FROM USER myuser
A. An error is returned
B. The REVOKE statement succeeds with no effect
C. An entry is mane in SYSCAT.TABAUTH
D. All privileges are granted to user MYUSER on MYTABLE
正解:B
質問 5:
Which of the following authorities is sufficient for connecting to a database?
A. DATAACESS
B. ACCESSCTRL
C. SQLADM
D. CONNECT
正解:B
質問 6:
Which of the following compatibility features is always active, regardless of the settings for the DB2_COMPATIBILITY_VECTOR registry variable or the SQL_COMPAT global variable?
A. Implicit casting
B. Selecting from the DUAL table
C. Double-dot notation
D. Use of bitmap indexes
正解:B
Kuroisi -
C2090-616基本的に用語とその概要を網羅する勉強になるため言語学ほど実践的な過去問は必要ないかと思われますが、それにしても過去問の収録数は少なめです。念を入れたい人は本書を導入とした上で過去問中心の参考書も併用することをPass4Testおすすめします。