Question

MINO
B. State True or False:
1.
Queries help us to retrieve information from one or more tables that meet a specific condition.
2. Query window is divided into three parts.
3.
To specify multiple criteria, Or property is used.
4. We cannot run a query without saving it.
5.
The Sort property is used to filter the data either in ascending or descending order.
6.
Queries are used to explain the specific data.
7.
Once a relationship is set, it cannot be deleted.
C. Application Based Questions:
1. Swati created a database of her classmates and entered 30 records in it. The teacher asked he
data of those students who have scored less than 50% marks. Suggest the method to apply this​

Answer 1

Answer:

1.True

2.False

3.False

4.True

5.False

6.True

7.False

Answer 2

Answer:

Explanation:

1: True

Explanation: In SQL, Query helps to retrieve data from more than one table according to the given condition

2: False

Query windows has two parts, first is the design area and second is the grid.

3 :True.

It is true only if any one of the condition needs to be satisfied. If all the condition needs to be satisfied then we should use ‘and’ clause.

4: false

We can run a query without saving it.

5: True

The keyword orderby asc or desc makes the data to get sort in ascending or descending order.

6: False

It is used to fetch data from tables in the database.

7: false

Relationships can be set and unset.

Ans: Select id, name, subject, marks

from Marks

where ((Marks / 100 ) * 100)< 50