Introduction To Mysql

Match List I with List II

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

Choose the correct answer from the options given below :

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 :

Match List I with List II

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

Choose the correct answer from the options given below :

String function in SQL is/are -
A. LTRIM()
B. RIGHT()
C. MID()
D. DAY()
E. MAX()
Choose the correct answer from the options given below :

Which operator is used to match a pattern or string in SQL?

Library used to interact with MYSQL database by providing the required credentials.