Which of the following statements is/are true ? A. Group by function is used to group rows of a table that contain same values in a specified column. B. The BETWEEN operator used for pattern matching C. The IN operator selects the value that match any value in the given list of values D. COUNT, MAX, MIN, AVG and SUM are multiple row functions works on a set of records and return a single value E. Update table is used to change the data in a table Choose the correct answer from the options given below :

Question

cdquestions Admin · Accepted Answer

The correct option is (A) :A, C, D and E only.

Answer

A, C, D and E only

Answer

A, B, C and D only

Answer

B, C, D and E only

Answer

A, B, D and E only

List I		List II
A.	select mod(13, 3);	I.	12
B.	select power(5, 3);	II.	3
C.	select length('Data Science');	III.	1
D.	select month('2000-03-12)	IV.	125

List I		List II
A.	DML	I.	Not NULL
B.	Primary Key	II.	Create relations
C.	Alter table	III.	Insert records
D.	DDL	IV.	Add attribute

The Correct Option is A

Solution and Explanation

Top Questions on Introduction to MySQL

Questions Asked in CUET exam