Some Interesting Qs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Some Interesting Qs

  1. #1
    Join Date
    Mar 2001
    Posts
    24

    Unhappy

    I have posted below some 7 questions with what I think is the correct answer which I would like to get some feedback on see what you think.....



    45. What happens to the block when the PCTUSED threshold is crossed? A

    A. It is entered into the free list of tables.
    B. It is inaccessible to INSERT statements.
    C. It is deleted from the free list of the table.
    D. It is in accessible to DELETE statements.
    E. It is inaccessible to UPDATE statements.


    46. The extent sizes of a table should be _____ to improve performance of the table scans. A

    A. All equal
    B. No larger than five times DB_BLOCK_SIZE
    C. Equal to the size of the biggest possible row
    D. A multiple DB_FILE_MULTIBLOCK_READ_COUNT


    48. Which data dictionary view would you query to retrieve a table’s header block number? Huh?

    A. DBA_TABLE
    B. DBA_TABLES
    C. DBA_OBJECT
    D. DBA_OBJECTS
    E. DBA_SEGMENT
    F. DBA_SEGMENTS


    50. Which password management feature is NOT available by using a profile? A

    A. Account locking
    B. Password history
    C. Password change
    D. Password aging and expiration


    60. Which two operations would you use to move read-only data to a write-once (WORM) drive? E+B

    A. Issue the command ALTER TABLESPACE . . . WRITE ONCE.
    B. Issue the command ALTER TABLESPACE . . . RENAME DATAFILE.
    C. Move the data file to the WORM drive using ALTER DATABASE . . . RENAME DATAFILE.
    D. Use the ALTER TABLESPACE. . . MOVE DATAFILE command to move the data files of the tablespace to the WORM drive.
    E. Use an operating command to move the data file of the tablespace to the WORM drive.


    61. What determines the initial size of a tablespace? E

    A. Use INITIAL clause of the CREATE TABLESPACE statement.
    B. The MINEXTENTS clause of the CREATE TABLESPACE statement.
    C. The MINIMUM EXTENTS clause of the CREATE TABLESPACE statement.
    D. The sum of the INITIAL and NEXT clauses of the CRETAE TABLESPACE statement.
    E. The sum of the sizes of datafiles specified in the CREATE TABLESPACE statement.



    63. You created a password file using the operating system command line:

    Orapwd file=orapsORCL password=secure enteries=5

    Which two users with a password of “secure” are included automatically in the password file? A,C

    A. SYS
    B. SCOTT
    C. SYSTEM
    D. DBADMIN
    E. INTERNAL



    Thanks
    Rex

    Yes indeed just like a dog with a bone!!

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

    Question


    48 = DBA_SEGMENTS

    63 = SYS and INTERNAL (not SYSTEM)

    61 = this looks like they are asking about tablespace segment size and not physical size. So, if that is the case then INITIAL would be the answer. Somewhat misleading question there, but I would say that A might be the MOST correct answer? anyone have any suggestions on this one?

    - Magnus

  3. #3
    Join Date
    Oct 2001
    Posts
    24
    Hi rexbone,

    It seems you are having lot of practice questions for admin,do u mind sending it to nmrc_eric@yahoo.com.

    bye
    eric

  4. #4
    Join Date
    Nov 2001
    Location
    toronto
    Posts
    67
    hi
    i think initial size of the tablespace depends on the size of datafiles created during tablespace creation, would go with E.

  5. #5
    Join Date
    Nov 2001
    Location
    toronto
    Posts
    67

    a&a q's

    hi rex
    well, im about to take the a&a, and just thought if you'd remeber any q's that you would like to pass along.
    much thanks.

  6. #6
    Join Date
    Mar 2001
    Posts
    24
    Come on you guys give me some feedback on these questions if you think they are right or otherwise tell me.

    Hi Nach I will be posting a follow up to this in a day or 2 just waiting for more feedback.

    Rex

    Still running with the bone!

  7. #7
    Join Date
    Sep 2001
    Posts
    261
    45. C
    46. D
    48. ?
    50. A
    60. B & E
    61. E
    62. A & E
    The Maverick
    Oracle Certified DBA - 8i

  8. #8
    Join Date
    Nov 2001
    Location
    toronto
    Posts
    67
    45=B
    46=A
    48=F
    50=A
    63=A,E

  9. #9
    Join Date
    Nov 2001
    Location
    USA
    Posts
    12
    Hi Rexbone,

    I saw your Q's -Interesting.
    The answers are like this ;
    45- B
    46- A
    48- F
    50- A
    60- B & E
    61- E
    63- A & E

    Good luck

    Syed

  10. #10
    Join Date
    Feb 2002
    Posts
    166
    45- A
    46- D
    48- F
    50- C
    60- B & E
    61- E
    63- A & E

    Anyone corrects me??? Thx a lot
    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