000-610 by IBM Actual Free Exam Q&As

Question 1

Given the following statements:

What will be the result?

A. Joe Smith B. Joe Smith C. Joe Smith>DB2 D. Joe Smith

Discussion 0

Correct Answer: D Vote an answer

Question 2

Which statement about system-period temporal tables is true?

A. They can be queried without a time period specification. B. They store user-based period information. C. They do not have a separate history table. D. They manage data based on time criteria specified by users or applications.

Discussion 0

Correct Answer: A Vote an answer

Question 3

Which statement about foreign keys is true?

A. Foreign keys are enforced only during the execution of INSERT statements. B. A foreign key can be defined on a column or a set of columns in a table. C. A table can have only one foreign key. D. Foreign keys can only be defined when a table is created.

Discussion 0

Correct Answer: B Vote an answer

Question 4

Which of the following privileges allow a user to update the comment on a sequence?

A. ALTER B. COMMENT C. UPDATE D. USAGE

Discussion 0

Correct Answer: A Vote an answer

Question 5

Which statement about application-period temporal tables is true?

A. Is useful when one wants to keep both user-based period information and system-based historical information. B. Is based on explicitly-supplied timestamps that define the time periods during which data is valid. C. Consists of a pair of columns with database-manager maintained values that indicate the period when a row is current. D. Consists of explicitly-supplied timestamps and a separate associated history table.

Discussion 0

Correct Answer: B Vote an answer

Question 6

If a table named MY_TAB contains 100 rows and the following statement is executed:

What will happen?

A. The first 5 rows in the table will be deleted. B. The last 5 rows in the table will be deleted. C. The statement will fail because a table name was not specified with the DELETE statement. D. The statement will fail because a subquery cannot be used with a DELETE statement.

Discussion 0

Correct Answer: B Vote an answer

Question 7

Which SQL statement should be used to select the minimum and maximum salaries (SALARY), by job code (JOB), from a table EMPLOYEE?

A. SELECT job, MIN(salary), MAX(salary)
FROM employee
GROUP BY job; B. SELECT job, MIN(salary), MAX(salary)
FROM employee
ORDER BY job; C. SELECT JOB, MIN(salary), MAX(salary)
FROM employee
ORDER BY job, MIN(salary), MAX(salary); D. SELECT job, MIN(salary), MAX(salary)
FROM employee
GROUP BY job, MIN(salary), MAX(salary);

Discussion 0

Correct Answer: A Vote an answer

Question 8

Which object can be enabled for compression?

A. Storage group B. View C. Temporary table D. Buffer pool

Discussion 0

Correct Answer: C Vote an answer

Question 9

Which database object provides an alternative way of describing data that exists in one or more base tables?

A. Index B. View C. Sequence D. Alias

Discussion 0

Correct Answer: B Vote an answer

Question 10

Which statement about INSERT operations is true?

A. Inserted values must satisfy the conditions of any check constraints defined on the table. B. If the underlying table of a view being referenced by an INSERT statement has one or more unique indexes, each row inserted does not have to conform to the constraints imposed by those indexes. C. The INSERT statement is used to insert rows into a table, view, or table function. D. If an INSERT statement omits any column from the inserted row that is defined as NULL or NOT NULL WITH DEFAULT, the statement will fail.

Discussion 0

Correct Answer: A Vote an answer

IBM DB2 10.1 Fundamentals - 000-610 Exam Practice Test