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 143 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
YES! Correct, THANKS for helping me on my review

juliaf

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

« previous next »
 

Did you know?

The ratio of hydrogen atoms to oxygen in water (H2O) is 2:1.

Did you know?

Cutaneous mucormycosis is a rare fungal infection that has been fatal in at least 29% of cases, and in as many as 83% of cases, depending on the patient's health prior to infection. It has occurred often after natural disasters such as tornados, and early treatment is essential.

Did you know?

According to research, pregnant women tend to eat more if carrying a baby boy. Male fetuses may secrete a chemical that stimulates their mothers to step up her energy intake.

Did you know?

About 600,000 particles of skin are shed every hour by each human. If you live to age 70 years, you have shed 105 pounds of dead skin.

Did you know?

In 1844, Charles Goodyear obtained the first patent for a rubber condom.

The enhancement effect observed by Emerson. The enhancement effect observed by Emerson.
The inheritance of snail coiling direction as an example of a maternal effect gene. The inheritance of snail coiling direction as an example of a maternal effect gene.
Experimental evidence of the effect of allelochemicals on plant production. Experimental evidence of the effect of allelochemicals on plant production.
Effect of extracellular osmolarity on water movement across a plasma membrane Effect of extracellular osmolarity on water movement across a plasma membrane
The Placebo Effect The Placebo Effect
Effect of an Increase in R&D in the Follower Country on the Steady State Effect of an Increase in R&D in the Follower Country on the Steady State
Video: Bond types - Atomic structure and basis of bonds

For a complete list of videos, visit our video library