SQL Queries | MCQs

    Q1: Which of the following is correct SQL query to get records of clerks from EMP table?

    ایم پی ٹیبل سے کلرکوں کے ریکارڈ حاصل کرنے کے لئے مندرجہ ذیل میں سے کون سا صحیح ایس کیو ایل استفسار ہے؟
    • A. None of these
    • B. SELECT * FROM EMP WHERE Job == 'Clerk';
    • C. SELECT ALL FROM EMP WHERE Job = 'Clerk';
    • D. SELECT * FROM EMP WHERE Job = 'Clerk';

    Q2: Why the following statement is erroneous? SELECT dept_name, ID, avg (salary) FROM instructor GROUP BY dept_name;

    • A. Dept_id should not be used in group by clause
    • B. Group by clause is not valid in this query
    • C. None
    • D. Avg(salary) should not be selected

    Q3: In which method we don't need to specify the field type and size while creating a new Table?

    • A. While using Wizard
    • B. Design View
    • C. none
    • D. CreateTable By Entering Data
✅ Correct: 0 | ❌ Wrong: 0 | 📊 Total Attempted: 0