DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: which one and why?

  1. #1
    Join Date
    Aug 2002
    Posts
    55

    which one and why?

    Q. What are two reasons for changing user quotas on a tablespace? (Choose two).
    a. a datafile becomes full.
    b. a user encounters slow response time from the application.
    c. tables owned by a user exhibit rapid and anticipated growth.
    d. database objects are reorganized and placed in different tablespace.

    pls explain (if possible with ref.) why your answers are correct .

  2. #2
    Join Date
    May 2002
    Location
    Western Australia
    Posts
    233
    Hi Alauddin,


    c. tables owned by a user exhibit rapid and anticipated growth.
    d. database objects are reorganized and placed in different tablespace.
    C: (Typo ? unanticipated growth) If growth is unanticipated, user quota may have been set to low.

    D: Quotas apply to a tablespace, therefore if tables are moved to a different tablespace, users will need a quota on the new tablespace.

    HTH

    Nick

  3. #3
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    I agree with Nick, it has to be 3,4 also because 1,2 are laughable answers.
    OCP 8i, 9i DBA
    Brisbane Australia

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    common sense question, even you dont know the answers you get them right by eliminate the laughable answers

  5. #5
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    It really is a bad example of a question, isn't it?
    Last edited by grjohnson; 12-18-2002 at 07:28 PM.
    OCP 8i, 9i DBA
    Brisbane Australia

  6. #6
    Join Date
    Nov 2002
    Posts
    47
    Q. a dba grants user A the alter user privilege with admin option. user A create roles and grants the alter user to user B. what will happen to the roles user A created, and also to user B's privileges, if you drop user A with cascade option?
    a.the roles will remain and user b will lose the alter user privilege.
    b.the roles will remain and user b will not lose the alter ueser privilege.
    c.the roles will be removed and user b will lose the alter ueser privilege.
    d.the roles will be removed and user b will not lose the alter user privilege.
    which one is correct.

    (alter user is a system privilege; and here the system privilege granted with admin option to B; B will lost the privilege?)

  7. #7
    Join Date
    May 2002
    Posts
    2,645
    What is the difference between system privileges and object privileges? Which set is persistent, and which is not?

    http://download-west.oracle.com/docs...rivs.htm#15326

  8. #8
    Join Date
    Nov 2002
    Posts
    47
    Originally posted by stecal
    What is the difference between system privileges and object privileges? Which set is persistent, and which is not?
    http://download-west.oracle.com/docs...rivs.htm#15326
    thanks for prompt reply. ok, i will visit this weblink. now kindly tell me what is your answer for this question.

  9. #9
    Join Date
    May 2002
    Posts
    2,645
    Kindly, no, I will not answer the question again. The answer is in black and white right in front of you at that link. Scroll down a bit to the revoking section. Sheesh!

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