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