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

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. Select distinct Dept_name from instructor ; How many row(s) are displayed ?

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

A

Admin • 833.24K Points
Coach

Q. Which function is used to find the count of distinct departments?

  • (A) dist
  • (B) distinct
  • (C) count
  • (D) count,dist

A

Admin • 833.24K Points
Coach

Q. can help us detect poor E- R design.

  • (A) database design process
  • (B) e-r design process
  • (C) relational scheme
  • (D) functional dependencies

A

Admin • 833.24K Points
Coach

Q. What is the best way to represent the attributes in a large database?

  • (A) relational-and
  • (B) concatenation
  • (C) dot representation
  • (D) all of the mentioned

A

Admin • 833.24K Points
Coach

Q. Designers use which of the following to tune the performance of systems to support time-critical operations?

  • (A) denormalization
  • (B) redundant optimization
  • (C) optimization
  • (D) realization

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. An approach to website design with the emphasis on converting visitors to outcomes required by the owner is referred to as:

  • (A) web usability
  • (B) persuasion
  • (C) web accessibility
  • (D) none of the mentioned

A

Admin • 833.24K Points
Coach

Q. A method of modelling and describing user tasks for an interactive application is referred to as:

  • (A) customer journey
  • (B) primary persona
  • (C) use case
  • (D) web design persona

A

Admin • 833.24K Points
Coach

Q. Information architecture influences:

  • (A) answer choice
  • (B) site structure
  • (C) labeling
  • (D) navigation design

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.