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 98 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
Gracias!

shewald78

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

« previous next »
 

Did you know?

Adolescents often feel clumsy during puberty because during this time of development, their hands and feet grow faster than their arms and legs do. The body is therefore out of proportion. One out of five adolescents actually experiences growing pains during this period.

Did you know?

Glaucoma is a leading cause of blindness. As of yet, there is no cure. Everyone is at risk, and there may be no warning signs. It is six to eight times more common in African Americans than in whites. The best and most effective way to detect glaucoma is to receive a dilated eye examination.

Did you know?

Aspirin is the most widely used drug in the world. It has even been recognized as such by the Guinness Book of World Records.

Did you know?

Illicit drug use costs the United States approximately $181 billion every year.

Did you know?

The average human gut is home to perhaps 500 to 1,000 different species of bacteria.

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.
Effect of substrate concentration on the initial velocity of an enzyme-catalyzed reaction Effect of substrate concentration on the initial velocity of an enzyme-catalyzed reaction
Schematic depiction of the hydrophobic effect Schematic depiction of the hydrophobic effect
Effect of the direction of flagellar rotation Effect of the direction of flagellar rotation
Effect of an Increase in Technological Progress Effect of an Increase in Technological Progress
Chilling Effect of a Cold Current Chilling Effect of a Cold Current
Video: Role of transport in a cell

For a complete list of videos, visit our video library