Database Management System (DBMS) MCQs with answers Page - 40

Here, you will find a collection of MCQ questions on Database Management System (DBMS). Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 833.24K Points
Coach

Q. Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in

  • (A) Fourth NF
  • (B) BCNF
  • (C) Third NF
  • (D) Second NF

A

Admin • 833.24K Points
Coach

Q. Thus a _______ of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.

  • (A) Instance
  • (B) Snapshot
  • (C) Both Instance and Snapshot
  • (D) All of the mentioned

A

Admin • 833.24K Points
Coach

Q. Representations such as the in the dept year relation, with one column for each value of an attribute, are called _______ they are widely used in spreadsheets and reports and in data analysis tools.

  • (A) Cross-tabs
  • (B) Snapshot
  • (C) Both Cross-tabs and Snapshot
  • (D) All of the mentioned

A

Admin • 833.24K Points
Coach

Q. Data Model is collection of conceptual tools for describing -

  • (A) Data
  • (B) All of these
  • (C) Data Schema
  • (D) Consistency Constaints

A

Admin • 833.24K Points
Coach

Q. Data Models in DBMS are classified into ______ categories.

  • (A) 3
  • (B) 2
  • (C) 5
  • (D) 4

A

Admin • 833.24K Points
Coach

Q. Object based logical model(s) are used to describe data at - [Select Appropriate Option(s)]

  • (A) View Level
  • (B) Logical Level
  • (C) Physical Level
  • (D) None of these

A

Admin • 833.24K Points
Coach

Q. Which of the following is example of Object based logical model ?

  • (A) Relational Model
  • (B) Hierarchical Model
  • (C) Network Model
  • (D) Entity Relationship Model

A

Admin • 833.24K Points
Coach

Q. Entity Relationship model consists of collection of basic objects called _________ and relationship among these objects.

  • (A) functions
  • (B) models
  • (C) None of these
  • (D) entities

A

Admin • 833.24K Points
Coach

Q. Which of the following gives a logical structure of the database graphically?

  • (A) Entity-relationship diagram
  • (B) Entity diagram
  • (C) Database diagram
  • (D) Architectural representation

A

Admin • 833.24K Points
Coach

Q. Consider a directed line(->) from the relationship set advisor to both entity sets instructor and student. This indicates _________ cardinality

  • (A) One to many
  • (B) One to one
  • (C) Many to many
  • (D) Many to one

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.