Free IBM 000-610 Practice Test & Real Exam Questions
Which type of constraint can be used to ensure that an INTEGER column in a table will never be assigned more than one record that contains a NULL value?
Correct Answer: D
Vote an answer
Which SQL statement should be used to retrieve the minimum and maximum salaries (SALARY) for each job code (JOB), sorted by job code, from a table named EMPLOYEE?
Correct Answer: B
Vote an answer
Which clause should be included in a ALTER TABLE statement to update a table definition with a new column?
Correct Answer: D
Vote an answer
Which SQL statement will take the ability to create tables in a table space named MYTBSP away from user USER1?
Correct Answer: D
Vote an answer
