Awesome q2a theme
0 votes

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

in Databases by (577 points) | 17 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
but here primary key is not given, how can we assume that it is there?
In that case, collection of all attributes considered as primary key
Top Users Oct 2019

    410 Points

  2. Satbir

    317 Points

  3. Rudr Pawan

    163 Points

  4. srestha

    136 Points

  5. Mk Utkarsh

    127 Points

  6. Debapaul

    94 Points

  7. chandrikabhuyan8

    83 Points

  8. Shaik Masthan

    79 Points

  9. Verma Ashish

    77 Points

  10. !KARAN

    74 Points

1,680 questions
1,089 answers
89,591 users