Database Systems - Section 2 Multiple Questions and Answers.




21.Which of the following is the Binary Operations?
A. Set difference, Union, Project
B. Rename, union, Set difference
C. Cartesian product, Set difference and project
D. Cartesian product, union, set difference

22.The select operation selects tuples that satisfy a given predicate. We use the lowercase______ to denote selection?
A. Greek letter rho (ρ)
B. Greek letter Pi (π)
C. Greek letter sigma (σ)
D. Greek letter sigma (ρ)

23.Suppose we want to list all loan numbers and the amount of the loans, but do not care about the branch name. Which of the following operation allows us to produce this relation?
A. Set difference
B. Union
C. Cartesian product
D. Project

24. The Binary operation Union, denoted, as in the set theory by:
A. U
B. p
C. σ
D. π

25.If we want to include attributes from two different relations, which of the following operations is needed?
A. Set difference
B. Union
C. Cartesian product
D. Projection

«»



Date to Date Current Affairs 2022

PakMCQs.net

Quick Links

GAT Subject



   Computer Science    English Mcqs    Agriculture    

Engineering



   Computer Science    Civil Engineering    

Technical



   Networking    Electronics    Database    

Past Papers



   Model Papers    FPSC Papers