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 99 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
Thanks for the timely response, appreciate it

bimper21

  • Member
  • Posts: 309
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

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.

Did you know?

According to the FDA, adverse drug events harmed or killed approximately 1,200,000 people in the United States in the year 2015.

Did you know?

Asthma occurs in one in 11 children and in one in 12 adults. African Americans and Latinos have a higher risk for developing asthma than other groups.

Did you know?

The longest a person has survived after a heart transplant is 24 years.

Did you know?

In 1864, the first barbiturate (barbituric acid) was synthesized.

The greenhouse effect: heat trapping by earth's atmosphere. The greenhouse effect: heat trapping by earth's atmosphere.
Effect of the chemical environment on pKa Effect of the chemical environment on pKa
Gas Solubility - Effect of pressure Gas Solubility - Effect of pressure
Schematic depiction of the hydrophobic effect Schematic depiction of the hydrophobic effect
The Greenhouse Effect The Greenhouse Effect
Effect of Increasing the Investment Rate on the Steady State Effect of Increasing the Investment Rate on the Steady State
Video: Bone Healing Animation

For a complete list of videos, visit our video library