The where clause is a predicate involving attributes of the relation in the ______ clause.

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

Which of the following statements are correct with regard to the 'truth and validity' in logical reasoning. Select the correct code from the below: (a) Truth and falsity are attributes of individual propositions. (b) Validity and invalidity are attributes of individual propositions. (c) Truth and falsity are attributes of arguments. (d) Validity and invalidity are attributes of arguments. Code:

A

(a) and (b)

B

(b) and (d)

C

(a) and (c)

D

(a) and (d)

The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.

A

Where, from

B

From, select

C

Select, from

D

From, where

Consider the following statements with reference to the proposition "Some girls are not students". (a) Subject term students is distributed (b) Predicate term girls is undistributed (c) Predicate term students is distributed (d) Subject term girls is undistributed Choose the correct option from those given below :

A

Only (a) and (c) are correct

B

Only (b) and (c) are correct

C

Only (a) and (d) are correct

D

Only (c) and (d) are correct

Which of the following options has correctly shown the topdown parsing for the sentence "Rachel ate a peach"? (Consider NP, VP, N, V, ART means noun predicate, verb predicate, noun, verb and article respectively)

A

S → NPVP

→ Name VP

→ Rachel V NP

→ Rachel ate ART N

→ Rachel ate a N

→ Rachel ate a peach

B

S → Name VP

→ Rachel V NP

→ Rachel ate ART N

→ Rachel ate a N

→ Rachel ate a peach

C

S → Name NPVP

→ Rachel V NP

→ Rachel ate ART N

→ Rachel ate a N

→ Rachel ate a peach

D

S → Name NPVP

→ Rachel V NP

→ Rachel ate ART N

→ Rachel ate a N

→ Rachel ate a peach1

Consider the statement “Not all that glitters is gold” Predicate glitters(x) is true if x glitters and predicate gold(x) is true if x is gold. What which one of the following logical formulate represents the above statement?

A

∀x: glitters (x) ⇒ ¬ gold (x)

B

∀x: gold (x) ⇒ glitters (x)

C

∃x: gold (x) ∧ ¬ glitters (x)

D

∃x: glitters (x) ∧ ¬ gold (x)

Which one of the following predicate formulae is NOT logically valid? Note that W is a predicate formula without any free occurrence of x.

A

∀x(p(x) ∨ W) ≡ ∀x p(x) ∨ W

B

Ǝx(p(x) ∧ W) ≡ Ǝx p(x) ∧ W

C

∀x(p(x) → W) ≡ ∀x p(x) → W

D

Ǝx(p(x) → W) ≡ ∀x p(x) → W

The values appearing in given attributes of any tuple in the referencing relation must likewise occur in specified attributes of at least one tuple in the referenced relation, according to _____________________ integrity constraint.

A

Referential

B

Primary

C

Referencing

D

Specific

A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.

A

Referential

B

Referencing

C

Specific

D

Primary

Read the following sentences and choose the correct option. (i) Variables can only take discrete values while Attributes can take continuous values. (ii) Variables can only take continuous values while Attributes take discrete value. (iii) Attributes and variables are dependent on each other. (iv) Width of an impeller blade is a variable but no. of defective blades in a lot is an attribute.

A

(i) and (iii) are correct

B

(i)and (iii) are incorrect

C

Only (i) is correct

D

(i), (ii), (iii) and (iv)

The where clause is a predicate involving attributes of the relation in the ______ clause.

Related Questions