Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    143

    Unanswered: Answers needed for these multiple choice questions

    Question 1) Can you use the functions nvl and decode as well as the CASE statement interchangeably?

    A Only NVL with DECODE and vice versa
    B Only Decode with CASE statement and vice versa.
    C NVL with Decode or CASE statement as well as Decode and Case Statement interchangeably
    D All three can be used interchangeably


    Question 2) An inner join

    A Is preferred if it meets business requirements
    B Requires a (+) sign in the sql syntax for Oracle
    C Should never be used on dimensional metrics
    D A and B
    E A and C only


    Question 3) You can use a Sub-select in a query after

    A The FROM clause
    B The IN clause
    C The '=' operator
    D All of the above
    E All of the above and more


    Question 4) Many to Many relationships:

    A Result in double-counting
    B May be resolved in different ways but using a relationship table is always preferred.
    C Should be avoided as far as possible for simplicity
    D All of the above
    E A and C only


    Question 5) Views:

    A Often minimize re-work during the development or integration phase
    B Can be used to implement security
    C Can be materialized in recent versions of Oracle
    D None of the above
    E All of the above


    Thanks

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Why do you want us to GIVE you these answers? Why don't you study and do the homework yourself?
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  3. #3
    Join Date
    Feb 2004
    Posts
    143
    I sure did a sincere attempt as far as homework goes also with a mixed success. For example, when I tried this on my database , I found that Question 1) could be D, Question 3) could be E and so on. And however, I may not be the strongest in logical reasoning, and hence seeking suggestions because second opinions and suggestions are valuable as they are. Atleast I will have a chance to correct myself in the chance that I may be wrong in what I thought or found. It is possible.


    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •