Database Test Part-02

  11. Which of the following commands is used to change the structure of table? CHANGE TABLE MODIFY TABLE ALTER TABLE UPDATE TABLE 12. Consider the following statements and pick the correct answer: 1. ceiling() – returns the smallest integer greater than or equal to the specified value 2. floor() – returns … Continue Reading →

Database Test Part-01

  1. What will the output be if you try to perform arithmetic on NULL values? 0 NULL It will generate an error message Can’t be determined 2. Which of the following options is not correct about the DATEDIFF() function? It returns the difference between parts of two specified dates It takes … Continue Reading →