Halian Oracle Test

40 Questions

Settings
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

  • 26. 
    You get the message “ORACLE data block corrupted (file 5, block 114)” You are in time pressure to solve the problem, what will you choose?  
    • A. 

      RMAN: recover datafile 5;

    • B. 

      RMAN: blockrecover corruption list;

    • C. 

      RMAN: blockrecover datafile 5 block 114;

  • 27. 
     Rman backup failed because the Flash Recover Area is full, What can you do?  Choose two answers  
    • A. 

      Increase Flash Recover Area system disk size

    • B. 

      Increase DB_RECOVER_FILE_DEST_SIZE

    • C. 

      Choose a smaller period for the backup retention policy

  • 28. 
     You have started an RMAN recover with the “set until sequence 400” option, RMAN will recover up to witch log sequence?    
    • A. 

      Included sequence 400

    • B. 

      Included sequence 399

    • C. 

      Depend also of other RMAN option used

  • 29. 
    You want to minimize the amount of time for instance recovery, Which parameter can be changed?    
    • A. 

      LOG_CHECKPOINT_TIMEOUT

    • B. 

      FAST_START_MTTR_TARGET

    • C. 

      LOG_CHECKPOINT_INTERVAL

  • 30. 
    Your RMAN backup failed because one archived log is missing on disk, you need a backup soon, What will you do?    
    • A. 

      Execute rman command “crosscheck archivelog all” and start a backup

    • B. 

      Start a backup without being connected to the catalogue

    • C. 

      Recreate the catalogue and start a new backup

  • 31. 
    About Data Pump Export utility,What is true? Choose two answers  
    • A. 

      You can export a subset of a table

    • B. 

      You can specify the full path for the dump files

    • C. 

      You can specify the number of Oracle workers process

  • 32. 
    Which of the following is an Enterprise Manager Grid Control component?    
    • A. 

      Oracle Management Agent

    • B. 

      Oracle Management Service

    • C. 

      Agent and Service

  • 33. 
    Identify the file that provides a list of all the ports used in Grid Control installation.    
    • A. 

      /install/portlist.ini

    • B. 

      /install/portlist.ini

    • C. 

      /sysman/log/emoms.log

  • 34. 
    You can apply Monitoring Templates on:    
    • A. 

      Targets

    • B. 

      Groups

    • C. 

      Targets and Groups

  • 35. 
    Which privilege enables a user to start a blackout on a target, but not delete a target?    
    • A. 

      View

    • B. 

      Operator

    • C. 

      Full

  • 36. 
    On which view can you see if archive log has been applied on a standby DB?  
    • A. 

      V$DATAGUARD_STATUS

    • B. 

      V$ARCHIVED_LOG

    • C. 

      V$ARCHIVE_DEST_STATUS

  • 37. 
     A physical standby DB has been open as read only,       What is true?  
    • A. 

      each archive logs need to be apply later on manually

    • B. 

      The primary DB can be shutdown and start-up

    • C. 

      After the standby restart the logs are applied by default

  • 38. 
    What will you do to increase the ASM rebalance process when adding a disk to a disk group? choose 2 answers  
    • A. 

      Increase the number of DB_WRITER_PROCESS

    • B. 

      Increase the parameter ASM_POWER_LIMIT

    • C. 

      Use the REBALANCE option in adddiskgroup command

  • 39. 
    You just added a new disk group in your ASM instance, What is the next action?  
    • A. 

      Add it to the ASM_DISKSTRING parameter

    • B. 

      Restart the ASM instance

    • C. 

      Mount the new disk group in the ASM instance

  • 40. 
     Which option would you used to migrate database file from a non-ASM to an ASM-instance?    
    • A. 

      RMAN

    • B. 

      OS utility to copy files to the ASM instance

    • C. 

      Oracle Data Pump Export Import Utility