Multiple choice technology

Consider an EMP table having data as follows: EMPNOEMPNAME 1000SOPHIA 1001RITA 1002MARY Which of the following SQL query will fetch all columns with name RITA only?

  1. SELECT FROM EMP WHERE EMPNAME='RITA';

  2. SELECT FROM EMP MATCHING EMPNAME='RITA';

  3. SELECT * FROM EMP WHERE EMPNAME='RITA';

  4. SELECT # FROM EMP MATCHING EMPNAME='RITA';
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SELECT * FROM EMP WHERE EMPNAME='RITA' correctly uses * for all columns and proper WHERE clause syntax. Options A and B are missing the * for all columns, while 'MATCHING' is not valid SQL syntax - WHERE clause should be used for filtering.

Keep practicing — related questions