Database Management Systems Mcqs

Page No. 1

The _________ provides a set of operations that take one or more relations as input and return a relation as an output.


aSchematic representation

✖


bRelational algebra

✓


cScheme diagram

✖


dRelation flow

✖


View Answer Relational algebra

A ________ is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.


aSchema diagram

✓


bRelational algebra

✖


cDatabase diagram

✖


dSchema flow

✖


View Answer Schema diagram

The _______ operator takes the results of two queries and returns only rows that appear in both result sets.


aUnion

✖


bIntersect

✓


cDifference

✖


dProjection

✖


View Answer Intersect

The most commonly used operation in relational algebra for projecting a set of tuple from a relation is


aJoin

✖


bProjection

✖


cSelect

✓


dUnion

✖


View Answer Select

The _______operation performs a set union of two “similarly structured” tables


aUnion

✓


bJoin

✖


cProduct

✖


dIntersect

✖


View Answer Union

The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.


aJoin

✖


bCartesian product

✓


cIntersection

✖


dSet difference

✖


View Answer Cartesian product

The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.


aSelect

✖


bJoin

✓


cUnion

✖


dIntersection

✖


View Answer Join

Which one of the following is a procedural language?


aDomain relational calculus

✖


bTuple relational calculus

✖


cRelational algebra

✓


dQuery language

✖


View Answer Relational algebra

Student(ID, name, dept name, tot_cred)
In this query which attributes form the primary key?


a Name

✖


bDept

✖


cTot_cred

✖


dID

✓


View Answer ID

Using which language can a user request information from a database?


aQuery

✓


bRelational

✖


cStructural

✖


dCompiler

✖


View Answer Query

Goto Page No.

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