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 152 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 :)

abro1885

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

« previous next »
 

Did you know?

Less than one of every three adults with high LDL cholesterol has the condition under control. Only 48.1% with the condition are being treated for it.

Did you know?

Normal urine is sterile. It contains fluids, salts, and waste products. It is free of bacteria, viruses, and fungi.

Did you know?

To prove that stomach ulcers were caused by bacteria and not by stress, a researcher consumed an entire laboratory beaker full of bacterial culture. After this, he did indeed develop stomach ulcers, and won the Nobel Prize for his discovery.

Did you know?

Every flu season is different, and even healthy people can get extremely sick from the flu, as well as spread it to others. The flu season can begin as early as October and last as late as May. Every person over six months of age should get an annual flu vaccine. The vaccine cannot cause you to get influenza, but in some seasons, may not be completely able to prevent you from acquiring influenza due to changes in causative viruses. The viruses in the flu shot are killed—there is no way they can give you the flu. Minor side effects include soreness, redness, or swelling where the shot was given. It is possible to develop a slight fever, and body aches, but these are simply signs that the body is responding to the vaccine and making itself ready to fight off the influenza virus should you come in contact with it.

Did you know?

The Babylonians wrote numbers in a system that used 60 as the base value rather than the number 10. They did not have a symbol for "zero."

The enhancement effect observed by Emerson. The enhancement effect observed by Emerson.
Effect of predator on prey populations. Effect of predator on prey populations.
Effect of Atmospheric Stability Effect of Atmospheric Stability
Effect of increasing temperature or lowering deltGo+ on the rates of reactions Effect of increasing temperature or lowering deltGo+ on the rates of reactions
Effect of cooperative substrate binding on enzyme kinetics Effect of cooperative substrate binding on enzyme kinetics
De novo and maintenance methylation of DNA and the effect of 5’-azacytidine upon DNA methylation De novo and maintenance methylation of DNA and the effect of 5’-azacytidine upon DNA methylation
Video: Evolutionary tree of life Animation

For a complete list of videos, visit our video library