DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q371
the number of attribute of a relation schema is known as
  • A degree of a relation.
  • B cardinality of a relation.
  • C both A & B
  • D none
Answer: Option A
Q372
an entity set may not have sufficient attributes to form the primary key.
  • A strong entity set
  • B small entity set
  • C weak entity set
  • D none.
Answer: Option C
Q373
which of the following are the advantages of E-R model
  • A conceptual simplicity
  • B visual representation
  • C integrity
  • D both a & b
Answer: Option D
Q374
The following term applies to a collection of related records in a database
  • A File
  • B Layout
  • C File
  • D Field
Answer: Option A
Q375
This set of related data items is known as a
  • A File
  • B Record
  • C Table
  • D None of the above
Answer: Option B
Q376
The framework for storing records in database is a
  • A Form
  • B Report
  • C Query
  • D Table
Answer: Option C
Q377
The following command is used to search the record that safisfies the secified criteria
  • A Found
  • B Search
  • C Get
  • D Locate
Answer: Option A
Q378
The data in a record is of the following types
  • A Four text fields and three numeric fields
  • B two integer fields and five text fields
  • C Three text fields and four numeric fields
  • D none of the above
Answer: Option B
Q379
A treelike structure of records in a database. Select the best fit for answer
  • A Hierarchical database structure
  • B Relational atabase structure
  • C Multidimensional database structure
  • D Sequential database access
Answer: Option A
Q380
The followingg language used by most of the DBMSs for helping their users to access data
  • A High level language
  • B Query language
  • C SQL
  • D 4GL
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