8i Admin & Arch - 4 Questions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: 8i Admin & Arch - 4 Questions

  1. #1
    Join Date
    Nov 2001
    Location
    New Brunswick, NJ
    Posts
    67
    PLEASE HELP - I NEED SOME CLARIFICATION ON THE QUESTIONS BELOW.

    1. Which statement about using PCTFREE and PCTUSED is true?

    Is it only at a segment level? Multiple segments belong to a single tablespace, so shouldn't it be both?

    A. Block space utilization can be specified only at the segment level.
    B. Block space utilization can be specified only in the data dictionary.
    C. Block space utilization parameters can only be specified at the tablespace.
    D. Block space utilization can be specified both at the tablespace level and segment level.


    2. Which two parameters might affect the concurrency of transactions on a data block? (choose 2)

    INITTRANS makes sense of course, but what is the other & why?

    A. PCTUSED
    B. PCTFREE
    C. INITRANS
    D. MAXEXTENTS
    E. NEXTEXTENT


    3. Which are DATABASE event triggers?

    A. DROP USER
    B. ALTER VIEW
    C. CREATE DB
    D. CALL TO A PROCEDURE


    4. What are two effects of setting REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE? (choose 2)

    C is correct, but I'm not sure if D or E is the other correct answer. SYSDBA is a granted priv, so are they trying to say by default, SYSDBA would not be allowed in until this is done?

    A. Passwordfile can be stored remotely
    B. Passwordfile access is restricted to local users
    C. Only one instance on the database can use the passwordfile
    D. Remote connection using the SYSDBA privileges are allowed
    E. Remote connection using the SYSDBA privileges are prohibited


    Thank you very much!



  2. #2
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    #1 is D

    #4 the other is D


    #2 & 3 I am not sure about.

    - Magnus

  3. #3
    Join Date
    Oct 2001
    Posts
    38
    1. A
    2. A, C
    3. A (not sure)
    4. C,D

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    3 is not really a very good question. I would guess the answer they are looking for is B.

    Answer A is incorrect because I don't think a trigger fires when a user is dropped. System event triggers operate on objects or user logon/logoff. I am not sure if they operate on user creation.

    Answer C is incorrect because a trigger doesn't get fired in this case.

    Answer D is incorrect because it is not a valid event.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Nov 2001
    Location
    New Brunswick, NJ
    Posts
    67

    Answers

    marist89 - Thanks for the guess... Any guess on the other 3?

    Thanks,

    Paul

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    1. A. Since its PCTFREE and PCTUSED they're talking about, you can't specify at tablespace level.
    2. A,C
    4. C,D
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  7. #7
    Join Date
    Nov 2001
    Location
    New Brunswick, NJ
    Posts
    67

    PCTUSED - Concurrency?


    How does PCTUSED affect the concurrency of transactions on a data block?

    Thanks,

    Paul

  8. #8
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    INITTRANS makes sense of course, but what is the other & why?

    A. PCTUSED
    B. PCTFREE
    C. INITRANS
    D. MAXEXTENTS
    E. NEXTEXTENT

    Good question. If you set a high value for PCTUSED, then you may decrease performance, because more migrated and
    chained rows are present. Then low INITRANS on the other blocks may affect concurrency of the transaction.

    With a low value for PCTUSED, the space usage is not efficient due to unused space in data blocks.


  9. #9
    Join Date
    Nov 2001
    Location
    New Brunswick, NJ
    Posts
    67
    Thank you Julian.

    I appreciate the help.

    PW

  10. #10
    Join Date
    Feb 2002
    Posts
    166
    Originally posted by julian

    INITTRANS makes sense of course, but what is the other & why?

    A. PCTUSED
    B. PCTFREE
    C. INITRANS
    D. MAXEXTENTS
    E. NEXTEXTENT

    Good question. If you set a high value for PCTUSED, then you may decrease performance, because more migrated and
    chained rows are present. Then low INITRANS on the other blocks may affect concurrency of the transaction.

    With a low value for PCTUSED, the space usage is not efficient due to unused space in data blocks.

    It really mess me. I found an some old threads answered BC and there is a guy got 63/64 stated the answer is BC too.
    MCSE/MCDBA, OCP DBA 8i
    Working on SCJP -> SCJD

Posting Permissions

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



Click Here to Expand Forum to Full Width