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

Thread: real 8i questions

  1. #1
    Join Date
    Jan 2001
    Posts
    31

    Exclamation braindumps

    ..

    [Edited by johnz on 02-24-2001 at 02:31 AM]

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    1.when using password file authentication, $orapwd file=$oracle_hoem/dbs/orapwu15 password=admin entries=5, the password that is indicated is for whom?

    I dont know since there is no answers to choose here...? For whom depends on your init.ora, for which instance would be u15...

    2.In what case would you use STARTUP RESTRICT to startup the database?

    A. When Index needs to be drop
    B. When Tablespaces needs to be go offline
    C. When current instance needs to be accessing two database
    D. When export database without the disruption by any other users.

    D

    Which tables contains the table’s header block number?

    A. DBA_TABLES
    B. DBA_OBJECTS
    C. DBA_EXTENTS
    D. DBA_SEGMENTS
    E. DBA_BLOCKS

    D

    Which events can cause a database event trigger to fire? (Choose three)

    A. CREATE INDEX
    B. UPDATE USER
    C. ALTER USER
    D. DELETE TRIGGER
    E. DROP ROLE
    F. INSERT INTO

    I am not sure since I havent used much database events but I would guess C, D, E,

    ALTER DATABSE RENAME FILE, what just happened?

    A. Copied existing file
    B. Updated control file
    C. Copied existing file and updated control file

    A

    What is the purpose of a PL/SQL package DBMS_TTS?

    A. To issue DDL statements
    B. To analyze redo log files
    C. To check whether a tablespace is self-contained or not

    C

    How can you change READ-ONLY tablespaces to READ ONCE (prod) device?

    What is true about Direct Path Load in SQL*LOADER? (Choose two)

    A. It generates redo only under specific conditions.
    B. Insert triggers fire
    C. Can load into clustered tables
    D. Other users cannot make changes to tables
    E. Uses COMMIT to make changes permanent
    F. Enforces all constraints

    I guess it's D

  3. #3
    Join Date
    Feb 2001
    Posts
    44

    You've got exactly same questions as i did

    First of all, I'm surprised that you've got exactly same questions that I got from last Wednedsday's test on Oracle 8i Architecture and Administration. I have sent out the 55 out of 64 questions that I got from the test to various people already and if they see this questions they will be surprised.

    I told people that the Oracle Corp has changed the test styles and formats, and it seems to me they only made one set of test questions.

    When did you take this test?

    Anyway, let me give my answers to those questions. This is strictly from my knowlede and not 100% correct.

    1. I think I know this one and I'already checked with my notes, the answer is SYS and INTERNAL.(100%sure)

    2. This is D, STARTUP RESTRICT is for restricted access person only, therefor without the disruption by any other users. (100%sure)

    3. This one I had problems too. I'm not sure about this one, but I picked A, DBA_TABLES(not sure on this one)

    4. Event Trigger checks the following:
    Instance Startup or Shutdown
    Erroer Message
    User Logon or Logoff
    Create, Alter, Drop schema
    So, answer to this question is A,C,E (100% sure)

    5. ALTER DATABASE RENAME FILE is when you renaming the file and the control file is updated whenever a datafile or redo log file is added, renamed, or dropped. So answer to this is C(100%sure)

    6. The DBMS_TTS package includes the TRANSPORT_SET_CHECK procedure. This procedure checks if a set of tablespaces to be transpoted is self-contained. So this is C(100% sure)

    7. READ-ONLY to READ-ONCE. I have no clue on this one, I've got this one wrong, I've never heard about READ_ONCE. Anybody else? (not sure)

    8. Direct Path Load in SQL*LOADER had following chracteristics:
    1) Uses data saves
    2)Generates redo only under specific conditions
    3) Enforces only primary key, unique, and not null.
    4) INSERT triggers do not fire.
    5) Cannot load into clustered tables
    6) Other users cannot make changes to tables.

    So answer to this is A,D (100% sure), all other choices are the characteristics of Conventional Path Load.

    I felt this test was different from the past Oracle test. I've noticed that Oracle Corp didn't offer this test for last two weeks and I'm assuming that they have made some changes to this test, and definately it got harder. Like I said before, there are more choices to choose from and most of the questions asked for two answers.

    I still cannot believe that you took exactly same test as I am, but congratulations.....it doesn't matter whether you've got high score or low score....this is only pass/fail exam...as long as you pass....that's all it matters. you probably feel lucky by now....nice job.....you passed.......

    Yong


  4. #4
    Join Date
    Jan 2001
    Posts
    31

    Thumbs up dba_segments

    3. This one I had problems too. I'm not sure about this one, but I picked A, DBA_TABLES(not sure on this one)
    it is dba_segments. You can desc from sql+ to see the column



    7. READ-ONLY to READ-ONCE. I have no clue on this one, I've got this one wrong, I've never heard about READ_ONCE. Anybody else? (not sure)
    It is to change read_only to WORM(write once read many). It has a long description in Oracle document.

    Oracle make the test harder. I have a lot of brain dumps that do not appear in this test.
    Thanks Mr. Choi, you did a good job. When will you take the backup and recovery?



    [Edited by johnz on 02-18-2001 at 11:14 PM]

  5. #5
    Join Date
    Dec 2000
    Posts
    43
    Which events can cause a database event trigger to fire? (Choose three)

    A. CREATE INDEX
    B. UPDATE USER
    C. ALTER USER
    D. DELETE TRIGGER
    E. DROP ROLE
    F. INSERT INTO

    The dba handbook states that triggers are fired on inserts, deletes and updates. Could someone explain how the triggers are fired in this questions specifically!?


  6. #6
    Join Date
    Jul 2000
    Location
    Amsterdam
    Posts
    234

    Database trigger

    Hi Blurry,


    Your question:

    Which events can cause a database event trigger to fire? (Choose three)

    A. CREATE INDEX
    B. UPDATE USER
    C. ALTER USER
    D. DELETE TRIGGER
    E. DROP ROLE
    F. INSERT INTO

    I think the statements B and D have the wrong syntax. Further on The insert into is a table trigger.

    So I think A, C, and E are wright.

  7. #7
    Join Date
    Feb 2001
    Posts
    12
    Hello,

    Regarding this question:

    ALTER DATABSE RENAME FILE, what just happened?

    A. Copied existing file
    B. Updated control file
    C. Copied existing file and updated control file


    I think the correct answer to this question is B not C or A, as is suggested by earlier posts. This is because all this command does is update the control file; it does not move or copy any files. You have to do that job manually.

    Steve

  8. #8
    Join Date
    Aug 2000
    Posts
    143
    Where can I get a full set of sample questions?

  9. #9
    Join Date
    Nov 2000
    Location
    Potomac, Maryland
    Posts
    85
    I would like to correct the postings on the following question:

    ALTER DATABSE RENAME FILE, what just happened?

    A. Copied existing file
    B. Updated control file
    C. Copied existing file and updated control file

    The answer is B and not C as stated above. The alter database rename file "location1" to "location2"; command only updates the control file to point to the new location. It does not copy a datafile nor does it move one to a new location. You will have to copy the actual datafile to the new location using an operating system command then issue the "alter database rename file" command to update the control file.

    At least, this is how is works on Oracle8i. Maybe in later releases, Oracle may modify this to accomplish both tasks.
    Oracle10 maybe ;). I know oracle9 only updates the control file.
    Regards,

    Robel Girma

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