Question

1. Select the wildcard character that enables the display of ALL fields (columns) in a table.

   $, %, *, or /*
2. Choose the WHERE clause that selects records with salary between 50000 and 75000 (inclusive).

WHERE salary >= 50000

OR salary <= 75000.

WHERE salary >= 50000

AND salary <= 75000

WHERE salary > 50000

OR salary < 75000

WHERE salary > 50000 AND salary < 75000

Answer 1

Ans: Select * from table_name where salary>=50000 AND salary <=75000

Explanation:

Using character * with SELECT returns all the columns of the table.

For ex: SELECT * from employee;

This statement returns all the columns of the table 'employee'.

According to question,

We have to choose the appropriate WHERE clause that selects records with salary between 50000 and 75000 (inclusive).

Here, inclusive means salary range will definitely include the boundary values 50000 & 75000 and the values between them.