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