Q7. (10 Points) a. All candidate keys are super key. True/False b. Establishing Foreign key helps in retrieving data fas
Posted: Fri May 20, 2022 5:02 pm
Q7. (10 Points)
a. All candidate keys are super key.
True/False
b. Establishing Foreign key helps in retrieving data
faster. True/False
c. You can use shared locks to avoid deadlock issue.
True/False
d. Using % in the where clause speed ups the query.
True/False
e. Order by is always associated with aggregation.
True/False
f. Tuples are fields whereas records are columns.
True/False
g. You can use the same field in multiple indexes unless
it is a PK. True/False
a. All candidate keys are super key.
True/False
b. Establishing Foreign key helps in retrieving data
faster. True/False
c. You can use shared locks to avoid deadlock issue.
True/False
d. Using % in the where clause speed ups the query.
True/False
e. Order by is always associated with aggregation.
True/False
f. Tuples are fields whereas records are columns.
True/False
g. You can use the same field in multiple indexes unless
it is a PK. True/False