최신IBM DB2 11.1 Fundamentals for LUW - C2090-616무료샘플문제
문제1
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?
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?
정답: D
문제2
What happens when you run the following statement if MYUSER holds no privileges on table MYTABLE?
REVOKE SELECT ON TABLE mytable FROM USER myuser
What happens when you run the following statement if MYUSER holds no privileges on table MYTABLE?
REVOKE SELECT ON TABLE mytable FROM USER myuser
정답: B
문제3
A multi-partition database environment using BLU acceleration is designed to meet which of the following requirements? (Choose two.)
A multi-partition database environment using BLU acceleration is designed to meet which of the following requirements? (Choose two.)
정답: C,E
문제4
Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?
Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?
정답: D
문제5
Which of the following set operators can be used to find all rows that are common in 2 queries?
Which of the following set operators can be used to find all rows that are common in 2 queries?
정답: C
문제6
Which of the following authorities are sufficient for creating a database? (Choose two.)
Which of the following authorities are sufficient for creating a database? (Choose two.)
정답: C,E
문제7
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?
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?
정답: D