Page 382 - TP_IT_V1.0_C10_flipbpookl
P. 382

9.  What is the significance of Default Value in field properties window?
                10.  Differentiate between Design View and Datasheet view.
              B.  Long answer type questions.
                 1.  Explain any four advantages of a DBMS.
                 2.  How many types of relationships can be created in Base? Explain each of them.      [CBSE Handbook]
                 3.  List different ways of creating tables in a database.
                 4.  What do you mean by Sorting? In how many ways can it be done?                      [CBSE Handbook]
                 5.  How to open an existing table in a database? Give two ways to do this.
                 6.  Differentiate between Forms and Reports.
                 7.  Write the function of Forms Controls toolbar.
                 8.  Explain any two types of relationships.
                                                                                          21 st   #Communication
              C.  Competency-based/Application-based questions.                        Century   #Leadership & Responsibility
                                                                                         Skills
                 1.  Ananya wants to use a database in her bookshop. Suggest a database object to do the following:
                    a. To store the information of the total stock in the tabular form.
                    b. Design an interactive screen to enter and display the information.
                    c. Create a report of stock available in her bookshop.
                    d. Wanted to create a query based on a criteria.
                 2.  Ridhi wants to create multiple tables in a database and manage her data in her company. She wants to do a lot of other
                    things using the tables. Help her to do the following:
                    a. Name two different ways of creating a form in a table.
                    b. How can she create a Relationship between two tables?
                    c. What are reports in a database?
                    d. Name any one way of creating a report.
                  Assertion and Reasoning Questions:
                  Direction: Questions 3-4, consist of two statements – Assertion (A) and Reasoning (R). Answer these questions selecting the
                  appropriate option given be-low:
                    a. Both A and R are true and R is the correct explanation of A.
                    b. Both A and R are true but R is not the correct explanation of A.
                    c. A is true but R is false.
                    d. A is false but R is true.
                 3.  Assertion (A): A primary key uniquely identifies each record (row) in a table.
                    Reasoning (R): Referential integrity is a fundamental rule in relational databases that ensures the consistency and validity
                    of relationships between tables.
                 4.  Assertion (A): Relational databases are the most widely used database model.
                    Reasoning (R): Relational databases organise data into tables consisting of rows and columns, and use SQL for managing
                    and querying data.
                  Statement Based Questions:
                   Two statements are given . Statement 1 and Statement 2 . Examine the statements and answer the question according to the
                  instruction given below.
                    a. Statement 1 is TRUE , Statement 2 is TRUE
                    b. Statement 1 is FALSE , Statement 2 is False
                    c. Statement 1 is TRUE , Statement 2 is False
                    d. Statement 1 is FALSE , Statement 2 is TRUE
                 5.  Statement 1: The VARCHAR data type can store a variable length of characters up to a specified limit.
                    Statement 2: The CHAR data type is used to store variable length characters.


                380   Trackpad Information Technology (Ver. 1.0)-X
   377   378   379   380   381   382   383   384   385   386   387