Database Management Systems Mcqs

Page No. 77

Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary)
Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.


aAttributes of common


bTuple of common


cTuple of distinct


dAttributes of distinct


View Answer Tuple of distinct

Course(course_id,sec_id,semester)
Here the course_id,sec_id and semester are __________ and course is a _________


aRelations, Attribute


bAttributes, Relation


cTuple, Relation


dTuple, Attributes



Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.


aInstance, Schema


bRelation, Schema


cRelation, Domain


dSchema, Instance


View Answer Schema, Instance

For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.


aDomain


bRelation


cSet


dSchema


View Answer Domain

The term attribute refers to a ___________ of a table.


aRecord


bColumn


cTuple


dKey


View Answer Column

The term _______ is used to refer to a row.


aAttribute


bTuple


cField


dInstance


View Answer Tuple

A ________ in a table represents a relationship among a set of values.


aColumn


bKey


cRow


dEntry


View Answer Row

A relational database consists of a collection of


aTables


bFields


cRecords


dKeys


View Answer Tables

Consider the join of a relation R with relation S. If R has m tuples and S has n tuples, then the maximum size of join is ?


aMN


bM+N


c(M+N)/2


d2(M+N)


View Answer MN

An instance of relational schema R (A, B, C) has distinct values of A including NULL values. Which one of the following is true?


aA is a candidate key


bA is not a candidate key


cA is a primary Key


dBoth (A) and (C)



Goto Page No.

Page 77 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