Results 1 to 13 of 13

Thread: certification

  1. #1
    Join Date
    Oct 2003
    Location
    York UK
    Posts
    9

    Unanswered: certification

    Please help me with the following certification (certification no 700, fundamentals for DB2 UDB V8.1)questions

    A developer is building an embedded SQL application on AIX that will access DB2 UDB for OS/390 or OS/400 servers.
    Which of the following products is required to be installed on the AIX system in order to build the application?

    A. DB2 Connect Personal Edition
    B. DB2 Personal Developer's Edition
    C. DB2 UDB Workgroup Server Edition
    D. DB2 Universal Developer's Edition
    ----------------------
    Given a read-only application that requires consistent data for every query, which of the following isolation levels should it use to provide the most concurrency with other applications doing updates?

    A. Read Stability
    B. Repeatable Read
    C. Cursor Stability
    D. Uncommitted Read
    -----------------
    A table has had check constraint enforcement turned off, and additional data has been inserted. Which of the following will perform data validation to ensure that column values are valid?

    A. Add a trigger
    B. Collect statistics
    C. Reorganize the table
    D. Enable check constraints
    --------------
    A stored procedure has been built and deployed on the DB2 UDB server machine. What is the minimum software that must be installed to allow an application on the client to execute the stored procedure?
    A. DB2 Runtime Client
    B. DB2 Personal Edition
    C. DB2 Administration Client
    D. DB2 Application Development Client

    ---------------------
    USER3 is running a program A.APP1 that calls stored procedure P.PROC1.
    As an administrator, which of the following statements should be executed to give USER3 the appropriate privilege to be able to execute the code found in stored procedure P.PROC1?

    A. GRANT EXECUTE ON PACKAGE a.app1 TO user3
    B. GRANT EXECUTE ON PROCEDURE a.app1 TO user3
    C. GRANT EXECUTE ON FUNCTION p.proc1 TO user3
    D. GRANT EXECUTE ON PROCEDURE p.proc1 TO user3

    ------------------------
    A client application on OS/390 or OS/400 must access a DB2 server on Linux. At a minimum, which of the following products is required to be on the DB2 server?


    A. DB2 Connect Enterprise Edition
    B. DB2 UDB Enterprise Server Edition
    C. DB2 Connect Enterprise Edition and DB2 UDB Workgroup Server Edition
    D. DB2 Connect Enterprise Edition and DB2 UDB Enterprise Server Edition
    -------------------------
    For which of the following database objects can locks NOT be obtained?

    A. A row
    B. A table
    C. A column
    D. An index key
    ---------------------------------------
    When constraint checking is suspended or disabled, a table or table space (depending on platform) is placed in which of the following states?

    A. Paused
    B. Check pending
    C. Intent locked
    D. Constraint waiting


    Which of the following processes is NOT performed by DB2 Warehouse Manager?

    A. Query
    B. Loading
    C. Extraction
    D. Transformation

    ---------------------------

    Cataloging a remote database server from a Linux, Unix or Windows gateway is :

    A. Performed to identify the location of the clients
    B. Performed to identify the server the DB2 database manager is on
    C. Never performed in DB2, as only one database per node is allowed, so cataloging a node automatically catalogs the database at that node
    D. Performed on a Linux, UNIX, or Windows machine to open the catalogs in the DB2 databases server and present a user with a list of all accessible tables in the databse.

    Thanks for your help
    Last edited by rusiar; 11-03-03 at 07:10.

  2. #2
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Answers

    Hi Raj,

    I am trying to answer some of them hope i am right!! However please wait for the others to answer, that way we would have the right answers!! At the same time you should have mentioned the no of options that we have to choose, I feel that Ques 7 would have 2 answers.


    1. D. DB2 Universal Developer's Edition

    2. B. Repeatable Read

    3. D. Enable check constraints

    4. A. DB2 Runtime Client

    5.A. GRANT EXECUTE ON PACKAGE a.app1 TO user3 (Doubtful)

    6. A. DB2 Connect Enterprise Edition

    7. C. A column D. An index key

    8. B. Check pending

    9. A. Query

    10. B. Performed to identify the server the DB2 database manager is on

    Hope my answers are right!!!

    Regards

    Nitin.

  3. #3
    Join Date
    Oct 2003
    Posts
    18
    For the second question, the answer is Cursor stability(it gives consistent data for every query)...

    for 5th question, the answer is D...(grant execute on procedure p.proc1 to user3)

    and for question 7, C is right....locks cannot be obtained on colums...it can be obtained on index key...

    Try to study " db2 v8.1 certification exam 700 study guide " by Roger sanders..This may help u passing ur exam..

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    The second question is not clear.

    RR gives an internally consistent answer set (no phantom rows in the answer set), and the same answer set even if the query is submitted twice within the same unit of work (UOW).

    RS gives an internally consistent answer set (no phantom rows in the answer set) for each individual query, but could be different if the same query is submitted again in the same UOW.

    I doubt it is CS, which could provide an inconsistent answer set (phantom rows).

    I would guess that the answer is RS, but not sure based on their meaning of "consistent data for every query."

  5. #5
    Join Date
    Oct 2003
    Location
    York UK
    Posts
    9
    I have passed the certification 700. I socred 81%. Thanks every body for the help, I really mean it.

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Congratulations on passing.

    The next one (Exam 701 - DB2 UDB V8.1 for Linux, UNIX and Windows Database Administration) is a lot tougher, but the pass score is only 51% I believe.

  7. #7
    Join Date
    Oct 2003
    Posts
    29
    Its 61% required to Pass

  8. #8
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Are the sample test pass levels different than the real tests? I just checked the IBM website and it says 51% pass for the sample test on 701 Exam 701 - DB2 UDB V8.1 for Linux, UNIX and Windows Database Administration.

    I would provide a link, but you have to login first to see the web page I am looking at.

  9. #9
    Join Date
    Oct 2003
    Location
    York UK
    Posts
    9
    I think for 700 its 61% and 701 its 51%

  10. #10
    Join Date
    Oct 2003
    Posts
    18
    I think, Passing score for exam 701 is 61% or better....(out of 70 questions)

    you can check it out at....
    http://www-3.ibm.com/software/data/e...s/exam-701.pdf

  11. #11
    Join Date
    Feb 2004
    Location
    phoenix
    Posts
    1

    Re: certification

    Hi Rusiar,

    can u provide questions which u had faced in the certification exam. also if u have sm sample questions with u for this certification it wld be of gr8 help.

    Sumit



    Originally posted by rusiar
    Please help me with the following certification (certification no 700, fundamentals for DB2 UDB V8.1)questions

    A developer is building an embedded SQL application on AIX that will access DB2 UDB for OS/390 or OS/400 servers.
    Which of the following products is required to be installed on the AIX system in order to build the application?

    A. DB2 Connect Personal Edition
    B. DB2 Personal Developer's Edition
    C. DB2 UDB Workgroup Server Edition
    D. DB2 Universal Developer's Edition
    ----------------------
    Given a read-only application that requires consistent data for every query, which of the following isolation levels should it use to provide the most concurrency with other applications doing updates?

    A. Read Stability
    B. Repeatable Read
    C. Cursor Stability
    D. Uncommitted Read
    -----------------
    A table has had check constraint enforcement turned off, and additional data has been inserted. Which of the following will perform data validation to ensure that column values are valid?

    A. Add a trigger
    B. Collect statistics
    C. Reorganize the table
    D. Enable check constraints
    --------------
    A stored procedure has been built and deployed on the DB2 UDB server machine. What is the minimum software that must be installed to allow an application on the client to execute the stored procedure?
    A. DB2 Runtime Client
    B. DB2 Personal Edition
    C. DB2 Administration Client
    D. DB2 Application Development Client

    ---------------------
    USER3 is running a program A.APP1 that calls stored procedure P.PROC1.
    As an administrator, which of the following statements should be executed to give USER3 the appropriate privilege to be able to execute the code found in stored procedure P.PROC1?

    A. GRANT EXECUTE ON PACKAGE a.app1 TO user3
    B. GRANT EXECUTE ON PROCEDURE a.app1 TO user3
    C. GRANT EXECUTE ON FUNCTION p.proc1 TO user3
    D. GRANT EXECUTE ON PROCEDURE p.proc1 TO user3

    ------------------------
    A client application on OS/390 or OS/400 must access a DB2 server on Linux. At a minimum, which of the following products is required to be on the DB2 server?


    A. DB2 Connect Enterprise Edition
    B. DB2 UDB Enterprise Server Edition
    C. DB2 Connect Enterprise Edition and DB2 UDB Workgroup Server Edition
    D. DB2 Connect Enterprise Edition and DB2 UDB Enterprise Server Edition
    -------------------------
    For which of the following database objects can locks NOT be obtained?

    A. A row
    B. A table
    C. A column
    D. An index key
    ---------------------------------------
    When constraint checking is suspended or disabled, a table or table space (depending on platform) is placed in which of the following states?

    A. Paused
    B. Check pending
    C. Intent locked
    D. Constraint waiting


    Which of the following processes is NOT performed by DB2 Warehouse Manager?

    A. Query
    B. Loading
    C. Extraction
    D. Transformation

    ---------------------------

    Cataloging a remote database server from a Linux, Unix or Windows gateway is :

    A. Performed to identify the location of the clients
    B. Performed to identify the server the DB2 database manager is on
    C. Never performed in DB2, as only one database per node is allowed, so cataloging a node automatically catalogs the database at that node
    D. Performed on a Linux, UNIX, or Windows machine to open the catalogs in the DB2 databases server and present a user with a list of all accessible tables in the databse.

    Thanks for your help

  12. #12
    Join Date
    Oct 2003
    Posts
    29
    55% ---> Exam # 512 ---> FOR 7.1 (CERTIFIED SPECIALIST)
    61% ---> Exam # 701 ---> FOR 8.1 (CERTIFIED DBA)

    IBM accepts exam # 512 and exam # 700 to get in to exam # 701.

    I got certified by taking 512 and 701 exams.

    Thanks
    Racha

  13. #13
    Join Date
    Oct 2003
    Posts
    29
    IBM ACCEPTS EITHER EXAM # 512 or # 700 to take exam # 701

    CHEERS
    RACHA

Posting Permissions

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