- 1. Used to compute numerical values from the column name.
A) Scalar Functions B) Set Functions C) Aggregate Functions D) Mathematical Functions E) Algebraic Functions
- 2. Used to return a single value based on a given value.
A) Aggregate Functions B) Algebraic Functions C) Scalar Functions D) Set Functions E) Mathematical Functions
- 3. Returns the number of indicated rows in a column.
A) Max B) Min C) Sum D) Avg E) Count
- 4. Returns the total of numbers in a column.
A) Avg B) Sum C) Count D) Max E) Min
- 5. Returns the largest value in a given column.
A) Sum B) Avg C) Count D) Max E) Min
- 6. Returns the smallest value in a given column.
A) Min B) Avg C) Max D) Sum E) Count
- 7. Returns the total value in a given column.
A) Max B) Sum C) Min D) Avg E) Count
- 8. Converts a field to BIG LETTERS.
A) Now B) Lcase C) Round D) Len E) Ucase
- 9. Converts a field to small letters.
A) Round B) Len C) Ucase D) Now E) Lcase
- 10. Returns the length or distance of a text field.
A) Ucase B) Lcase C) Round D) Len E) Now
- 11. Returns an estimated number based on decimals specified.
A) Lcase B) Now C) Round D) Len E) Ucase
- 12. The Ctrl command to execute SQL.
A) Ctrl+R B) Ctrl+S C) Ctrl+Q D) Ctrl+G E) Ctrl+E
- 13. These functions hold and return real numbers.
A) Mathematical Functions B) Algebraic Functions C) Scalar Functions D) Set Functions E) Aggregate Functions
- 14. A function that returns the absolute positive value of the specified numerical expression.
A) ROUND() B) CEILING() C) POWER() D) FLOOR() E) ABS()
- 15. A function that returns the smallest integer value greater than or equal to a given number.
A) ABS() B) FLOOR() C) ROUND() D) CEILING() E) POWER()
- 16. A function that returns the largest integer less than or equal to the specified column name.
A) POWER() B) ABS() C) CEILING() D) ROUND() E) FLOOR()
- 17. A function that returns the value of a given expression with specified exponential value.
A) FLOOR() B) ROUND() C) CEILING() D) ABS() E) POWER()
- 18. A function that returns an estimated numeric value to the specified length or precision.
A) ROUND() B) FLOOR() C) ABS() D) CEILING() E) POWER()
- 19. A function that returns the inverse exponential value.
A) EXP() B) SQUARE() C) SQRT() D) SYSDATETIME() E) GETDATE()
- 20. A function that returns the exponential value of the specified expression through logarithmic expression.
A) SYSDATETIME() B) EXP() C) GETDATE() D) SQRT() E) SQUARE()
- 21. A function that returns the system's chronological details where the SQL server runs. (yyyy/mm/dd hh:mm:ss)
A) GETDATE() B) EXP() C) SQUARE() D) SYSDATETIME() E) SQRT()
- 22. A function that returns chronological details where the SQL server runs.
A) SYSDATETIME() B) SQUARE() C) GETDATE() D) SQRT() E) EXP()
- 23. This function returns a character string of the specified date.
A) DAY() B) DATENAME() C) DATEPART() D) MONTH() E) YEAR()
- 24. This datepart has an abbreviation of yy, yyyy.
A) Week B) Day C) Quarter D) Year E) Month
- 25. This datepart has an abbreviation of ww.
A) Month B) Year C) Week D) Quarter E) Day
- 26. Which datepart abbreviation means Weekday?
A) dy B) dm C) wd D) wk E) dw
- 27. Which datepart abbreviation means Microsecond?
A) Mcs B) Mns C) Ms D) Mcd E) mm
- 28. This function returns an anatomical numeric value specified in a given date.
A) DATEPART() B) MONTH() C) GETDATE() D) DATENAME() E) DAY()
- 29. In DAY(), which is the day in this example?:
05/01/2025
A) 2025 B) 01 C) 05
- 30. In MONTH(), which is the month in this example?:
12/11/1947
A) 1947 B) 12 C) 11
- 31. This function returns new date value by adding a month, day, or year to the specified date.
A) DATEADD() B) CONCAT() C) CHAR() D) DATEDIFF() E) ASCII()
- 32. This function returns the number of date or time bound by boundaries.
A) DATEADD() B) CHAR() C) ASCII() D) DATEDIFF() E) CONCAT()
- 33. The most common format for text files in computers and on the Internet.
A) ASCII B) UTF-16 C) ISO/IEC 8859 D) UTF+8 E) Unicode
- 34. It returns the given code value of the given numerical ASCII value.
A) CHAR() B) DATEDIFF() C) DATEADD() D) CONCAT() E) ASCII()
- 35. It returns a single string from the given string/(s).
A) CHAR() B) ASCII() C) CONCAT() D) DATEDIFF() E) DATEADD()
- 36. It only returns the first set of a character based on the specified number of characters, dubbed
A) CONCAT() B) RIGHT() C) DATEDIFF() D) DATEADD() E) LEFT()
- 37. It only returns the last set of a character based on the specified number of characters, dubbed
A) RIGHT() B) LEFT() C) ASCII() D) CHAR() E) CONCAT()
- 38. It returns the value as to how many letters or characters present in a cell or expression.
A) UCASE() B) LEN() C) NOW() D) LCASE() E) ROUND()
- 39. This function turns small letters to BIG LETTERS.
A) RIGHT() B) ROUND() C) UPPER() D) LEFT() E) LOWER()
- 40. This function turns BIG LETTERS to small letters.
A) UPPER() B) LOWER() C) ROUND() D) LEFT() E) RIGHT()
- 41. This function removes all leading blanks of the given character expression.
A) RTRIM() B) ROUND() C) LEFT() D) RIGHT() E) LTRIM()
- 42. This function removes all trailing blanks of the given character expression.
A) ROUND() B) LEFT() C) RTRIM() D) LTRIM() E) RIGHT()
- 43. This function changes all mentioned values to new values.
A) REPLICATE() B) STR() C) SPACE() D) REVERSE() E) REPLACE()
- 44. This function makes clones of the specified value.
A) REVERSE() B) REPLACE() C) REPLICATE() D) SPACE() E) STR()
- 45. This function makes a mirrored value by inverting the order of characters.
A) SPACE() B) REVERSE() C) REVERSE() D) REPLICATE() E) STR()
- 46. It means breaking the database into several multiple files.
A) Normalization B) Partitioning C) Interleaving data D) Data compression E) Page size
- 47. It enforces the physical sequence of a table.
A) Data reorganization B) Free spaces C) Indexing D) Clustering E) File placement
- 48. It enables easier query and minimizes redundancies.
A) Interleaving data B) Normalization C) Partitioning D) Data compression E) Page size
- 49. Find the result of POWER (6, 3).
A) 18 B) 972 C) 318 D) 216 E) 163
- 50. Find the result of SQRT(324)
A) 32 B) 9 C) 18 D) 25 E) 59
|