This topic contains a solution. Click here to go to the answer

Author Question: SQL Server supports three types of indexes: clustered, unclustered, and random. Indicate whether ... (Read 55 times)

gonzo233

  • Hero Member
  • *****
  • Posts: 557
SQL Server supports three types of indexes: clustered, unclustered, and random.
 
  Indicate whether the statement is true or false

Question 2

Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following would find all employees whose name begins with the letter S using Microsoft Access?
 
  A) SELECT
  FROM EMPLOYEE
  WHERE Name IN 'S';
  B) SELECT EmpNo
  FROM EMPLOYEE
  WHERE Name LIKE 'S';
  C) SELECT
  FROM EMPLOYEE
  WHERE Name LIKE 'S';
  D) SELECT
  FROM EMPLOYEE
  WHERE Name LIKE 'S';



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

pratush dev

  • Sr. Member
  • ****
  • Posts: 321
Answer to Question 1

FALSE

Answer to Question 2

C




gonzo233

  • Member
  • Posts: 557
Reply 2 on: Jul 7, 2018
YES! Correct, THANKS for helping me on my review


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

 

Did you know?

Most fungi that pathogenically affect humans live in soil. If a person is not healthy, has an open wound, or is immunocompromised, a fungal infection can be very aggressive.

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?

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

Did you know?

The liver is the only organ that has the ability to regenerate itself after certain types of damage. As much as 25% of the liver can be removed, and it will still regenerate back to its original shape and size. However, the liver cannot regenerate after severe damage caused by alcohol.

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates's recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

For a complete list of videos, visit our video library