How does the ODMG aggregate functions differ from the SQL aggregate functions? Give an example to illustrate your answer.
What will be an ideal response?
The OQL aggregate functions can be applied within the select clause or to the result of the
select operation. For example, the following two expressions are equivalent in OQL:
SELECT COUNT(s) FROM s IN salesStaff WHERE s.WorksAt.branchNo = ‘B003’;
COUNT(SELECT s FROM s IN salesStaff WHERE s.WorksAt.branchNo = ‘B003’);
Note, OQL allows aggregate functions to be applied to any collection of the appropriate type
and , unlike, SQL, can be used in any part of the query.
You might also like to view...
When an ActiveX Command Button control is clicked in Slide Show view, the macro associated with the control is executed
Indicate whether the statement is true or false
Which of the following is a primary function of a bridge within an Ethernet network?
A) Bridges create multiple collision domains. B) Bridges increase the capacity of the entire Ethernet. C) Bridges join multiple collision domains into a single collision domain. D) Bridges act like hubs for larger distances.
Hot spots offer mobile users the ability to connect to the Internet with their Wi-Fi enabled wireless computers and devices.
Answer the following statement true (T) or false (F)
You need to block all unsecured web traffic using its default port from a specific network segment of the enterprise network. Which port would you block to achieve this?
81 8080 45 88 80