Rdbms MCQ

Below Rdbms quiz are Multiple Choice Questions (MCQs) type Quiz. These Rdbms MCQ Questions helps you to refresh your Rdbms, you can see the correct option by clicking on it. .
  • 1. Which of the following is not a definition of NULL Value?

    • NULL is not the same as zero or a blank space
    • Arithmetic operations on a NULL value does not always return a NULL Value
    • NULL Value is the absence of any character,zero,blank space
  • 2. The Oracle environment of database is called as ___________

    • Database Schema
    • Database Instances
    • Data Structure
    • All of the Mentioned
  • 3. The restrictions or conditions applied on data are known as ______________

    • Constraints
  • 4. The term attribute refers to a ___________ of a table.

    • Record
    • Tuple
    • Column
    • Key
  • 5. The HAVING clause does which of the following?

    • Acts like a WHERE clause but is used for groups rather than columns.
    • Acts like a WHERE clause but is used for rows rather than columns.
    • Acts like a WHERE clause but is used for columns rather than groups.
    • Acts EXACTLY like a WHERE clause.
    • Acts like a WHERE clause but is used for groups rather than rows.
  • 6. Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?

    • DML(Data Manipulation Langauge)
    • DDL(Data Definition Langauge)
    • Query
    • Relational Schema
  • 7. Logical design of database, is known to be

    • Database relation
    • Database instance
    • Database entity
    • Database Schema
  • 8. The set of all possible values that an attribute may contain is called the ___________ of an attribute. 1

    • Domain
    • Relation
    • Set
    • Schema
  • 9. Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation?

    • DML(Data Manipulation Language)
    • Query
    • Relational Schema
    • DDL(Data Definition Language)
  • 10. A set of objects that share a common structure and a common behavior is called:

    • Object
    • Class
    • Entity
    • None of these
  • 11. Address field of a person should not be part of primary key, since it is likely to ?

    • Dependent
    • Too long
    • Changed
    • Not changed
  • 12. A table joined with itself is called

    • Join
    • Self Join
    • Outer Join
    • Equi Join
  • 13. In the relational model, cardinality is termed as

    • A number of tuples.
    • A number of attributes.
    • A number of tables.
    • number of constraints.
  • 14. A table is a collection of relationships, there is a close correspondence between concept of

    • Tables and instances
    • Table and variables
    • Tables and relations
    • Tables and Entries
  • 15. A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.

    • Referential
    • Referencing
    • Specific
    • Primary
  • 16. Which of the following provides the ability to query information from the database and insert tuples into, delete tuples from, and modify tuples in the database?

    • DML(Data Manipulation Language)
    • DDL(Data Definition Language)
    • Query
    • Relational Schema
  • 17. .......... is an attribute or collection of attributes that uniquely identifies an entity among entity set.

    • Relations
    • Attribute
    • Weak entity
    • Key
  • 18. In Hierarchical model records are organised as

    • Graph
    • Stack
    • Queue
    • Tree
  • 19. The union of primary keys of the related entity sets becomes a -------------------------- of the relation ?

    • Super Key
    • Candidate key
    • Foreign key
    • Primary key
  • 20. Which of the following is not a valid operator for the WHERE Clause

    • IN BETWEEN
    • <>
    • >=
    • All of above