Examlex

Solved

CUSTOMER RENTALS In the Table RENTALS, Rtn Provides the Rental Number (The

question 50

Multiple Choice

CUSTOMER
 Cname  Age  Resid_City  BirthPlace  BLACK 40 ERIE  TAMPA  GREEN 25 CARY  ERIE  JONES 30 HEMET  TAMPA  MARTIN 35 HEMET  TAMPA  SIMON 22 ERIE  ERIE  VERNON 60 CARY  CARY \begin{array} { | l | l | l | l | } \hline \text { Cname } & \text { Age } & \text { Resid\_City } & \text { BirthPlace } \\\hline \text { BLACK } & 40 & \text { ERIE } & \text { TAMPA } \\\hline \text { GREEN } & 25 & \text { CARY } & \text { ERIE } \\\hline \text { JONES } & 30 & \text { HEMET } & \text { TAMPA } \\\hline \text { MARTIN } & 35 & \text { HEMET } & \text { TAMPA } \\\hline \text { SIMON } & 22 & \text { ERIE } & \text { ERIE } \\\hline \text { VERNON } & 60 & \text { CARY } & \text { CARY } \\\hline\end{array}
RENTALS
 Cname  Make  Date_Out  Pickup  Return  Rtn  BLACK  FORD 10 Oct-1994  CARY  CARY 1 BLACK  GM 01 Nov-1995  TAMPA  CARY 2 BLACK  FORD 01Jan1995 ERIE  ERIE 3 GREEN  NISSAN 07Jul1994 TAMPA  TAMPA 4 JONES  FORD 01Jul1995 CARY  ERIE 5 JONES  GM 01Aug1995 ERIE  ERIE 6 MARTIN  FORD 01Aug1994 CARY  ERIE 7 SIMON  GM 01Sep1995 ERIE  CARY 8 WARP  TOYOTA 02Sep1995 RENO  RENO 9\begin{array}{|l|l|l|l|l|l|}\hline \text { Cname } & \text { Make } & \text { Date\_Out } & \text { Pickup } & \text { Return } & \text { Rtn } \\\hline \text { BLACK } & \text { FORD } & 10-\text { Oct-1994 } & \text { CARY } & \text { CARY } & 1 \\\hline \text { BLACK } & \text { GM } & 01-\text { Nov-1995 } & \text { TAMPA } & \text { CARY } & 2 \\\hline \text { BLACK } & \text { FORD } & 01-J a n-1995 & \text { ERIE } & \text { ERIE } & 3 \\\hline \text { GREEN } & \text { NISSAN } & 07-J u l-1994 & \text { TAMPA } & \text { TAMPA } & 4 \\\hline \text { JONES } & \text { FORD } & 01-J u l-1995 & \text { CARY } & \text { ERIE } & 5 \\\hline \text { JONES } & \text { GM } & 01-A u g-1995 & \text { ERIE } & \text { ERIE } & 6 \\\hline \text { MARTIN } & \text { FORD } & 01-A u g-1994 & \text { CARY } & \text { ERIE } & 7 \\\hline \text { SIMON } & \text { GM } & 01-S e p-1995 & \text { ERIE } & \text { CARY } & 8 \\\hline \text { WARP } & \text { TOYOTA } & 02-S e p-1995 & \text { RENO } & \text { RENO } & 9 \\\hline\end{array}
In the table RENTALS, Rtn provides the rental number (the primary key., Cname refers to the Cname in Customer, Pickup is the city where the car was picked up, and Return is the city where the car was returned.

RENTCOST
 MAKE  COST  FORD 30 GM 40 NISSAN 30 TOYOTA 20 VOLVO 50\begin{array} { | l | l | } \hline \text { MAKE } & \text { COST } \\\hline \text { FORD } & 30 \\\hline \text { GM } & 40 \\\hline \text { NISSAN } & 30 \\\hline \text { TOYOTA } & 20 \\\hline \text { VOLVO } & 50 \\\hline\end{array}
In RENTCOST, COST shows the base cost of renting a given MAKE for one day.

CITYADJ
 CITY  FACTOR  CARY 1 ERIE 1.1 RENO 0.9 TAMPA 0.8\begin{array} { | l | l | } \hline \text { CITY } & \text { FACTOR } \\\hline \text { CARY } & 1 \\\hline \text { ERIE } & 1.1 \\\hline \text { RENO } & 0.9 \\\hline \text { TAMPA } & 0.8 \\\hline\end{array}
If the return city of table RENTALS is the one listed in table CITYADJ, the cost of the rental is multiplied by FACTOR and by DAYS shown in table RENTLENGTH below.

RENTLENGTH
 RTN  DAYS 1123324254627381\begin{array} { | l | l | } \hline \text { RTN } & \text { DAYS } \\\hline 1 & 1 \\\hline 2 & 3 \\\hline 3 & 2 \\\hline 4 & 2 \\\hline 5 & 4 \\\hline 6 & 2 \\\hline 7 & 3 \\\hline 8 & 1 \\\hline\end{array}
RENTLENGTH shows the number of DAYS for the rental number (RTN) of the table RENTALS (this table exists for the sake of testing SQL. Normally, the data here should be part of table RENTALS.
-As a result of the execution of the query SELECT MIN(Age) AS Minage,MAX(Age) AS Maxage
FROM CUSTOMER
GROUP BY Resid_City,BirthPlace
Which one of the following values does not appear in the column with heading Minage?


Definitions:

Beta

A quantification of the risk and fluctuations experienced by a security or portfolio when compared to the general market.

Treynor Measure

A performance metric for determining how well an investment compensates the investor for taking a particular level of risk, accounting for systematic risk.

Standard Deviation

A statistical measure that represents the dispersion or variance in a set of data points, used in finance to measure the volatility of investment returns.

Beta

Beta is a measure of an investment's volatility and systemic risk compared to the overall market.

Related Questions