CoolInterview.com - World's Largest Collection of Interview Questions
Start Your Own website Now
Sponsored Links

Interview Questions
Our Services

Get 9,000 Interview Questions & Answers in an eBook.


  • 9500+ Pages
  • 9000 Question & Answers
  • All Tech. Categories
  • 14 MB Content

    Get it now !!



    Send your Resume to 6000 Companies


  • INTERVIEW QUESTIONS MAINFRAME DB2 DETAILS
    Question :
    What is the difference between SYNONYM and ALIAS?
    Category DB2 Interview Questions
    Rating (0.4) By 819 users
    Added on 9/9/2009
    Views 1616
    Rate it!
    Answers:

    Sequence detector : A sequence detector gives an output of 1 on detecting the given sequence else the output is zero.

    Ex : if the given sequence to be detected is 111
    and input stream is 1 1 0 1 1 1 0 0 1 0 1 1 1 1 1
    the output should be 0 0 0 0 0 1 0 0 0 0 0 0 1 1 1.

    Soln:
    One of the different possible ways to detect a sequence is using a Mealy type FSM.

    Using the following table the State machine can be designed.
    since the number of bits in the sequence 1101 is 4 we have 4 states

    ------------------------------------------------------
    |PS | Seq detected by the state | NS/output |
    | | |---------------|
    | | | X=0 | X=1 |
    |-----------------------------------------------------
    | S1 | - | S1/0 | S2/0 |
    |----------------------------------------------------|
    | S2 | 1 | S1/0 | S3/0 |
    |----------------------------------------------------|
    | S3 | 11 | S4/0 | S3/0 |
    |----------------------------------------------------|
    | S4 | 110 | S1/0 | S2/1 |
    |----------------------------------------------------|

    when in state S4 (PS),and input(X) from the sequence is 1,the sequence "1101" has been detected once and (to find the next state select the longest "seq identified by a state" column that matches part of the sequence 1101--ie.,1 or 01 or 101 ....)the NS is S2 since the sequence detected by the state S2 is 1(in 1101- 01 or 101 ,etc are not present in the seq identified by the state column ,)



    SYNONYM: is dropped when the table or tablespace is dropped. Synonym is available only to the creator.

    ALIAS: is retained even if table or tablespace is dropped. ALIAS can be created even if the table does not exist. It is used mainly in distributed environment to hide the location info from programs. Alias is a global object & is available to all.



    Posted by: PAWAN KUMAR    

    Contact PAWAN KUMAR Contact PAWAN KUMAR

    If you have the better answer, then send it to us. We will display your answer after the approval.
    Rules to Post Answers in CoolInterview.com:-

  • There should not be any Spelling Mistakes.
  • There should not be any Gramatical Errors.
  • Answers must not contain any bad words.
  • Answers should not be the repeat of same answer, already approved.
  • Answer should be complete in itself.
  • Name :*
    Email Id :*
    Answer :*
    Verification Code Code Image - Please contact webmaster if you have problems seeing this image code Not readable? Load New Code
    Process Verification  Enter the above shown code:*
    Inform me about updated answers to this question

       
    Related Questions
    View Answer
    What is a synonym ?
    View Answer
    What is index cardinality?
    View Answer
    What are simple, segmented and partitioned table spaces ?
    View Answer
    What is FREEPAGE and PCTFREE in TABLESPACE creation?
    View Answer
    What is an inner join, and an outer join ?
    View Answer
    What are the 4 environments which can access DB2 ?
    View Answer
    If I have a view which is a join of two or more tables, can this view be updateable?
    View Answer
    Are views updateable ?
    View Answer
    What does the sqlcode of -818 pertain to?
    View Answer
    What is sqlcode -811?
    View Answer
    What is sqlcode -922 ?
    View Answer
    What is the difference between primary key & unique index ?
    View Answer
    How many clustering indexes can be defined for a table?
    View Answer
    What is a clustering index ?
    View Answer
    What is QUIESCE?
    View Answer
    What is CHECK PENDING ?
    View Answer
    What is COPY PENDING status?
    View Answer
    When do you use the IMAGECOPY?
    View Answer
    What is IMAGECOPY ?
    View Answer
    What is REORG? When is it used?
    View Answer


    Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

    View ALL DB2 Interview Questions

    User Options
    Sponsored Links


    Copyright ©2003-2014 CoolInterview.com, All Rights Reserved.
    Privacy Policy | Terms and Conditions

    Download Yahoo Messenger | Placement Papers| FREE SMS | ASP .Net Tutorial | Web Hosting | Dedicated Servers | C Interview Questions & Answers

    Testing Articles | Testing Books | Testing Certifications | Testing FAQs | Testing Downloads | Testing Interview Questions | Testing Jobs | Testing Training Institutes


    Cache = 2.03125 Seconds