Online Access Free C2090-730 Practice Test

Which of the following is a NOT a valid reason for defining a view on a table?

• A.Ensure that rows inserted remain within the scope of a definition
• B.Provide users with an alternate view of table data
• C.Produce an action as a result of a change to a table
• D.Restrict users' access to a subset of table data

Given the following statement:
SELECT hyear, AVG(salary)
FROM (SELECT YEAR(hiredate) AS hyear, salary
FROM employee WHERE salary > 30000)
GROUP BY hyear
Which of the following describes the result if this statement is executed?

• A.The statement will return the year and average salary for all years that any employee had a salary greater than $30,000.
• B.The statement will return the year and average salary for all years that every employee hired had a salary greater than $30,000.
• C.The statement will return the year and average salary for all employees that have a salary greater than $30,000, sorted by year.
• D.The statement will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000.

Given the following scenario:
Table TABLE1 needs to hold specific numeric values up to 9999999.999 in column COL1. Once TABLE1 is populated, arithmetic operations will be performed on data stored in column COL1.
Which of the following would be the most appropriate DB2 data type to use for column COL1?

• A.REAL
• B.INTEGER
• C.DECIMAL(10, 3)
• D.NUMERIC(7, 3)

User USER1 is the owner of TABLE1. Assuming user USER1 only holds privileges for TABLE1, which of the following is the best way to remove all privileges user USER1 holds?

• A.REVOKE CONTROL, ALL PRIVILEGES ON table1 FROM user1
• B.REVOKE CONTROL ON table1 FROM user1; REVOKE ALL PRIVILEGES ON table1 FROM user1;
• C.REVOKE CONTROL ON table1 FROM user1
• D.REVOKE ALL PRIVILEGES ON table1 FROM user1

Which two of the following statements are true about the HAVING clause?

• A.The HAVING clause accepts wildcards.
• B.The HAVING clause uses the same syntax as the IN clause.
• C.The HAVING clause can only be used with the GROUP BY clause.
• D.The HAVING clause uses the same syntax as the WHERE clause.
• E.The HAVING clause is used in place of the WHERE clause.