Quiz  /  Rdbms Gate & PSU MCQ Questions With Answers

  • 1. 
    Which of the following is a fundamental operation in relational algebra?

  • Set intersection
  • Natural join
  • Assignment
  • None of above

  • 2. 
    In the architecture of a database system, external level is the

  • Physical level
  • Conceptual level
  • Logical level
  • View level

  • 3. 
    The level of data abstraction which describes how the data is actually stored is

  • Conceptual level
  • Physical level
  • File level
  • None of these

  • 4. 
    For the following two entities which one is the correct option CUTOMER/ORDER

  • one to one
  • one to many
  • many to one

  • 5. 
    Architecture of the database can be viewed as

  • Two levels
  • Four levels
  • Three levels
  • One level

  • 6. 
    For the following two entities which is appropriate relationship Zoo/Animal

  • one to one
  • one to many
  • many to one

  • 7. 
    A logical schema

  • is the entire database
  • is a standard way of organizing information into accessible parts
  • Describes how data is actually stored
  • None of these

  • 8. 
    Sets of related data.

  • Tables
  • Forms
  • Queries
  • Reports

  • 9. 
    Manager salary details are hidden from the employee, this is

  • Conceptual level data hiding
  • Physical Level data hiding
  • External level data hiding
  • none of these

  • 10. 
    The view of the total database content is

  • Conceptual view
  • Internal view
  • External view
  • Physical view

  • 11. 
    DML is provided for

  • Description of the logical structure of the data base
  • The addition of new structure in the database system
  • Manipulation and processing of the database
  • Definition of the physical structure of the database

  • 12. 
    .......... is the process of organizing the data in the database.

  • Schema
  • Normalization
  • Instance
  • Transaction

  • 13. 
    In an ER diagram, Entity types are represented by

  • rectangle
  • ellipse
  • diamond box
  • circle

  • 14. 
    A .............. is a very small unit of a program and it may contain several low-level tasks.

  • Attribute
  • Table
  • Normalization
  • Transaction

  • 15. 
    A schema describes

  • Record relationship
  • Data elements
  • Record and files
  • All of the above

  • 16. 
    Which of the following function cannot be performed by SQL ?

  • Setting permissions on tables
  • Creating views in a database
  • Updating records
  • Creating Complex UI
  • Delete database

  • 17. 
    Raw data is significant to a business.

  • True
  • False

  • 18. 
    ............ are the properties of entities.

  • Domain
  • Attributes
  • Relations
  • Field

  • 19. 
    Collection of information stored at a particular moment is

  • View
  • Schema
  • Instance
  • None of the above
Report Question
warning
access_time
  Time