DBMS-Relational Algebra and Calculus Questions and Answers

Practice Mode
Showing 10 of 81 questions
Q41
Which of the following aspects of data is the concern of a relational database model ?
  • A data manipulation
  • B data integrity
  • C data structure
  • D all of these
Answer: Option D
Q42
What is the smallest unit of data in the relational model ?
  • A data type
  • B field
  • C data value
  • D none of these
Answer: Option B
Q43
Dr. Edgar F. Codd proposed a set of rules that were intended to define the important characterstic and capabilities of any relational system.
  • A TRUE
  • B FALSE
Answer: Option A
Q44
Codd's Logical Dta independence rule states that user operations and application programs should be independent of any changes in the logical structure of base tables provided they involve no loss information
  • A TRUE
  • B FALSE
Answer: Option A
Q45
The entire field of RDBMS has its origin in Dr. E.F. Codd's paper.
  • A TRUE
  • B FALSE
Answer: Option A
Q46
ISBL has no aggregate operators for example, agverage, mean and so on.
  • A TRUE
  • B FALSE
Answer: Option A
Q47
ISBL has no facilities for insertion, deletion or modification of tuples.
  • A TRUE
  • B FALSE
Answer: Option A
Q48
QUEL is a tuple relational calculus language of a relational database system INGRESS (Interactive Graphics and Retrieval system).
  • A TRUE
  • B FALSE
Answer: Option A
Q49
QUEL supports relational algebraic operations such as intersection, minus or union.
  • A TRUE
  • B FALSE
Answer: Option A
Q50
The first commercial REBMS was IBM'S DB2
  • A TRUE
  • B FALSE
Answer: Option B

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test