Awesome q2a theme
0 votes
43 views

Can someone explain, how option A can be the correct answer?

in Databases by (778 points) | 43 views

1 Answer

+1 vote
Best answer
A can be the answer because * gives the whole tuple as a result, and whole tuple can not be repeated in SQL because of constraint that the primary key must be different. So SELECT * will give distinct rows.
by (45 points)
selected by
0
but here primary key is not given, how can we assume that it is there?
0
In that case, collection of all attributes considered as primary key
Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
Welcome to GATE CSE Doubts, where you can ask questions and receive answers from other members of the community.
Top Users May 2020
  1. Kushagra गुप्ता

    97 Points

  2. praveen modala

    15 Points

  3. ramcharantej_24

    15 Points

  4. abhishek tiwary

    12 Points

  5. srestha

    12 Points

  6. Dtiwari

    9 Points

  7. Shivateja MST

    8 Points

  8. ankitgupta.1729

    8 Points

  9. Rashimdixit

    7 Points

  10. Bhavya1902

    7 Points

7,376 questions
1,741 answers
10,682 comments
90,352 users