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

Created with That Quiz — the math test generation site with resources for other subject areas.