DBMS-Relational Algebra and Calculus Questions and Answers

Practice Mode
Showing 10 of 81 questions
Q31
A table can have only one:
  • A primary key
  • B alternate key
  • C candidate key
  • D all of these
Answer: Option A
Q32
What are all candidate keys, other than the primary keys called?
  • A secondary keys
  • B alternate keys
  • C eligible keys
  • D none of these
Answer: Option D
Q33
What is the name of the attribute or attribute combination  of one relation whose values are required to match those of the primary key of some other relation?
  • A candidate key
  • B primary key
  • C foreign key
  • D matching key
Answer: Option C
Q34
what is the name of the attribute or attribute combination of one relation whose values are required to match those of the primary key of some other relation?
  • A candidate key
  • B primary key
  • C foreign key
  • D matching key.
Answer: Option C
Q35
What is the RDBMS terminology for a column?
  • A tuple
  • B relation
  • C attribute
  • D domain.
Answer: Option C
Q36
What is the RDBMS terminology for a table?
  • A tuple
  • B relation
  • C attribute
  • D domain
Answer: Option B
Q37
What is the RDBMS terminology for a set of legal values that an attribute can have
  • A tuple
  • B relation
  • C attribute
  • D domain
Answer: Option D
Q38
What is the RDBMS terminology for a set of legal values that an attribute can have ?
  • A degree
  • B relation
  • C attribute
  • D cardinality
Answer: Option D
Q39
What is a set of possible data values called ?
  • A degree
  • B attribute
  • C domain
  • D tuple
Answer: Option C
Q40
What is the RDBMS terminology for the number of attributes in a relation?
  • A degree
  • B relation
  • C attribute
  • D cardinality
Answer: Option A

📚 More from Database

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