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 140 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

31809pancho

  • Member
  • Posts: 317
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

Adult head lice are gray, about ? inch long, and often have a tiny dot on their backs. A female can lay between 50 and 150 eggs within the several weeks that she is alive. They feed on human blood.

Did you know?

Essential fatty acids have been shown to be effective against ulcers, asthma, dental cavities, and skin disorders such as acne.

Did you know?

When Gabriel Fahrenheit invented the first mercury thermometer, he called "zero degrees" the lowest temperature he was able to attain with a mixture of ice and salt. For the upper point of his scale, he used 96°, which he measured as normal human body temperature (we know it to be 98.6° today because of more accurate thermometers).

Did you know?

In most cases, kidneys can recover from almost complete loss of function, such as in acute kidney (renal) failure.

Did you know?

Many supplement containers do not even contain what their labels say. There are many documented reports of products containing much less, or more, that what is listed on their labels. They may also contain undisclosed prescription drugs and even contaminants.

A typical bank statement. A typical bank statement.
Effect of stimulus type on graded potentials. Effect of stimulus type on graded potentials.
Factors Affecting Saturation and Condensation: Effect of Curvature Factors Affecting Saturation and Condensation: Effect of Curvature
Lake-effect snow: Cold air over warm water Lake-effect snow: Cold air over warm water
Effect of Productivity Improvement in the Malthusian Model Effect of Productivity Improvement in the Malthusian Model
10 side effect of birth control pills 10 side effect of birth control pills
Video: Simple Diffusion - gases and nonpolar compounds transport

For a complete list of videos, visit our video library