Star Db_1

15 Questions

Settings
Please wait...
Star Quizzes & Trivia

A Simple quiz for you all to summarize our session on TTRAN, TFLOW, TFRA, TSWAP, TSWAP_LEG. Hope you all will enjoy this !


Questions and Answers
  • 1. 
    Identify what type of deal is this: CBN1568418
    • A. 

      IRS

    • B. 

      L&D

    • C. 

      FRA

  • 2. 
    Is_Cancelled is column in TFLOW?
    • A. 

      Yes

    • B. 

      No

  • 3. 
    What is the product code for Tr_type FRA?
    • A. 

      TFRA

    • B. 

      CASH

    • C. 

      FUT

    • D. 

      FRA

  • 4. 
    What is the period start date for Period id 1 of this deal: DVL0853156?
  • 5. 
    Find out the Int Rate for CBN1241987 deal
    • A. 

      5.212

    • B. 

      3.455

    • C. 

      5.325

  • 6. 
    KSFRA19- Is this Buy or Sell dea?
    • A. 

      Buy

    • B. 

      Sell

  • 7. 
    19285 - Is this a LIBOR or EURIBOR Index?
    • A. 

      LIB

    • B. 

      EIB

  • 8. 
    Which all tables will you find DAY_COUNT_BASIS
    • A. 

      TMMKT

    • B. 

      TFLOW

    • C. 

      TFRA

    • D. 

      TSWAP

    • E. 

      TSWAP_LEG

  • 9. 
    Deal ID CBN1203917: What are the modified fields?
  • 10. 
    Is this deal - CBN0348510 having a notional principal?
    • A. 

      Yes

    • B. 

      No

  • 11. 
    BCC9696602 - What is the Effective Date for this?
    • A. 

      6/24/1998

    • B. 

      6/24/1999

  • 12. 
    TAU1138529 - Is it a Floating to Fixed?
    • A. 

      True

    • B. 

      False

  • 13. 
    Can you have Fixed to Fixed Swap?Check it in DB - select * from tswap s where s.L_FLOATING = s.B_FLOATINGand s.B_FLOATING = 'N'
  • 14. 
    What is the B side rate for CBN0309906?
    • A. 

      4.7275

    • B. 

      4.7273

    • C. 

      4.7255

    • D. 

      4.7175

  • 15. 
    Which field is modified for this deal - CBN1247622