Explanation:For each tuple, ntile(n) then gives the number of the bucket in which it is placed, with bucket numbers starting with 1. 10. The command ________________ such tables are available only within the transaction executing the query, and are dropped when the transaction finishes.
A. Create table
B. Create temporary table
C. Create view
D. Create label view
Answer:A
Explanation:For each tuple, ntile(n) then gives the number of the bucket in which it is placed, with bucket numbers starting with 1. 10. The command ________________ such tables are available only within the transaction executing the query, and are dropped when the transaction finishes.
A. Create table B. Create temporary table C. Create view D. Create label view
Explanation:None. Sanfoundry Global Education & Learning Series – Database Management System.