Which of the following keywords is used beside the select clause to ex – McqOptions

MCQOPTIONS

1.	Which of the following keywords is used beside the select clause to explicitly specify that duplicates are not removed?
A.	all
B.	not unique
C.	notnull
D.	include
Answer» B. not unique

Discussion

No Comment Found

Related MCQs

While operating with strings, what does “_ _ _%” match with?
Observe the following query and choose the correct option.select name, IDfrom student natural join department natural join section
What does the natural join operation do?
State true or false: Multiple conditions in the where clause are separated by a “,”
If we specify multiple relations in the from clause and do not specify any conditions in the where clause, what will the result be?
The ________ clause is used to list the attributes desired in the result of a query
What does the following query do?select name, ID, branchfrom student, departmentwhere student.branch = department.branch;
select distinct dept_namefrom institute; What does the above query do?
STATE_TRUE_OR_FALSE:_MULTIPLE_CONDITIONS_IN_THE_WHERE_CLAUSE_ARE_SEPARATED_BY_A_‚ÄÖ√Ñ√∂‚ÀÖ√Ë‚ÀÖ‚À´,‚ÄÖ√Ñ√∂‚ÀÖ√Ë‚ÀÖŒÄ?$#
IF_WE_SPECIFY_MULTIPLE_RELATIONS_IN_THE_FROM_CLAUSE_AND_DO_NOT_SPECIFY_ANY_CONDITIONS_IN_THE_WHERE_CLAUSE,_WHAT_WILL_THE_RESULT_BE??$