Hi guys, I have an exam in Database, which I don’t know a thing because I’ve never learned it.
Below I’m giving you the exam questions, if anyone can help that would be great. You just need to tell me the right alternative for each question.
-
Which of the below is part of the main heuristic rules
a) execute SELECT and JOIN before the implementation of binary actions
b) execute SELECT and UNION before the executing of binary actions
c) execute SELECT and PROJECT before the executing of binary actions
d) alternative a and b
e) none of the above -
DBA privileged commands also include:
a) determining the end user requests
b) specification development for registered transactions
c) deletion of some privileges which were given before to some accounts
d) all of the above
e) alternative a and c
f) none of the above -
which of the below can/may be the right index:
a) secondary index
b) cluster index
c) primary index
d) all of the above
e) alternative b and c
f) none of the above