Quiz  /  Rdbms Class 12 MCQ Questions With Answers

  • 1. 
    What will be the outputI:SELECT INSTR('KVMANKHURD','MAN');

  • 2
  • 3
  • 5
  • NONE

  • 2. 
    The language used in application programs to request data from the DBMS is referred to as the

  • DDL
  • DML
  • TCL
  • DCL

  • 3. 
    A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.

  • Rows
  • Key
  • Attribute
  • Fields

  • 4. 
    In a relational Database a referential integrity constraint cab be specified with the help of

  • Primary Key
  • Secondary key
  • Foreign key
  • None of these

  • 5. 
    What will be the degree and cardinality of the cartesian product of two tables if the degree of first table is 3 and second table is 5. The cardinality of first table is 10 and cardinality of second table is 6.

  • Degree 15, Cardinality 16
  • Degree 8 Cardinality 16
  • Degree 8 Cardinality 60
  • Degree 15 cardinality 60

  • 6. 
    In the relational model, cardinality is termed as

  • A number of tuples.
  • A number of attributes.
  • A number of tables.
  • number of constraints.

  • 7. 
    In relational model, the row of table is known to be ?

  • Relation
  • Entity field
  • Tuple
  • Attribute

  • 8. 
    Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?

  • Candidate key
  • Sub key
  • Super key
  • Foreign key

  • 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)
Report Question
warning
access_time
  Time