1.

Explain the purpose of Floor and Sign functions?

Answer»
  • Floor- this function is used to ROUND up the values which are non-integer. It is done for the proceeding of LEAST integer values
  • Sign- this function is used to determine if the number provided is positive, negative, zero and then returns the value as +1, 0, -1.
10. What is the SQL server agent?

SQL server agent has a major role to play in the day to day task management of the SQL server database administration. Its ultimate purpose is to effectively implement the task proteins EASILY aligned to the scheduler engine which allows them to run for a specific time and date. It also offers two modes of authentication defined in SQL server, these modes are-

  • Windows mode
  • Mixed mode

If there is a need to change the mode then it can be done from the tool menu of the SQL server configuration properties in the security page SECTION.


Discussion

No Comment Found

Related InterviewSolutions