Database Management Systems Mcqs

Page No. 25

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


aCustomer journey


bPrimary persona


cUse case


dWeb design persona


View Answer Use case

An approach to website design with the emphasis on converting visitors to outcomes required by the owner is referred to as:


aWeb usability


bPersuasion


cWeb accessibility


dNone of the mentioned


View Answer Persuasion

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.


aCross-tabs


bSnapshot


cBoth Cross-tabs and Snapshot


dAll of the mentioned


View Answer Cross-tabs

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.


aInstance


bSnapshot


cBoth Instance and Snapshot


dAll of the mentioned


View Answer Snapshot

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


aFourth NF


bBCNF


cThird NF


dSecond NF


View Answer BCNF

In the schema (dept name, size) we have relations total inst 2007, total inst 2008. Which dependency have lead to this relation ?


aDept name, year->size


bYear->size


cDept name->size


dSize->year


View Answer Dept name, year->size

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


aDenormalization


bRedundant optimization


cOptimization


dRealization


View Answer Denormalization

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


aRelational-and


bConcatenation


cDot representation


dAll of the mentioned


View Answer Concatenation

Suppose the user finds the usage of room number and phone number in a relational schema there is confusion. This is reduced by


aUnique-role assumption


bUnique-key assignment


cRole integral assignment


dNone of the mentioned



Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set.


aA many-to-many relationship set


bA multivalued attribute of an entity set


cA one-to-many relationship set


dAll of the mentioned



Goto Page No.

Page 25 of 101

Alphabetical MCQs Categories

Here below You find all kind of categories of MCQs in alphabetical order.


"Comprehensive Collection of MCQs: Alphabetically Organized by Subject"

"Discover an extensive collection of multiple-choice questions (MCQs) neatly categorized by subject from A to Z. This resource is designed for anyone eager to explore various topics in a straightforward and organized manner. Whether you're a student preparing for exams, an educator seeking supplementary materials, or simply curious about different subjects, this compilation offers a convenient way to learn and assess your knowledge. With questions arranged alphabetically, navigation is effortless, allowing you to delve into subjects of interest at your own pace. Engage, learn, and expand your understanding with this accessible and comprehensive repository of MCQs!"


BolPakistan

bolpakistan.com.pk includes Job Mcqs and Pak Mcqs is the Top Largest Mcqs Forum in World, in which you can read Mcqs of All Subjects, PPSC test preparation, FPSC, NTS and PPSC PAST PAPERS, PPSC PAST MCQS. A Collection of Repeated MCQs for JOBs seekers.

Copyright © 2024, Designed & Developed by BolPakistan