Hrm Labor

Topics: Mathematics, SQL, Function, Quotation mark, Question, Summation / Pages: 2 (363 words) / Published: Jan 26th, 2013
1. | Question : | (TCO 2) Use the ____ data type for columns that contain letters and special characters and for columns containing numbers that will not be used in calculations. | | | Student Answer: | | CHAR | | | | VARCHAR | | | | Text | | | | String | | Instructor Explanation: | Week 2 Lecture | | | | Points Received: | 0 of 3 | | Comments: | | | | 2. | Question : | (TCO 2) In SQL which of the following parameters will allow you to add a space as a valid character in your output. | | | Student Answer: | | double quotes | | | | single quotes | | | | parenthesis | | | | brackets | | Instructor Explanation: | Week 2 Lecture | | | | Points Received: | 0 of 3 | | Comments: | | | | 3. | Question : | (TCO 2) Which of the following functions would you use to extract the from your records in the database? | | | Student Answer: | | Datepart | | | | Datediff | | | | Dateout | | | | Dateyear | | Instructor Explanation: | Week 2 Lecture | | | | Points Received: | 0 of 3 | | Comments: | | | | 4. | Question : | (TCO 3)________functions are SQL mathematical summaries. | | | Student Answer: | | Summation | | | | Summary | | | | Aggregate | | | | Cummalative | | Instructor Explanation: | Week 2 Lecture | | | | Points Received: | 0 of 3 | | Comments: | | | | 5. | Question : | (TCO 3) Which of the following clause filters by rows. | | | Student Answer: | | Having | | | | Where | | | | Order | | | | Select | | Instructor Explanation: | Week 2 Lecture | | | | Points Received: | 0 of 3 | | Comments: | | | | 6. | Question : | (TCO 3) Which of the following characters can be used with the COUNT function to return the total numbers of rows in the query. | | | Student Answer: | | ? |

You May Also Find These Documents Helpful

  • Hrms
  • Hrm
  • Hrms
  • labor
  • Labor
  • Assignment 4 Department Of Labor Case Study HRM 533
  • Labor
  • Labor
  • HRM
  • Hrm Evaluation and Hrm Models