Q. What will be the output of the following MySQL command?
SELECT fname
FROM person
WHERE emp_id != 6 OR emp_id IS NULL;

  • (A) Only those names whose emp_id is not equal to 6 or emp_id with NULL values
  • (B) read_buffer_size
  • (C) Only those names whose emp_id is equal to 6
  • (D) None of the mentioned
πŸ’¬ Discuss
βœ… Correct Answer: (A) Only those names whose emp_id is not equal to 6 or emp_id with NULL values
Explanation: This MySQL command is used to retrieve the 'fname' (first name) from the 'person' table.
Explanation by: Neelam Mittal
This MySQL command is used to retrieve the 'fname' (first name) from the 'person' table.

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
111
Total Visits
πŸ“½οΈ
1 y ago
Published
πŸŽ–οΈ
Neelam Mittal
Publisher
πŸ“ˆ
87%
Success Rate