# Hrm Labor

Topics: Mathematics, SQL, Following Pages: 5 (363 words) Published: January 26, 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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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:| | ? |
| | | " |
| | | ' |
| | | * |
| Instructor Explanation:| Week 2 Lecture|
|
|
| Points Received:| 3 of 3 |
|
|
7.| Question :| (TCO 2) Which of the following date functions syntax is incorrect.|
|
| Student Answer:| | Year(date_value) |
| | | Month(date_value) |
| | | Week(date_value) |
| | | Day(date_value) |
| Instructor Explanation:| Week 2 Lecture|
|
|
| Points Received:| 0 of 3 |
|
|
8.| Question :| (TCO 2) Which of the following functions would return the current date based on the computer clock.|
|
| Student Answer:| | TodayDate() |
| | | PutDate() |
| | | FindDate() |
| | | GetDate() |
| Instructor Explanation:| Week 2 Lecture|
|
|
| Points Received:| 3 of 3 |
|
|
9.| Question :| (TCO 2) When using the Convert function, the _____ identifier signifies the format of the output.|
|
| Student Answer:| | look |
| | | type |
| | | style |
| | | appearance |
| Instructor Explanation:| Week 2 Lecture|
|
|
| Points Received:| 0 of 3 |
|
|
10.| Question :| (TCO 3) Which of the following aggregate functions can be used with any data type.|
|
| Student Answer:| | MAX |
| | | SUM |
| | | COUNT |
| | | AVG |
| Instructor Explanation:| Week 2 Lecture|
|
|
| Points Received:| 0 of 3 |
|
|
|

|