Category

Database Management Systems Mcqs


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

Alphabetical MCQs Categories

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




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 © 2022, Designed & Developed by BolPakistan