Oracle_architecture

45 Questions

Settings
Please wait...
Oracle Quizzes & Trivia

Questions and Answers
  • 1. 
    Data base Provides platform for
    • A. 

      Easy Data management

    • B. 

      Facilita tedata sharing

    • C. 

      Reduces data redundancy

    • D. 

      Simplifying data

  • 2. 
    RDBMS is a database which stores data in the form of _______________
    • A. 

      Views

    • B. 

      Rawdata

    • C. 

      Files

    • D. 

      Tables

  • 3. 
    Set oriented means
    • A. 

      SQL processes sets of data in groups

    • B. 

      SQL processes group of data in rows

    • C. 

      SQL processes sets of data in rows

    • D. 

      SQL processes sets of data in coloumns

  • 4. 
    Combination of the __________ and the _____________ is called an Oracle instance.
    • A. 

      SGA

    • B. 

      Oracle processes

    • C. 

      Cache buffer

    • D. 

      Buffer

  • 5. 
    _____________provide an additional level of table security by restricting access to a predetermined set of rows and columns of a table
    • A. 

      Tables

    • B. 

      Views

    • C. 

      Synonyms

    • D. 

      Segments

  • 6. 
    __________ are the basic unit of data storage in an Oracle database.
    • A. 

      Table

    • B. 

      Views

    • C. 

      Synonyms

    • D. 

      Segments

  • 7. 
    Types of Segments
    • A. 

      Data segment

    • B. 

      Index segment

    • C. 

      Temporary segment

    • D. 

      Rollback segment

    • E. 

      Logical segment

  • 8. 
    A __________consists of a collection of interrelated data and a set of programs to access those data
    • A. 

      RDBMS

    • B. 

      DBMS

    • C. 

      Related data

    • D. 

      Network DBMS

  • 9. 
    Relationship between the tables made _________________ easy
    • A. 

      Representation

    • B. 

      Loading

    • C. 

      Retrieval of the data

    • D. 

      Maintaining

    • E. 

      Manipulating

  • 10. 
    Oracle Grid
    • A. 

      Low cost modular components

    • B. 

      Low incremental costs

    • C. 

      No single point of failure

    • D. 

      Enterprise service at low cost

  • 11. 
    SGA(System Global Area) consists of
    • A. 

      Context Areas

    • B. 

      Oracle processes

    • C. 

      Database Buffer Cache

    • D. 

      Redo log Buffer

  • 12. 
    A schema is owned by a database user and has the same name as that user.
    • A. 

      True

    • B. 

      False

  • 13. 
    All operations performed on a view actually affect the __________of the view.
    • A. 

      Physical data

    • B. 

      Base tables

    • C. 

      Logical Data

    • D. 

      Data

  • 14. 
    A database is divided into logical storage units called _____________
    • A. 

      Table Spaces

    • B. 

      Data Tables

    • C. 

      Segments

    • D. 

      DataFiles

  • 15. 
    Which is\are True?
    • A. 

      Segment>Datablock>Extent

    • B. 

      Extent>Segment>Datablock

    • C. 

      Segment>Extent>Datablock

    • D. 

      Datablock>Extent>Segment

  • 16. 
    A ________is the key to solving the problems of information management.
    • A. 

      DBMS

    • B. 

      Database server

    • C. 

      RDBMS

    • D. 

      SQL

  • 17. 
    IN RDBMS Relationship among the data is stored in the form of ____________
    • A. 

      Views

    • B. 

      Files

    • C. 

      Tables

    • D. 

      Raw data

  • 18. 
    When Oracle starts an instance, it reads the _____________or__________ to determine the values of initialization parameters.
    • A. 

      Initialization parameter file

    • B. 

      Database parameter file

    • C. 

      Server parameter file (SPFILE)

    • D. 

      Cache parameter file

  • 19. 
    Schema objects include structures like _________________
    • A. 

      Synonyms

    • B. 

      Tables

    • C. 

      Segments

    • D. 

      Views

    • E. 

      Indexes

  • 20. 
    Large Dedicated Server
    • A. 

      High Performance

    • B. 

      Expensive costly components

    • C. 

      High incremental costs

    • D. 

      Single point of failure

  • 21. 
     DBMS is a software system that enables users to  ___________________the database and provides controlled access to database
    • A. 

      Control

    • B. 

      Define

    • C. 

      Maintain

    • D. 

      Create

  • 22. 
    Maximum Number of coloumns in a table
    • A. 

      250

    • B. 

      256

    • C. 

      252

    • D. 

      128

  • 23. 
    A ______________ can also be considered a stored query
    • A. 

      Stored Procedure

    • B. 

      Synonym

    • C. 

      Table

    • D. 

      View

  • 24. 
    The purpose of a database is to __________ and__________ information
    • A. 

      Store

    • B. 

      Controlling

    • C. 

      Retrieve related

  • 25. 
    ___________, a component of Oracle Net Services, enables a network session from a client application to an Oracle database server.
    • A. 

      Oracle Server

    • B. 

      Oracle Client

    • C. 

      Oracle database

    • D. 

      Oracle Net

  • 26. 
    A schema is a collection of__________
  • 27. 
    ___________ are customized presentations of data in one or more tables
    • A. 

      Synonym

    • B. 

      Table

    • C. 

      Stored Procedure

    • D. 

      View

  • 28. 
     The data of logical database structures, such as tables and indexes, is physically stored in the ___________
    • A. 

      Table spaces

    • B. 

      Data files

    • C. 

      Data tables

    • D. 

      Data space

  • 29. 
     _______enable a single database to run across multiple clustered nodes in a grid
    • A. 

      Grid Control feature

    • B. 

      Automatic Storage Management

    • C. 

      Oracle Real Application Clusters 10g (RAC)

  • 30. 
     One data block corresponds to a specific number of bytes of physical database space on disk.
    • A. 

      True

    • B. 

      False

  • 31. 
    Identify codd rules
    • A. 

      Integrity dependence

    • B. 

      Guaranteed Access Rule

    • C. 

      Comprehensive Data Sublanguage Rule

    • D. 

      Systematic Manipulation of Null Values

    • E. 

      Distribution Independence

  • 32. 
     Indexes can not be created on one or more columns of a table
    • A. 

      True

    • B. 

      False

  • 33. 
    _________can be created to increase the performance of data retrieval.
    • A. 

      Table

    • B. 

      Index

    • C. 

      View

    • D. 

      Stored Procedure

  • 34. 
     The physical storage of data can be managed without affecting the access the physical storage of data can be managed without affecting the access
    • A. 

      True

    • B. 

      False

  • 35. 
     A ___________ is a container of logical relationships between columns, and it does not have any data
    • A. 

      Materialized view

    • B. 

      Normal view

    • C. 

      Data block

    • D. 

      Dimension

  • 36. 
    A control file contains entries that specify the physical structure of the database ex:
    • A. 

      Table Name

    • B. 

      Database name

    • C. 

      Names and locations of datafiles and redo log files

    • D. 

      Use of Control Files

    • E. 

      Time stamp of database creation

  • 37. 
     a view is not allocated any storage space but contains data
    • A. 

      True

    • B. 

      False

  • 38. 
     ____________are schema objects that can be used to summarize, compute, replicate, and distribute data.
    • A. 

      Views

    • B. 

      Materialized views

    • C. 

      Synonym

    • D. 

      Redo log

  • 39. 
    Oracle Database automatically creates a schema when you create a user.
    • A. 

      True

    • B. 

      False

  • 40. 
    Recording all changes made to data is the function of ____________
    • A. 

      Control file

    • B. 

      Data file

    • C. 

      redo log

    • D. 

      Views

  • 41. 
    The columns in a dimension can come either from the same table (denormalized) or from multiple tables (fully or partially normalized).
    • A. 

      True

    • B. 

      False

  • 42. 
    ___________as replicas provide local access to data that otherwise have to be accessed from remote sites.
    • A. 

      Views

    • B. 

      Materialized views

    • C. 

      Synonym

    • D. 

      Redo log

  • 43. 
    View can be thought of as a.
    • A. 

      Stored query

    • B. 

      Logical space

    • C. 

      Virtual table

    • D. 

      Virtual query

  • 44. 
     Synonyms are often used for
    • A. 

      Mask the name and owner of an object

    • B. 

      Alias for tables

    • C. 

      Simplify SQL statements for database users

    • D. 

      Provide location transparency for remote objects of a distributed database

  • 45. 
    Sequence numbers are Oracle integers of up to _________defined in the database
    • A. 

      42 digits

    • B. 

      36 digits

    • C. 

      38 digits

    • D. 

      48 digits