Sail E0 Webinar

MCQs

Total Questions : 32 | Page 3 of 4 pages
Question 21. A schema describes
  1.    Record relationship
  2.    Data elements
  3.    Record and files
  4.    All of the above
 Discuss Question
Answer: Option D. -> All of the above
Question 22. Which of the following is not a type of data?
  1.    Raw Data
  2.    Discrete Data
  3.    Meta Data
  4.    All of above
 Discuss Question
Answer: Option B. -> Discrete Data
Question 23. A logical schema
  1.    is the entire database
  2.    is a standard way of organizing information into accessible parts
  3.    Describes how data is actually stored
  4.    None of these
 Discuss Question
Answer: Option A. -> is the entire database
Question 24. What is data integrity
  1.    It is the data contained in database that is not redundant
  2.    It is the data contained in database that is accurate and consistant
  3.    It is the data contained in database that is secured
  4.    It is the data contained in database that is shared
 Discuss Question
Answer: Option B. -> It is the data contained in database that is accurate and consistant
Question 25. A table is a collection of relationships, there is a close correspondence between concept of
  1.    Tables and instances
  2.    Table and variables
  3.    Tables and relations
  4.    Tables and Entries
 Discuss Question
Answer: Option C. -> Tables and relations
Question 26. In relational model, the row of table is known to be ?
  1.    Relation
  2.    Entity field
  3.    Tuple
  4.    Attribute
 Discuss Question
Answer: Option C. -> Tuple
Question 27. 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?
  1.    DML(Data Manipulation Language)
  2.    DDL(Data Definition Language)
  3.    Query
  4.    Relational Schema
 Discuss Question
Answer: Option A. -> DML(Data Manipulation Language)
Question 28. 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
  1.    Primary
  2.    Referencing
  3.    Specific
  4.    Referential
 Discuss Question
Answer: Option D. -> Referential
Question 29. In Hierarchical model records are organised as
  1.    Graph
  2.    Stack
  3.    Queue
  4.    Tree
 Discuss Question
Answer: Option D. -> Tree
Question 30.
  1.    Relations
  2.    Attribute
  3.    Weak entity
  4.    Key
 Discuss Question
Answer: Option D. -> Key

Latest Videos

Latest Test Papers