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