📌 MCQS mobiz knowledge wali video sy 4-5 ay thy 🔶 SHORT QUESTIONS: 1️⃣. Three Index classification 2️⃣. SQL query wala tha 3️⃣. Yeh b SQL query wala tha 4️⃣. relation diya va tha : ORDER(orderID, customerId, customerNAME) • orderid ---> customerId • customerId---> customerName yeh 3NF may ni h iss may btana tha k kon sa attribute remove ho k new table may jy ga . Reason b btani thi 🔶 LONG QUESTIONS: 1️⃣. yeh he screenshot wala aya tha(Handouts page # 310) 2️⃣. index create krna tha 3️⃣. ayk scenario diya va tha btana tha k • iss may kon si database design technique use hori • or iss ka second part yaad ni