Halian Oracle Test

40 Questions | Total Attempts: 40

SettingsSettingsSettings
Please wait...
Oracle Quizzes & Trivia

Welcome, This is an oracle 10g test


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

      800MB

    • B. 

      1.2GB

    • C. 

      1.5GB

  • 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 saved even 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

  • 16. 
    The Oracle instance crash, but the Unix shared memory is not cleared, How can you free the memory?    
    • A. 

      Using ipcs Unix command

    • B. 

      Using ipcrm Unix command

    • C. 

      It is not possible to do it with an oracle account, call the System Administrator.

  • 17. 
    The Automatic statistics collection feature enabled by default in 10G Will collect statistics base on,  
    • A. 

      each modify object

    • B. 

      Stale data

    • C. 

      At fixed time interval

  • 18. 
    You want to set the trace level on one listener, How can you proceed?    
    • A. 

      Connect to the listener and: set trace_level_listener=admin

    • B. 

      Connect to the listener and: set trc_level admin

    • C. 

      Restart the listener with the appropriate command option

  • 19. 
    You want to get trace files from a specific session, How can you proceed?   using “sys.dbms_system.set_sql_trace_in_session…” using “set autotrace on” using “alter session trace on”
    • A. 

      Using “sys.dbms_system.set_sql_trace_in_session…”

    • B. 

      Using “set autotrace on”

    • C. 

      Using “alter session trace on”

  • 20. 
      By using tkprof you can,      
    • A. 

      Not exclude statements run as user SYS

    • B. 

      Get information on wait events

    • C. 

      Get information on memory usage

  • 21. 
    About moving a table, what is true?    
    • A. 

      Index are not impacted

    • B. 

      Parallel query is not allowed during the move of the table

    • C. 

      The move will suppress chained rows

  • 22. 
    Users A and B are updated a table at the same time with no commit statement, then user C execute a select on that table, What is true?  
    • A. 

      C will see the data modified by A and B

    • B. 

      C can reach an ORA-01555 if UNDO tablespace is too small

    • C. 

      C will have to wait for the end of the update from A and B

  • 23. 
    Concerning the UNION operator, what is the best about performance?    
    • A. 

      UNION ALL

    • B. 

      UNION

    • C. 

      UNION and UNION ALL gives no performance difference

  • 24. 
      You want to compile all objects in one user schema, What will you use?  
    • A. 

      Dbms_utility.compile_schema

    • B. 

      Create our own sql script

    • C. 

      Use the Oracle utlrp.sql script

  • 25. 
    Redo log files are multiplexed and one member in a group is lost, What will you do?  
    • A. 

      Shutdown the instance and start a complete recovery

    • B. 

      Shutdown the instance and start it with “open resetlogs”

    • C. 

      Drop the lost member with the instance running and add a new member