Question

C. Short answer questions (11).
1. How do you specify criteria in a query such that:
(a) All of them should work together
(b) Any one of them is sufficient
2. How can you compare numeric values in an SQL query?
3. How much storage space is taken by each of the following.
(a) Small Integer
(b) Big Integer
(c) Double
4. Give at least two examples of referential integrity from real world.
5. What are some fields that are part of the design grid when creating query in design view?​

Answer 1

Answer:

1. a)

2. SQL Greater than or equal to ( >= ) operator

The greater than equal to operator is used to test whether an expression (or number) is either greater than or equal to another one.

Answer 2

Explanation:

To add some criteria to a query, you must open the query in the Design View.

You then identify the fields for which you want to specify criteria.