📊 MySQL
Q. Which of the following MySQL statements is valid if '`sampledb`' is a database and '`tbl`' is a table in it?
  • (A) SELECT * FROM `sampledb.member`
  • (B) SELECT * FROM `sampledb`.`member`
  • (C) SELECT * FROM `member`.`sampledb`
  • (D) SELECT * FROM `member.sampledb`
💬 Discuss
✅ Correct Answer: (B) SELECT * FROM `sampledb`.`member`

Explanation: This question is about how to correctly reference a table within a database in MySQL. Imagine you have a bookshelf (`sampledb`) and a book (`tbl`) on it. We need to tell MySQL where to find that book.

Explanation by: Rakesh Kumar
This question is about how to correctly reference a table within a database in MySQL. Imagine you have a bookshelf (`sampledb`) and a book (`tbl`) on it. We need to tell MySQL where to find that book.

💬 Discussion

📊 Question Analytics

👁️
101
Total Visits
📽️
1 y ago
Published
🎖️
Rakesh Kumar
Publisher
📈
92%
Success Rate