MySQL Viva and Practice Questions

Viva Preparation

Rapid Questions

• What does your project store, and which tables did you make?
• Which column is the primary key and why?
• Show a query that uses a JOIN.
• What is the difference between DROP and DELETE?
• How would you find the topper from your table?
• What constraint stops duplicate emails?

Tip

Summary

• Know your schema, keys, a JOIN query and DROP vs DELETE.
• Practice explaining each query out loud.

Viva की तैयारी

Rapid Questions

• आपका project क्या store करता है, कौन सी tables बनाईं?
• कौन सा column primary key है और क्यों?
• JOIN use करने वाली query दिखाएं।
• DROP और DELETE में अंतर क्या है?
• अपनी table से topper कैसे निकालेंगे?
• कौन सा constraint duplicate emails रोकता है?

Tip

सारांश

• अपना schema, keys, एक JOIN query और DROP बनाम DELETE जानें।
• हर query को बोलकर समझाने की practice करें।