CUET-UG SERIES Computer-science
Introduction To Mysql
6 previous year questions.
Volume: 6 Ques
Yield: Medium
High-Yield Trend
6
2023 Chapter Questions 6 MCQs
01
PYQ 2023
medium
computer-science ID: cuet-ug-
Match List I with List II
Choose the correct answer from the options given below :
| 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 |
1
A-IV, B-II, C-III, D-I
2
A-I, B-II, C-III, D-IV
3
A-III, B-I, C-IV, D-II
4
A-II, B-III, C-IV, D-I
02
PYQ 2023
medium
computer-science ID: cuet-ug-
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 :
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 :
1
A, C, D and E only
2
A, B, C and D only
3
B, C, D and E only
4
A, B, D and E only
03
PYQ 2023
medium
computer-science ID: cuet-ug-
Match List I with List II
Choose the correct answer from the options given below :
| 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 |
1
A-I, B-II, C-III, D-IV
2
A-III, B-IV, C-I, D-II
3
A-III, B-I, C-II, D-IV
4
A-II, B-III, C-I, D-IV
04
PYQ 2023
medium
computer-science ID: cuet-ug-
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 :
A. LTRIM()
B. RIGHT()
C. MID()
D. DAY()
E. MAX()
Choose the correct answer from the options given below :
1
A, B and E only
2
C, D and E only
3
B, C and E only
4
A, B and C only
05
PYQ 2023
medium
computer-science ID: cuet-ug-
Which operator is used to match a pattern or string in SQL?
1
In
2
Between
3
Join
4
Like
06
PYQ 2023
medium
computer-science ID: cuet-ug-
Library used to interact with MYSQL database by providing the required credentials.
1
pysql
2
pandas
3
sqlalchemy
4
datatrames
About Introduction To Mysql - CUET-UG
Introduction To Mysql is a vital chapter for CUET-UG aspirants. Mastering the concepts covered in this chapter is essential for securing a top rank.
By rigorously practicing the previous year questions associated with this chapter, you can identify high-yield topics, understand the examiner's perspective, and boost your confidence during the actual exam.
Frequently Asked Questions
Why focus on Introduction To Mysql PYQs?
Analyzing PYQs for this specific chapter reveals the most frequently tested concepts and the typical complexity of questions, allowing you to tailor your study plan efficiently.
How to best use this analysis?
Review the topic breakdown to see which sub-topics within Introduction To Mysql carry the most weight. Then, tackle the questions iteratively to solidify your understanding.