MYSQL MCQs - 10
What is the purpose of the AVG() function in MySQL? A) To return the maximum value of a column B) To return the minimum value of a co...
What is the purpose of the AVG() function in MySQL? A) To return the maximum value of a column B) To return the minimum value of a co...
What is the purpose of the IFNULL() function in MySQL? A) To check if a value is null B) To return the first non-null value in a list...
What is the purpose of the DATE_FORMAT() function in MySQL? A) To calculate the difference between two dates B) To return the current...
What is the purpose of the COUNT() function in MySQL? A) To return the number of rows in a table B) To calculate the total value of a...
What is the purpose of the NOW() function in MySQL? A) To return the current date and time B) To return the current date C) To ret...
What is the purpose of the CONCAT_WS() function in MySQL? A) To concatenate values from multiple rows into a single string B) To conc...
What is the purpose of the GROUP_CONCAT() function in MySQL? A) To calculate the average value of a numeric column B) To concatenate ...
What is the purpose of the JOIN keyword in MySQL? A) To perform aggregate functions on grouped data B) To filter rows based on a spec...
Which SQL command is used to retrieve specific columns from a table in MySQL? A) GET B) FETCH C) SELECT D) FILTER Answer...
Which statement is used to create a new table in MySQL? A) CREATE B) INSERT C) UPDATE D) SELECT Answer: A) CREATE ...
What does ng-dblclick directive do in AngularJS? A) It binds a double-click event to a function. B) It initializes the Angu...
What does ng-copy directive do in AngularJS? A) It binds a copy event to a function. B) It initializes the AngularJS application. ...
What does ng-disabled directive do in AngularJS? A) It binds the disabled state of an input element to an expression. B) It initializ...
What does ng-app directive do in AngularJS? A) It initializes the AngularJS application. B) It defines a new controller in AngularJS....
Which AngularJS directive is used to dynamically change the content of HTML elements based on an expression? A) ng-show B) ng-bind ...
Which AngularJS directive is used to dynamically add or remove HTML elements based on an expression? A) ng-if B) ng-show C) ng-hid...
What does ng-class directive do in AngularJS? A) It binds CSS classes to HTML elements based on expression evaluation. B) It initiali...
What does ng-cloak directive do in AngularJS? A) It hides an element until AngularJS has finished its compilation. B) It binds an HTM...
Which directive is used to include external HTML templates in AngularJS? A) ng-include B) ng-template C) ng-html D) ng-external...
What does MVC stand for in AngularJS architecture? A) Model View Controller B) Module View Component C) Multi View Control D) M...