Gate Exam

Given the b asic ER and relational models, which of the following is INCORRECT?
(A) An attribute of an entity can have more than one value
(B) An attribute of an entity can be composite
(C) In a row of a relational table, an attribute can have more than one value
(D) In a row of a relational table, an attribute can have exactly one value or a NULL value

Read Solution (Total 0)

Gate Other Question

The protocol data uni t (PDU) for the application layer in the Internet stack is

option
(A) Segment
(B) Datagram
(C) Message
(D) Frame Which of the following statements are TRUE about an SQL query?
P : An SQL query can contain a HAVING clause even if it does not have a GROUP BY clause
Q : An SQL query can contain a HAVING clause only if it has a GROUP BY clause
R : All attributes used in the GROUP BY clause must appear in the SELECT clause
S : Not all attributes used in the GROUP BY clause need to appear in the SELECT clause

option
(A) P and R
(B) P and S
(C) Q and R
(D) Q and S