Given the following ALTER SEQUENCE statement: ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5 ORDER Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the following is true?()
时间:2022-09-24
Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?()
Which of the following best describes the age of the data in an OLTP system?()
时间:2022-09-23
Given the following query:SELECT last_name, first_name, age, hire_date FROM employee WHERE age > 40Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?()
时间:2022-09-22
To which of the following resources can a lock be applied?()
A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?()
时间:2022-09-21
Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?()
时间:2022-09-20
Which tool must be used to analyze all of the database operations performed by an application against a DB2 for i5/OS database?()
时间:2022-09-19
Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?()
Which of the following resources can be explicitly locked?()
时间:2022-09-16
Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?()
In which of the following situations should correlation names be used?()
时间:2022-09-15
Given the following two tables: TAB1 C1 C2 1 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY 5 Europe 6 North America 7 South America Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1?()
时间:2022-09-12
Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?()
时间:2022-09-09
Which of the following tools can be used to schedule a backup operation that is to be run every Sunday evening?()
时间:2022-09-07