QUESTION 45 Which of the following syntax is NOT considered a multiple-row compa

Question

QUESTION 45
Which of the following syntax is NOT considered a multiple-row comparison operator?
a. >ALL
b. =SOME
  
c. >ANY

d. <ALL

QUESTION 46
Although rarely used outside a program, a user can explicitly lock a table in SHARE mode by issuing the ______ _______ command.
  
a. LOCK CODE

b. SELECT LOCK
  
c.LOCK TABLE

d. LOCK BOX

QUESTION 47
__________ relationships are rare in a relational database; usually you work with ________ relationships.
  
a. One-to-one, one-to-many
b. One-to-one, many-to-one
c. Many-to-one, many-to-many
d. One-to-many, one-to-one

Explanation / Answer

45)

b. =SOME

For multiple-row operators IN , ANY and ALL, you can use the comparison operators <,>,= and hence, options a,c and are valid.

46)

c.LOCK TABLE

This command is used to explicitly lock a table in SHARE mode.

47)

a. One-to-one, one-to-many

PLEASE UPVOTE IF THE ANSWER WAS HELPFUL

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.