Programming MCQ

Correct answer: Forgetting the WHERE clause. Without WHERE, UPDATE modifies every row in the table.

Correct answer: Only rows with matches in both tables. INNER JOIN intersects the tables on the join condition.

Correct answer: LEFT JOIN from categories. LEFT JOIN preserves unmatched left-side rows with NULLs.

Correct answer: How many questions exist per category. GROUP BY buckets rows; aggregates summarise each bucket.

Correct answer: Filters groups after aggregation. WHERE filters rows first; HAVING filters the grouped results.

HTML, CSS, JavaScript, PHP and MySQL programming questions.

Q61. The catastrophic mistake in UPDATE statements is: Medium

Permalink →

Q62. An INNER JOIN returns: Medium

Permalink →

Q63. To list ALL categories including those with zero questions, use: Medium

Permalink →

Q64. COUNT with GROUP BY answers questions like: Medium

Permalink →

Q65. HAVING differs from WHERE because HAVING: Medium

Permalink →

Q66. An index on a column mainly improves: Medium

Permalink →

Q67. WHERE fee > (SELECT AVG(fee) FROM students) demonstrates: Medium

Permalink →

Q68. A VIEW is best described as: Medium

Permalink →

Q69. CASE WHEN inside SELECT produces: Medium

Permalink →

Q70. A backup becomes trustworthy only when: Medium

Permalink →

🎯 Want a real test?

Take a timed quiz on this topic and see your rank on the leaderboard.

Browse Quizzes