logo

CuriousTab

CuriousTab

Discussion


Home Interview Technology See What Others Are Saying!
  • Question
  • What is an Index? Explain how to create an Index.


  • Correct Answer
  • An index is a object which is used to improve performance during retrieval of records CREATE [UNIQUE] INDEX index_name ON employee[emp_id, emp_name,dept_id] [COMPUTE STATISTICS] The UNIQUE keyword is used when combined values of the index should be unique The COMPUTE STATISTICS during the creation of index optimizes the plan of execution of the SQL statement and improves performance 


  • More questions

    • 1. How would you automatically transfer your visitors to a new web page?
    • Discuss
    • 2. The threshold limit upto which coins can be issued as per the Coinage Act 2011 ?

    • Options
    • A. 100
    • B. 200
    • C. 500
    • D. 1000
    • Discuss
    • 3. Cash Reserve Ratio ( CRR) and Stautory Liquidity Ratio (SLR ) are terms most closely related to which of the following industries/markets :

    • Options
    • A. Mutual Fund
    • B. Income Tax
    • C. Stock Exchange
    • D. Banking
    • Discuss
    • 4. What is the minimum period of time for which one can open an FD(Fixed Deposit) account ?

    • Options
    • A. 15 days
    • B. 6 months
    • C. 7 days
    • D. 1 year
    • Discuss
    • 5. Which Bank has been given scheduled bank status by RBI ?

    • Options
    • A. Disha
    • B. Suryoday
    • C. Janalakshmi
    • D. Ujjivan
    • Discuss
    • 6. Which class is used to indicate Black Navigation Bar ?

    • Options
    • A. .navbar-inverse
    • B. .navbar-black
    • C. .navbar-dark
    • D. .navbar-default
    • Discuss
    • 7. The journal entry to record a credit sale is

    • Options
    • A. Accounts Receivable
    • B. Accounts Payable
    • C. Both A & B
    • D. None of the above
    • Discuss
    • 8. What is CRR rate?
    • Discuss
    • 9. Which among the following are not access Specifiers in C++?

    • Options
    • A. Public
    • B. Protected
    • C. Default
    • D. Private
    • Discuss
    • 10. In which year, the first bank of India "Bank of Hindustan" was established ?

    • Options
    • A. 1677
    • B. 1770
    • C. 1796
    • D. 1831
    • Discuss


    Comments

    There are no comments.

Enter a new Comment