• VMware

    Learn about VMware virtualization for its products like vsphere ESX and ESXi, vCenter Server, VMware View, VMware P2V and many more

  • Linux

    Step by step configuration tutorials for many of the Linux services like DNS, DHCP, FTP, Samba4 etc including many tips and tricks in Red Hat Linux.

  • Database

    Learn installation and configuration of databases like Oracle, My SQL, Postgresql, etc including many other related tutorials in Linux.

  • Life always offers you a second chance ... Its called tomorrow !!!

    Wednesday, June 18, 2014

    Oracle Database (QUIZ)

    NOTE: Each correct answer would give you 5 points

    1. Which portion of the System Global Area, also known as SGA holds information about changes made to the database?
    2. The redo log buffer
      The database buffer cache
      The large pool
      The shared pool


    3. Which task is performed by the system monitor or SMON process?
    4. Copying redo log files to a designated storage device
      Writing dirty buffers to disk
      Performing instance recovery at instance startup
      Cleaning up the database buffer cache

    5. Which task is performed by the ARCn processes?
    6. Cleaning up the database buffer cache
      Copying redo log files to a designated storage device
      Writing dirty buffers to disk
      Performing instance recovery at instance startup

    7. Which task is performed by the PMON process?
    8. Performing instance recovery at instance startup
      Writing dirty buffers to disk
      Cleaning up the database buffer cache
      Copying redo log files to a designated storage device

    9. What is the minimum Oracle block size?
    10. 1 KB
      2 KB
      4 KB
      8 KB


    11. Which type of file in Oracle Database defines how the instance is configured when it starts up?
    12. Parameter files
      Data Files
      Online redo log files
      Control Files


    13. Which logical database structure groups data files together?
    14. Tablespace
      Data block
      Extent
      Segment

    15. What area in the shared pool holds a collection of database tables and views with reference information about the database, its structures and its users?
    16. The shared SQL area
      The data dictionary
      The library cache
      The database buffer cache

    17. Which task is performed by the checkpoint also known as CKPT, process?
    18. Writing dirty buffers to disk
      Copying redo log files to designated storage device
      Updating the header of all data files with the current SCN
      Cleaning up the database buffer cache

    19. Which task is performed by the database writer also known as DBWn process?
    20. Cleaning up the database buffer cache
      Updating the header of all data files with the current SCN
      Writing dirty buffers to disk
      Copying redo log files to designated storage device

    21. What is the task performed by recoverer or RECO process?
    22. Copying redo log files to designated storage device
      Automatically resolving failures involving distributed transactions
      Updating the header of all data files with the current SCN
      Cleaning up the database buffer cache

    23. Which edition of Oracle is only appropriate for servers upto 4 sockets?
    24. Standard Edition
      Enterprise Edition
      Standard Edition One
      RAC Edition


    25. Which task is performed by the database Configuration Assistant?
    26. Configuring and managing Oracle Network configurations
      Creating a database from Oracle supplied templates
      Installing oracle software and options
      Upgrading an existing database to new oracle release

    27. Which oracle environment variable controls client character set settings?
    28. NLS_LANG
      ORACLE_HOME
      ORACLE_BASE
      ORACLE_SID


    29. Which task is accomplished by executing the root.sh script during installation of Oracle Grid Infrastructure software?
    30. Creating an ASM disk group
      Changing the permission of the Oracle Central Inventory directory
      Performing prerequisites check
      starting the ohasd daemon

    31. Which tablespace in a preconfigured database is used during large sort operations or creation of an index?
    32. UND0TBS1
      SYSTEM
      SYSAUX
      TEMP


    33. How large is the default extent size when you specify the uniform extent allocation method?
    34. 256 KB
      512 KB
      1 MB
      2 MB


    35. Which portion of data block grows from the bottom upwards?
    36. Segment
      Row data
      Free space
      header


    37. Which offline status for a tablespace has been deprecated in Oracle database 11g and has been retained only for backward compatibility?
    38. For Recovery
      Temporary
      Normal
      Immediate

    39. Which method of authentication is used if x509 certificates are used?
    40. Global
      Advanced
      External
      Password


    41. What system privilege assigned to a user will allow that user to connect to the database with the same privilege as the SYS user?
    42. SYSDBA
      SYSASM
      SYSOPER
      GRANT ANY OBJECT PRIVILEGE


    43. Which predefined role contains only the CREATE SESSION privilege?
    44. RESOURCE
      SCHEDULER_ADMIN
      DBA
      CONNECT


    45. When you create a user what is the default quota setting used for any available tablespace?
    46. Unlimited
      UNLIMITED TABLESPACE
      None
      Value


    47. If a user has been granted the CREATE ANY TABLE privilege, where can that user create the table?
    48. In all schemas
      In the DBA's schema only
      In their schema only
      In their schema and DBA's schema

    49. Which wildcard character provided by Oracle database 11g for archive log naming is optional?
    50. %r
      %d
      %s
      %d


    51. Which type of database is best suited for transaction processing?
    52. Custom
      Multipurpose
      General purpose
      Data Warehouse

    53. Which is an example of single byte character set?
    54. AL32UTF8
      JA16SJIS
      WE8IS08859P1
      ZHT16HKSCS


    55. What is the name of the process that should be started before using database control?
    56. emctl
      dbconsole
      sqlplus
      bin


    57. When selecting the database creation options, which action will be performed first if all options have been selected?
    58. Creating the database
      Modifying the database storage settings
      Generating scripts
      Saving the database as template

    59. Which shutdown mode performs the least amount of work before shutting down?
    60. TRANSACTIONAL
      ABORT
      IMMEDIATE
      NORMAL




    0 comments:

    Post a Comment