問題1
What is the purpose of an auxiliary table?
What is the purpose of an auxiliary table?
正確答案: C
問題2
Which isolation level is described by the following?
The ISOLATION (..) option allows maximum concurrency with data integrity. Under the ISOLATION (..) option, a transaction holds locks only on its uncommitted changes and on the current row of each of its cursors.
Which isolation level is described by the following?
The ISOLATION (..) option allows maximum concurrency with data integrity. Under the ISOLATION (..) option, a transaction holds locks only on its uncommitted changes and on the current row of each of its cursors.
正確答案: C
問題3
Which of the following actions can you take in order to prevent users from obtaining implicit privileges as a result of object ownership?
Which of the following actions can you take in order to prevent users from obtaining implicit privileges as a result of object ownership?
正確答案: C
問題4
Which statement about an application-period temporal table is TRUE?
Which statement about an application-period temporal table is TRUE?
正確答案: A
問題5
Given the following table and index definitions, what type of index will be created?
Given the following table and index definitions, what type of index will be created?
正確答案: A
問題6
Your current authorization ID is DBA.
Only one of your secondary authorization IDs, DB2, has the privilege to create an index DB2.AAA on a table.
The appropriate SQL statement starts with "CREATE INDEX AAA ON...".
Which of the following statements must precede the CREATE statement so that you can create the index?
Your current authorization ID is DBA.
Only one of your secondary authorization IDs, DB2, has the privilege to create an index DB2.AAA on a table.
The appropriate SQL statement starts with "CREATE INDEX AAA ON...".
Which of the following statements must precede the CREATE statement so that you can create the index?
正確答案: B
問題7
The maximum size for each partition of a partition-by-range table space, with fewer than 255 partitions, is determined by which combination of options? (Choose two.)
The maximum size for each partition of a partition-by-range table space, with fewer than 255 partitions, is determined by which combination of options? (Choose two.)
正確答案: A,E
問題8
In the parent table of a referential constraint, a parent key must be which of the following? (Choose two.)
In the parent table of a referential constraint, a parent key must be which of the following? (Choose two.)
正確答案: A,C