This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: What would be the effect of the following DELETE statement?DELETE FROM SessionWHERE SessionDate < ... (Read 83 times)

beccaep

  • Hero Member
  • *****
  • Posts: 535
on: Jul 7, 2018
What would be the effect of the following DELETE statement?DELETE FROM SessionWHERE SessionDate < GETDATE( )
 
  A) It would remove all the rows from Session
  B) It would remove all the rows from session where the Sessiondate was less than the current date.
  C) It would get rid of the table session
  D) Both A and C

Question 2

When all entities are in the First Normal Form a database is ready to use.
 
  Indicate whether the statement is true or false


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

phuda

  • Sr. Member
  • ****
  • Posts: 348
Reply #1 on: Jul 7, 2018
Answer to Question 1

B

Answer to Question 2

FALSE


beccaep

  • Member
  • Posts: 535
Reply 2 on: Jul 7, 2018
Great answer, keep it coming :)

Hdosisshsbshs

  • Member
  • Posts: 315
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

Autoimmune diseases occur when the immune system destroys its own healthy tissues. When this occurs, white blood cells cannot distinguish between pathogens and normal cells.

Did you know?

Vaccines prevent between 2.5 and 4 million deaths every year.

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates’s recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

There used to be a metric calendar, as well as metric clocks. The metric calendar, or "French Republican Calendar" divided the year into 12 months, but each month was divided into three 10-day weeks. Each day had 10 decimal hours. Each hour had 100 decimal minutes. Due to lack of popularity, the metric clocks and calendars were ended in 1795, three years after they had been first marketed.

Did you know?

Once thought to have neurofibromatosis, Joseph Merrick (also known as "the elephant man") is now, in retrospect, thought by clinical experts to have had Proteus syndrome. This endocrine disease causes continued and abnormal growth of the bones, muscles, skin, and so on and can become completely debilitating with severe deformities occurring anywhere on the body.

Drugs and their effect table Drugs and their effect table
Drugs and their effect table Drugs and their effect table
Example of Reconciling a Bank Statement Cont. Example of Reconciling a Bank Statement Cont.
Effect of extreme homoallostery Effect of extreme homoallostery
Lake Effect Snow Lake Effect Snow
The ancestral and modern-day tomato. (b) Phenotypic effect of the fw2.2 transgene in the tomato The ancestral and modern-day tomato. (b) Phenotypic effect of the fw2.2 transgene in the tomato
Video: Dendrite Animation

For a complete list of videos, visit our video library