DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q341
Which of the following is/are true about a relation? (a) Each relation in a database should have a unique name. (b) Intersection of each row and column is single valued. (c) Primary key of a relation should be the first column. (d) Each attribute within a relation has a unique name. (e) The sequence of rows in a relation should be in ascending order
  • A a,b and c
  • B c, d and e
  • C a,b and d
  • D d,e and b
Answer: Option C
Q342
Which of the following is/are true for the relational data structure? (a) Cardinality of a relation is the number of columns in a relation. (b) Every attribute of a relation must be defined on exactly one underlying domain. (c) A foreign key cannot contain null values. (d) Degree of a relation is the number of columns in a relation. (e) An alternate key is a candidate key that is not the primary key.
  • A a,b and c
  • B c, d and e
  • C a,b and d
  • D b,d and e
Answer: Option C
Q343
. On an entity-relationship diagram, a relationship is documented with
  • A ellipse.
  • B square.
  • C diamond
  • D pyramid.
Answer: Option C
Q344
The most important stages in arriving at a physical database design are
  • A Business modeling and physical database design
  • B Requirement gathering and logical database design
  • C E-R diagrams and SQL scripts
  • D Logical database design and physical database design
Answer: Option D
Q345
__________is a thing that exists and is distinguishable.
  • A entity
  • B domain
  • C entity set
  • D all the above
Answer: Option A
Q346
The term used to identify a row of a table in the relational data model is
  • A Cardinality
  • B Data
  • C Data Set
  • D Tuple
Answer: Option D
Q347
__________ data base design allows us to generate a set of schemas that allows us to store information with minimum redundancy of data
  • A relational
  • B hierarchical
  • C network
  • D none
Answer: Option A
Q348
which of the following is record based logical model
  • A network model
  • B object oriented model
  • C relational model
  • D both a & c
Answer: Option D
Q349
which of the following model supports multiple parent child relationships
  • A network model
  • B hierarchical model
  • C relationl model
  • D none
Answer: Option B
Q350
in relational model column values are
  • A atomic
  • B related
  • C unique
  • D equal
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