Page 253 - Computer - 10(A&B)

Competency Based Questionsency Based Questions
Compet

1. Sonia is working in Base with multiple tables. She wants to extract or retrieve information from one or
more tables of the database that satisfy a specific criteria. Which of the following objects will be helpful to
her?
a. Reports b. Forms c. Queries d. Tables
2. Soham is working as a Data Analytics Engineer in a software company. He wants to present the data
stored in tables or queries in a printable format to perform different types of data analysis on the extracted
information. Which option would he use to do so?

a. Forms b. Reports c. Queries d. Tables
3. Subin created a table for employees in Base. He wants to make the employee id, a unique identifier in the
table. Which option would he use?
a. Assign Primary Key to the field ‘Employee Id’ b. Create query on the field ‘Employee Id’

c. Generate report on the field ‘Employee Id’ d. None of these
4. Bhavya has created a table ‘Marks’ in Base. She wants to arrange all the marks either in ascending order
or in descending order. Which feature will be useful to her?
a. Filtering b. Retrieving c. Sorting d. Arranging
5. Rohit has written a query in Base and wants to specify the query condition on the basis of which the
records will be filtered. Help him to choose the correct option for the same.

a. Field b. Sort c. Visible d. Criterion

Asserti
Assertion Reason Based Questionon Reason Based Question
In the following questions, a statement of Assertion (A) is followed by a statement of Reason (R). Choose
the correction option:
(a) if both A and R are true, and R is the correct explanation for A.

(b) if both A and R are true, but R is not the correct explanation for A.
(c) if A is true and R is false.
(d) if A is false and R is true.
1. Assertion: Database tables are properly organized, readable, and searching data can be carried out
efficiently.
Reason: Data redundancy and inconsistency can be maximized in a database.
2. Assertion: A primary key is a field that uniquely identifies a row in a table.
Reason: The primary key stores unique data values for a field.

3. Assertion: Queries are used to retrieve and display data from one or more tables in a database.
Reason: Queries help us to specify the fields that we want to display and also the criterion based on
which the records to be filtered.
4. Assertion: Forms provides a graphical, interactive way to manage data present in a table or a query.
Reason: Forms contain controls which can be formatted or customised easily.

135