Infosys Certified MySQL Associate
Practice with real exam-pattern questions for Infosys Certified MySQL Associate. Each question includes a detailed explanation to help you understand the concept, not just memorise the answer. Try 10 questions free — no login required.
Full question bank for this exam + 1,357+ others. Cancel anytime.
Join Premium10 Infosys Certified MySQL Associate practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified MySQL Associate certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
What is the expected output of below SQL
SELECT dt.DeptNo FROM dept_tbl dt LEFT OUTER JOIN dept_master dm ON dt.DeptNo = dm.DeptNo;
Table Dept _tbl
Dept No
Depart Name
10
Accounting
20
Purchase
30
Sales
50
Marketing
Table Dept_master
DeptNo
DepartName
10
Accounting
20
Purchase
30
Sales
40
Stores
- ✓
DeptNo---------10203040
Correct - B
DeptNo---------1020304050
- C
DeptNo---------102030
- D
DeptNo---------10203050
ExplanationThe SQL query is like a matching game! It's looking for department numbers (DeptNo) in both tables, dept_tbl and dept_master. It will show all the department numbers from dept_tbl, even if there's no match in dept_master. So, the final answer is: 10, 20, 30, and 50! All the department numbers from dept_tbl are shown, no matter what!
- ✓
- Question 2
What is the expected output of below SQL
SELECT DeptNo FROM dept_tbl UNION ALL SELECT DeptNo FROM dept_master;
Table Dept _tbl
Dept No
Depart Name
10
Accounting
20
Purchase
30
Sales
50
Marketing
Table Dept_master
DeptNo
DepartName
10
Accounting
20
Purchase
30
Sales
40
Stores
- ✓
DeptNo---------1010202030304050
Correct - B
DeptNo---------1020304050
- C
DeptNo---------10203040
- D
DeptNo---------10203050
ExplanationThe expected output of the SQL query is:
10
20
30
50
10
20
30
40
The UNION ALL operator combines the result sets of both SELECT statements, including duplicates. So, you'll see all the DeptNo values from both tables, with duplicates included.
If you want to remove duplicates, you can use the UNION operator instead of UNION ALL:
SELECT DeptNo FROM dept_tbl UNION SELECT DeptNo FROM dept_master;
This will give you:
10
20
30
40
50
- ✓
- Question 3
Which query can be used to Delete the column 'Birthday' from the Persons table?
- ✓
DROP COLUMN Birthday FROM Persons;
Correct - B
ALTER TABLE Persons DROP COLUMN Birthday;
- C
DELETE FROM Persons where COLUMN = 'Birthday';
- D
ALTER TABLE Persons DELETE COLUMN Birthday;
ExplanationTo delete the column 'Birthday' from the 'Persons' table in SQL, you would use the following query:
Option 2: ALTER TABLE Persons DROP COLUMN Birthday;
The correct syntax for removing a column from a table is to use the
ALTER TABLEstatement with theDROP COLUMNclause, as shown in Option 2. - ✓
- Question 4
Partitioning based on specific set of values can be achieved using which partitioning method?
- ✓
KEY
Correct - B
RANGE
- C
HASH
- D
LIST
ExplanationSo, you want to know which partitioning method is used to split data based on a specific set of values? Well, the answer is LIST partitioning! Think of it like a to-do list - you've got a specific set of tasks (or values) that you want to group together. LIST partitioning lets you do just that with your data. RANGE partitioning is like grouping numbers into buckets (1-100, 101-200, etc.), while HASH partitioning is like using a special formula to scatter data across partitions. But LIST is the way to go when you've got a specific set of values in mind!
- ✓
- Question 5
The number of rows affected by the REPLACE query indicates,
- ✓
the number of matching rows removed in the table
Correct - B
the number of matching rows replaced in the table
- C
the number of new rows inserted into the table
- D
the number of matching rows deleted from the table and the number of new/replacing rows inserted into the table
ExplanationThe correct answer is: the number of matching rows deleted from the table and the number of new/replacing rows inserted into the table
When you use a REPLACE query, it's like a "swap" operation. It removes the matching rows from the table and inserts new rows (which can be updated or entirely new ones) in their place. So, the number of rows affected shows both the removal and insertion counts.
Here's a breakdown:
- Matching rows removed (deleted): The old data that's replaced
- New/Replacing rows inserted: The new data that's added
So, the rows affected count gives you the total of both these actions!
- ✓
- Question 6
Which of the below query suits for below scenario? Show all records from the Candidate table in the increasing order of phone number column value, whose name does not containing "Jack" and whose phone number is '456783'.
- ✓
SELECT * FROM Candidate WHERE name <> "%Jack%" AND phone_number = '456783' order by phone_number;
Correct - B
SELECT * FROM Candidate WHERE name not = "Jack" AND phone_number == '456783' order phone_number;
- C
SELECT * FROM Candidate WHERE name != "%Jack%" AND phone_number == '456783' order by phone_number;
- D
SELECT DISTINCT * FROM Candidate WHERE name == "%Jack%" AND phone_number = '456783' order by phone_number;
- ✓
- Question 7
The REPLACE statement returns the number of rows affected to indicate the
- ✓
Number of rows deleted
Correct - B
Number of rows replaced
- C
Number of rows inserted
- D
Total number of rows deleted and inserted
- ✓
- Question 8
Which of the following statements are true about implicit and explicit cursor?
- ✓
Both Implicit and Explicit type of cursors need to be declared by the users
Correct - B
Users have control on both type of cursors
- C
Both a & b
- D
Only Explicit cursors need to be declared by the user
- ✓
- Question 9
Which among the following are activities involved in Implementing Business Logic?
- ✓
Performing Data Processing , Applying Business Logic
Correct - B
Handling runtime errors and Ensuring data integrity
- C
Both a & b
- D
None of the above
- ✓
- Question 10
Select the index that should be created in CUSTOMER_INFO table to improve the performance of the below query: SELECT name, address FROM CUSTOMER_INFO WHERE phone = 7265776867;
- ✓
create index customer_index on customer_info (name, address)
Correct - B
create index customer_index on customer_info(name, address, phone)
- C
create index customer_index on customer_info(phone)
- D
All of the above
- ✓
More in Open Source
Infosys Certified Elasticsearch Developer
Infosys Certified PostgreSQL Associate
Infosys Certified PHP Associate
Pay once. Clear every cert this year.
One subscription, full Telegram channel access, every PDF posted during your membership.
- Full access to all 1,357+ certifications
- Monthly updated question banks
- Telegram private channel access
- Cancel anytime
- Everything in Monthly
- Save ₹2,100 vs monthly billing
- Priority answer key requests
- Best for increasing DQ score fast
- Everything in Quarterly
- Lifetime channel access — no renewals
- All future certifications included
- Priority response from admin team
Common questions, straight answers.
A monthly-updated Telegram channel where we post real exam-pattern question banks and detailed answer keys for 1,357+ Infosys Lex certifications. You join once, you get every PDF posted during your membership.
Right after payment on our Graphy page, you'll receive a private invite link to the Telegram channel. Access is instant — usually under 30 seconds.
We compile question banks from the actual Lex test pattern, sourced and verified by 180K+ community members who've recently cleared these exams. Match rate is consistently 85–95%.
Every single month. When Infosys rolls out new versions of certifications, we post updated dumps within 7–10 days. You'll see channel activity weekly.
Clearing certifications is one of the highest-weighted DQ factors. Members typically clear 3–5 certifications in their first 3 months, which moves DQ scores up by a full band.