Advertisement
Guest User

Untitled

a guest
Apr 20th, 2018
392
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. IN the "aging" TABLE, IF you repeatedly ACCESS customers BY account opening DATE, how can you correctly generate a multi-COLUMN INDEX USING both the Account NUMBER AND the Account opening DATE?
  2.  
  3. SELECT one:
  4. a. CREATE INDEX customer_aging ON aging (account_number, account_opn_date) idx
  5. b. CREATE INDEX customer_aging FROM aging (account_number,account_opn_date) TABLESPACE idx
  6. c. CREATE INDEX customer_aging ON aging (account_number, account_opn_date) TABLESPACE idx
  7. d. CREATE customer_aging INDEX INSIDE aging (account_number, account_opn_date) TABLESPACE idx
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement