Halian Oracle 10g

15 Questions | Total Attempts: 179

SettingsSettingsSettings
Please wait...
Halian Oracle 10g

This is an Oracle test (incl RDBMS, PLSQL, Backup/ recover, Gridcontrol, Dataguard, ASM)


Questions and Answers
  • 1. 
     To successfully complete the installation of Oracle 10g, which disk size do you need?
    • A. 

      800 MB

    • B. 

      1.2GB

    • C. 

      1.5 GB

  • 2. 
               Your database is in shared server mode, shared pool should not be used by RMAN, Which SGA component should have memory allocated?
    • A. 

      Java pool

    • B. 

      Log buffer

    • C. 

      Large pool

  • 3. 
      Which of the following guarantees that committed data is savedeven if they are not yet recorded in the datafiles?
    • A. 

      LGR and online redo log

    • B. 

      DBW and archived log

    • C. 

      DBW and database buffer cache

  • 4. 
    Many queries are reparsed and application response time is too slow, SGA buffer pool can not be increased, What will you choose?
    • A. 

      Change parameter cursor_sharing from similar to exact

    • B. 

      Change parameter cursor_sharing from exact to similar

    • C. 

      Use the shared server mode

  • 5. 
     Recyclebin is configured and a user has dropped a table,What is true?
    • A. 

      The segment is moved to SYSAUX tablespace

    • B. 

      The segment is still available until the tablespace is full

    • C. 

      The segment is still available until the next restart

  • 6. 
     The following parameters are set to:          SGA_MAX_SIZE         = 2GB        SGA_TARGET           = 1GB        SHARED_POOL_SIZE     = 120MB        LARGE_POOL_SIZE      = 110MB   What is true?
    • A. 

      SHARED_POOL_SIZE can grow up to have SGA=2GB

    • B. 

      SHARED_POOL_SIZE can grow up to have SGA=1GB

    • C. 

      SHARED_POOL and LARGE_POOL has the specified fixed size

  • 7. 
      What should be used to determine the appropriate buffer size in case of to many physical read?
    • A. 

      Segment Advisor

    • B. 

      ADDM

    • C. 

      Memory Advisor

  • 8. 
      About Flashback Database, what is true?
    • A. 

      Flashback logs are archived

    • B. 

      “Alter database flashback on” must be executed when the instance is mounted

    • C. 

      Flashback logs can be manually deleted

  • 9. 
     The view FLASHBACK_TRANSACTION_QUERY retrieve information from?
    • A. 

      UNDO_TABLESPACE

    • B. 

      REDO_LOG

    • C. 

      Flash recovery area

  • 10. 
    CONTROLE_FILE_RECORD_KEEP_TIME parameter is set to 15, What is true?
    • A. 

      Backup will be maintained on media for 15 days

    • B. 

      Backup will be maintained in recovery catalogue and control file for 15 days

    • C. 

      Backup will be maintained in control file for 15 days

  • 11. 
     You want to use AUTOEXTEND ON features for some data, What is true?
    • A. 

      You can set AUTOEXTEND at tablespace level

    • B. 

      You can set AUTOEXTEND to a dedicated data file

    • C. 

      You must set AUTOEXTEND to all data files of a tablespace

  • 12. 
      What is the result of the command “alter database backup control file to trace”?
    • A. 

      Binary backup of the control file

    • B. 

      Script to create the control file with the data files

    • C. 

      Script to create the control file with the data files and temp files

  • 13. 
    You need to reorganize online a table to get a partitioned table,        What can you use?
    • A. 

      Alter table statement

    • B. 

      Dbms_redefinition package

    • C. 

      It is no possible to do it online

  • 14. 
      About the statement “alter index IDX1 rebuild online”,        What is true?
    • A. 

      The result is the same as drop and create index

    • B. 

      It is not possible to rebuild index online

    • C. 

      It will be reorganized but the index will keep his depth

  • 15. 
    You need to kill one Oracle session by knowing only the Unix process number,        where can you get the information to build your command?
    • A. 

      V$session

    • B. 

      V$process

    • C. 

      V$session and v$process