Using the ______ clause retains only one copy of such identical tuples.

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

A

P and R

B

P and S

C

Q and R

D

Q and S

Using the _______ clause retains only one copy of identical tuples

A

distinct

B

is not null

C

no repeat

D

from

Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?

A

DML(Data Manipulation Langauge)

B

DDL(Data Definition Langauge)

C

Query

D

Relational Schema

Consider two database relations R and S having 3 tuples in R and 2 tuples in S. what is the maximum number of tuples that could appear in the natural join of R and S?

A

2

B

5

C

3

D

6

Group the given figures into three classes using each figure only once.
Grouping of Identical Figures mcq question image

A

1,3,9; 2,5,6; 4,7,8

B

1,3,9; 2,7,8; 4,5,6

C

1,2,4; 3,5,7; 6,8,9

D

1,3,6; 2,4,8; 5,7,9

Group the given figures into three classes using each figure only once.
Grouping of Identical Figures mcq question image

A

1,2,6; 3,4,7; 5

B

1,3; 2,6; 4,5,7

C

1,2,6,7; 3; 4,5

D

1,3; 2,4,5; 6,7

Group the given figures into three classes using each figure only once.
Grouping of Identical Figures mcq question image

A

2,4,7; 1,8,9; 3,5,6

B

2,6,9; 1,5,7; 3,4,8

C

2,6,7; 1,5,8; 3,4,9

D

2,8,7; 1,5,9; 3,4,6

Group the given figures into three classes using each figure only once.
Grouping of Identical Figures mcq question image

A

1,2,4; 3,5,6; 7,8,9

B

1,7,8; 3,5,6; 2,4,9

C

1,3,4; 2,8,9; 5,6,7

D

1,7,8; 2,3,6; 4,5,9

Group the given figures into three classes using each figure only once.
Grouping of Identical Figures mcq question image

A

2,4,7; 1,6,9; 3,5,8

B

1,3,5; 2,6,7; 4,8,9

C

1,5,7; 2,3,6; 4,8,9

D

1,3,5; 2,4,7; 6,8,9

Group the given figures into three classes using each figure only once.
Grouping of Identical Figures mcq question image

A

1,3,9; 2,5,8; 4,6,7

B

1,5,8; 4,6,7; 2,3,9

C

2,5,9; 1,3,8; 2,6,7

D

1,8,9; 4,6,7; 2,3,5

Using the ______ clause retains only one copy of such identical tuples.

Related Questions