Free IBM A2090-610 Exam Dumps Questions & Answers

User USER1 wants to retrieve records from a table named EMPLOYEE that satisfy at least one of the following criteria:
-The employee's hire date (HIREDATE) is before 1999 and the employee's salary (SALARY) is less than $40,000.00 a year. -The employee has attended university
Which SQL statement will accomplish this?

• A.SELECT * FROM employee
  WHERE (hiredate < '1999-01-01' AND salary < 40000
  AND (education = 'University')
• B.SELECT * FROM employee
  WHERE (hiredate < '1999-01-01' OR (salary < 40000
  AND (education = 'University')
• C.SELECT * FROM employee
  WHERE (hiredate < '1999-01-01') OR (salary < 40000)
  OR (education = 'University')
• D.SELECT * FROM employee
  WHERE (hiredate < '1999-01-01' AND salary < 40000)
  OR (education = 'University')

What are two valid objects that can be created in DB2? (Choose two.)

• A.Sequence
• B.Contexts
• C.Tree
• D.Node
• E.Trigger

A table named EMPLOYEE was created as follows:

Which action will prevent unauthorized users from accessing SSN data?

• A.Assign the SSN column to a restricted role that only authorized users can access.
• B.Create a view for the EMPLOYEE table that does not contain the SSN column and require unauthorized users to use the view.
• C.Only grant ACCESSCTRL authority for the SSN column to users who need to access SSN data.
• D.Alter the table definition so that SSN data is stored in a separate schema that only authorized users can access.

Which statement about a deadlock is true?

• A.Both victim and holder are rolled back.
• B.The victim must wait until the holder releases the lock.
• C.The victim will be rolled back.
• D.The victim will read through the lock.

Which two operations are allowed in the body of an SQL scalar user-defined function? (Choose two.)

• A.SQL control statements.
• B.CALL statements.
• C.Use of a scratch pad.
• D.External file access.
• E.COMMIT statements.