Structure of the CUSTOMERS Table

question 49

Multiple Choice

Structure of the CUSTOMERS table
​
-Which of the following commands will add a new column named FIRST ORDER DATE to the CUSTOMERS table to store the date that the customer first placed an order with the company?​

• A) ​CREATE COLUMN firstorderdate,DATE TO customers;
• B) ​ALTER TABLE customers ADD COLUMN firstorderdate DATE;
• C) ​ALTER TABLE customers ADD firstorderdate DATE;
• D) ​ALTER TABLE customers ADD (firstorderdate DAT

---

Definitions:

Sensory memory

The shortest-term element of memory, where sensory information is retained for a very brief period, allowing it to be processed further into short-term or long-term memory.

Prospective memory

The component of memory tasked with the responsibility of recalling a predetermined intention or performing a planned action at a future date.

Implicit memory

Unconscious memory uses past experiences to remember things without thinking about them.

Autobiographical memory

The aspect of memory that involves the recollection of personal experiences and events in one's life.