Infosys Certified MySQL Developer
Practice with real exam-pattern questions for Infosys Certified MySQL Developer. 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 Developer practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified MySQL Developer certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
Which of the following is not a feature of MySQL ?
- ✓Open Source DatabaseCorrect
- BACID Compliance Database
- CSupports data partitioning
- DSupports horizonal scalability
- Question 2
Which of the following datatype is not the correct datatype in MySQL ?
- ✓TEXTCorrect
- BBLOB
- CBLOBTEXT
- DLONGTEXT
- Question 3
What is the correct syntax for creating database in MySQL ?
- ✓create database_name Correct
- Bcreate db database_name
- Ccreate database database_name
- Duse database_name
- Question 4
Which drop command below will not throw any error if the database is not present ?
- ✓drop database database_nameCorrect
- Bdrop database if exists database_name
- Cdrop if exists database_name
- Ddrop database_name
- Question 5
What happens if we directly use create table command without selecting any database?
- ✓Table will be created in last used databaseCorrect
- BTable will not be created
- CIt will throw an error
- DTable will be created in master database
- Question 6
Which command is used to remove partition from the table ?
- ✓ALTERCorrect
- BDELETE
- CREMOVE
- DMODIFY
- Question 7
When should the foreign key constraint of column(s) be implemented ?
- ✓Only at column level during table creationCorrect
- BOnly at table level during table creation
- CEither at column level or table level during table creation
- DOnly in RENAME command after the table creation
- Question 8
Select the correct command to add a new column 'ALTERNATE_NUMBER' in the 'USER' table ?
- ✓ALTER TABLE USER ADD ALTERNATE_NUMBER BIGINT(20)Correct
- BINSERT INTO USER ADD ALTERNATE_NUMBER BIGINT(20)
- CINSERT INTO TABLE USER ADD ALTERNATE_NUMBER BIGINT(20)
- DALTER USER ADD ALTERNATE_NUMBER BIGINT(20)
- Question 9
Choose the correct command to rename the table 'EMP' to 'EMPLOYEE'
- ✓RENAME TABLE EMP, EMPLOYEECorrect
- BALTER TABLE RENAME EMP TO EMPLOYEE
- CALTER EMP RENAME EMPLOYEE
- DALTER TABLE EMP RENAME EMPLOYEE
- Question 10
Which command can be used to change the engine type of the table?
- ✓MODIFYCorrect
- BALTER
- CGRANT
- DCHANGE
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.