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

dantucker

  • Member
  • Posts: 346
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

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.

Did you know?

The first oncogene was discovered in 1970 and was termed SRC (pronounced "SARK").

Did you know?

Patients should never assume they are being given the appropriate drugs. They should make sure they know which drugs are being prescribed, and always double-check that the drugs received match the prescription.

Did you know?

Bisphosphonates were first developed in the nineteenth century. They were first investigated for use in disorders of bone metabolism in the 1960s. They are now used clinically for the treatment of osteoporosis, Paget's disease, bone metastasis, multiple myeloma, and other conditions that feature bone fragility.

Did you know?

Asthma is the most common chronic childhood disease in the world. Most children who develop asthma have symptoms before they are 5 years old.

Effect of changing a set point for hypothalamic values Effect of changing a set point for hypothalamic values
The Greenhouse Effect The Greenhouse Effect
Example of Reconciling a Bank Statement Cont. Example of Reconciling a Bank Statement Cont.
Effect of pH on drug absorption. (a) A weak acid such as aspirin (ASA) is in a nonionized form in an ... Effect of pH on drug absorption. (a) A weak acid such as aspirin (ASA) is in a nonionized form in an ...
Contributions of various His residues to the Bohr effect in hemoglobin Contributions of various His residues to the Bohr effect in hemoglobin
Greenhouse effect. Greenhouse effect.
Video: Evolutionary tree of life Animation

For a complete list of videos, visit our video library