📊 MySQL
Q. What will be the result of the following MySQL command?
SELECT emp_id,
‘ACTIVE’ STATUS,
emp_id * 3.14 emp_pi,
UPPER (lname) last_name
FROM employee;
  • (A) emp_id, ACTIVE, emp_id * 314, UPPER(lname)
  • (B) emp_id, Status, emp_pi, last_name
  • (C) Error
  • (D) None of the mentioned
💬 Discuss
✅ Correct Answer: (B) emp_id, Status, emp_pi, last_name

Explanation: This MySQL command is designed to retrieve information from a table named "employee". Let's break down what each part does:

Explanation by: Ranjeet
This MySQL command is designed to retrieve information from a table named "employee". Let's break down what each part does:

💬 Discussion

📊 Question Analytics

👁️
81
Total Visits
📽️
1 y ago
Published
🎖️
Ranjeet
Publisher
📈
86%
Success Rate