DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q51
RDMS is based on
  • A Hierarchical model
  • B relational
  • C Network
  • D none of these
Answer: Option B
Q52
One of the cause of the failure of file system
  • A Data availability
  • B Fixed records
  • C Sequential records
  • D Lack of security
Answer: Option D
Q53
Data concurrency means
  • A Accessing multiple table records
  • B Access by multiple users
  • C Doing sequential multiple deletes
  • D Doing sequential multiple inserts
Answer: Option B
Q54
Main cause of failure of network model
  • A Impossible modification of data design
  • B Failure to explain the many-many relation
  • C Failure to explain the one-many relation
  • D Failure to explain the many-all relation
Answer: Option A
Q55
What among is not implemented by CODD
  • A Existence of data is not in the table
  • B Defining the constraints separately
  • C Both the above
  • D None of these
Answer: Option B
Q56
Normalization main important aim is
  • A to remove the data redundancy between the columns
  • B to have least redundancy dependency on primary key
  • C to more flexible access
  • D All the above
Answer: Option B
Q57
De-Normalization is required when
  • A To make strict data redundancy
  • B To make all column dependency on primary key
  • C To create as many related tables
  • D To more flexible access in order to avoid lengthy joins
Answer: Option D
Q58
Chose the correct sequence regarding select clause
  • A Where-group by-having
  • B Where
  • C Group by
  • D Having - order by
Answer: Option A
Q59
The function greatest/least works on
  • A List of same field values
  • B Set of different datatyped columns
  • C Set of same datatyped columns
  • D None of these
Answer: Option C
Q60
How does you represent a
  • A Solid line
  • B Dashed line
  • C ellipse
  • D none
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