Figuer:
CUSTOMER (Primary Key = CID)
CNAME Is NOT NULL

question 52

Multiple Choice

Figuer:
CUSTOMER (primary key = CID)
CNAME is NOT NULL $$\begin{array} { | l | l | l | l | l | } \hline \text { CID } & \text { CNAME } & \text { AGE } & \text { RESID\_CITY } & \text { Cregion } \\\hline 10 & \text { BLACK } & 40 & \text { SD } & \text { SD } \\\hline 20 & \text { GREEN } & 25 & \text { SD } & \text { SD } \\\hline 30 & \text { JONES } & 30 & \text { La Mesa } & \text { SD } \\\hline 40 & \text { MARTIN } & 35 & \text { LA } & \text { LA } \\\hline 50 & \text { SIMON } & 22 & \text { Pomona } & \text { LA } \\\hline 60 & \text { VERNON } & 60 & \text { Poway } & \text { SD } \\\hline\end{array}$$ RENTALS (primary key = RTN)
CID is a foreign key referencing CUSTOMER
CID is NOT NULL
MAKE is NOT NULL
MAKE is a foreign key referencing RENTCOST $$\begin{array} { | l | l | l | l | l | l | } \hline \text { CID } & \text { MAKE } & \text { DATE\_OUT } & \text { PICKUP } & \text { RETURN } & \text { RTN } \\\hline 10 & \text { FORD } & 10 - \text { Oct-00 } & \text { SD } & \text { SD } & 1 \\\hline 10 & \text { GM } & 01 - \text {-Jan-01 } & \text { SD } & \text { LA } & 2 \\\hline 10 & \text { FORD } & 01 - \text { Feb-01 } & \text { LA } & \text { SD } & 3 \\\hline 20 & \text { NISSAN } & 07 - J u l - 00 & \text { SD } & & 4 \\\hline 30 & \text { FORD } & 01 - J u l - 00 & \text { SD } & \text { SD } & 5 \\\hline 30 & \text { GM } & 01 - \text {-Dec-00 } & \text { SD } & \text { SD } & 6 \\\hline 40 & \text { FORD } & 01 - \text { Aug-00 } & \text { LA } & \text { LA } & 7 \\\hline 50 & \text { GM } & 01 - \text { Sep-00 } & \text { LA } & \text { SD } & 8 \\\hline 60 & \text { NISSAN } & 02 \text {-Jan-01 } & \text { SD } & \text { LA } & 9 \\\hline\end{array}$$ RENTCOST
MAKE is the primary key $$\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}$$ (Access) View1:
SELECT RTN, MAKE, PICKUP, RENTALS.CID,
CUSTOMER.CID, CNAME, AGE, Cregion
FROM CUSTOMER INNER JOIN RENTALS
ON CUSTOMER.CID = RENTALS.CID
(Access) View2:
SELECT RTN, MAKE, PICKUP, RENTALS.CID,
CNAME, AGE, Cregion
FROM CUSTOMER INNER JOIN RENTALS
ON CUSTOMER.CID = RENTALS.CID
(Access) View3:
SELECT RTN, RENTALS.MAKE, PICKUP, RENTALS.CID,
CNAME, AGE, Cregion, COST
FROM (CUSTOMER INNER JOIN RENTALS
ON CUSTOMER.CID = RENTALS.CID.
INNER JOIN RENTCOST
ON RENTALS.MAKE = RENTCOST.MAKE
-(Access) INSERT INTO View2 (RTN,MAKE,PICKUP,RENTALS.CID,CNAME)
VALUES (11,'GM','SD',70,'JORDAN' )
Which of the following is true?

• A) This command inserts 1 row into RENTALS
• B) This command inserts 1 row into CUSTOMER
• C) After execution of this command, SELECT MAKE FROM View2 WHERE CNAME='JORDAN' will show 1 row
• D) This command cannot execute

---

Definitions:

Transcendental Meditation

A form of silent mantra meditation aimed at promoting relaxation and reducing stress.

Altered State

A condition in which the normal functioning of consciousness is changed, often experienced during meditation, trance, sleep, or under the influence of psychoactive substances.

Consciousness

The awareness of internal and external stimuli, enabling perception, thought, and self-awareness.

Sleep Terrors

Episodes of screaming, intense fear, and flailing while still asleep, associated with non-REM sleep.