Answer:
CREATE FUNCTION exam_eligible_students
RETURN NUMBER AS
num_students NUMBER(15);
BEGIN
SELECT COUNT(STUDENT_ID)
INTO num_students
FROM STUDENT_ATTENDANCE
WHERE ELIGIBILITY_FOR_EXAMS = 'Y';
RETURN (num_students);
END;
Explanation:
exam_eligible_students is a made of name for the FUNCTION to be called.
num_students is a made up name for the RETURN to be called. The RETURN name is referenced in the INTO statement and as the name of the the return in the RETURN line in ().
Answer:
8
Explanation:
Gear reduction = driven gear teeth / driving gear teeth
First stage reduction :
Driven gear teeth = 36
Driving gear teeth = 12
36 /12 = 3
Second stage reduction :
Driven gear teeth = 60
Driving gear teeth = 12
60 /12 = 5
First stage + second stage
3 + 5 = 8
Answer:
- Transform binary or unary M:N relationship or associative entity with its own key.
Explanation:
Transform binary relation is described as the method through which a decimal can easily be converted into binary while the unary relationship is described as a relationship in which both the two participants occurs from the same entity.
In the given case, 'transform binary or unary M:N relationship' can be created using 'the primary key linked with the relationship plus any non-key aspects of the relationship and the primary keys of the related entities' as it displays the existence of a relationship between the occurrences of a similar set of the entity i.e. associative entity here.
Answer:
The correct answer to the following question will be option c. Store Code.
Explanation:
A store code will be the unique ID which can uniquely identify any location of that store.
- Any random number or name can be the store code.
- A store code in each Google My Business (GMB) will only be viewable to the person who is managing that locations arround the store.
- Any costumer doesn't have possibility to see it.
Hence, Option C is the right answer.
Answer:
Really depends on your situation. If you specified, I'd have an asnwer
