Hrm Labor

Only available on StudyMode
  • Download(s) : 119
  • Published : January 26, 2013
Open Document
Text Preview
 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:| | ? |
 | | | " |
 | | | ' |
 | | | * |
 | Instructor Explanation:| Week 2 Lecture|
|
|
 | Points Received:| 3 of 3 |
 | Comments:| |
|
|
 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 |
 | Comments:| |
|
|
 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 |
 | Comments:| |
|
|
 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 |
 | Comments:| |
|
|
 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 |
 | Comments:| |
|
|
|

|
tracking img