Class VII Computer 3rd UT PDF

Class VII Chapter 8 A. Tick () the correct one. 1. DBMS is the acronym for a. Data basic Management System b. Database Management System c. Data broad Management System Ans: b. Database Management System 2. Which among the followin...

Class VII Chapter 8 A. Tick () the correct one. 1. DBMS is the acronym for a. Data basic Management System b. Database Management System c. Data broad Management System Ans: b. Database Management System 2. Which among the following statements is not true about DBMS? a. It is an interface between the databases and the users. b. It consists of a set of programs using which one can create, extract, edit and update the database. c. It is a part of the Microsoft Office Suite. Ans: c. It is a part of the Microsoft Office Suite. 3. Which among the following is not a DBMS? a. MS-Excel b. Oracle c. MySQL Ans: a. MS-Excel 4. What does R in 'RDBMS' stand for? a. Rotational b. Relational c. Redundancy Ans: b. Relational 5. The chance of duplication of data is nil as the data are recorded in only one place in the database. which among the following clearly defines the above? a. DBMS controls data redundancy. b. DBMS provides data consistency. c. DBMS Provides data independence. Ans: a. DBMS controls data redundancy. B. Fill in the blanks. 1. Database is a collection of data and information organised in a systematic manner. 2. The set of data which gives information about other data is known as metadata 3. DBMS is an application software for creating and managing databases. 4. Field is a column in the table which contains only one type of information. 5. Module are collections of programs which are written to access database. C. State True or False. 1. MS-Access 2013 is a part of the Microsoft Office Suite. True 2. DBMS enhances redundancy of data in the database. False  3. The users cannot manipulate the databases. False 4. The data can be secured in the databases by applying locks using keys. True 5. MS-Access allows linking of data in the database. True D. Match the following. Column A Column B 1. Data a. A set of related fields 2. Files b. A file in the database in the form of rows and columns 3. Record c. Collection of related records 4. Ribbon d. Raw facts and figures 5. Tables e. Component of Access window which consists of the basic commands needed for completing a particular task Column A Column B 1. Data d. Raw facts and figures 2. Files c. Collection of related records 3. Record a. A set of related fields 4. Ribbon e. Component of Access window which consists of the basic commands needed for completing a particular task 5. Tables b. A file in the database in the form of rows and columns Class VII Chapter 9 A. Tick () the correct one. 1. 1.How many digits to the right of the decimal point can the currency data type store? a. 15 b. 4 c. 19 Ans: b. 4 2. Which data type generates a unique number for each new record? a. OLE Object b. Attachment c. AutoNumber Ans: c. AutoNumber 3. OLE is the acronym for a. Object Lined Electronically b. Object Line and Embedding c. Object Linking and Embedding Ans: c. Object Linking and Embedding 4. For Yes/No data type, the numeric value which is stored for False is a. 0 b. 1 c. -1 Ans: a. 0 5. To add a new column after you have typed in the last field of the record, press the____ key on the keyboard. a. Tab b. Shift c. Enter Ans: a. Tab B. Fill in the blanks. 1. Data Types are used to declare the fields of a table. 2. To move the fields in the table, Design view is used. 3. Long text data type was formerly called Memo 4. A primary key is a special feature of Relational Database Management System. 5. The keyboard shortcut to save the table is Ctrl +S C. State True or False. 1. Short text is used for those text fields which do not require any calculations. True 2. Design view is the default view of MS-Access. False 3. OLE Object is used to store pictures, graphs, etc. from another Window-based application. True 4. Primary key ensures that there is no data redundancy inside a table. Ture 5. The users cannot remove the primary key from the fields. False D. Match the following. Column A Column B 1. OLE Objects a. Up to 8,192 2. Currency b. 4 bytes 3. Yes/No c. Up to about 2 GB 4. AutoNumber d. 8 bytes 5. Hyperlinks e. 1 byte Column A Column B 1. OLE Objects c. Up to about 2 GB 2. Currency d. 8 bytes 3. Yes/No e. 1 byte 4. AutoNumber b. 4 bytes 5. Hyperlinks a. Up to 8,192 Class VII Chapter 10 A. Tick () the correct one. 1. Which tab is used to set a relationship among the tables? a. Database Tools b. Create c. External Data Ans: a. Database Tools 2. Primary key of one table is a ________ key for another table. a. secondary b. tertiary c. foreign Ans: c. foreign 3. Query Design option is available under ________ tab. a. Create b. Database Tools c. External Data Ans: a. Create 4. Which among the following views of the form is used to change the look of the form? a. Form View b. Layout View c. Design View Ans: b. Layout View 5. Which among the following is used for printing? a. Forms b. Reports c. Query Ans: b. Reports B. Fill in the blanks. 1. To create a form, create tab is accessed. 2. The relationship between two tables is shown by a Linking line. 3. Crosstab query is used to aggregate the data across rows and columns. 4. Arrange and Format tabs appear in the MS-Access ribbon after a form is created. 5. The Bottom pane of the Query Design View displays the design grid. 6. The top pane of the Query Design View shows the Table(s) selected for the query. C. State True or False. 1. we cannot edit the tables once a relationship is set between them. False 2. Append query deletes records from one database table to another database table. False 3. Creating forms enables easy and convenient entry of data. True 4. Using reports, the users can create labels. True 5. There are three views for forms. True 6. Reports provide detailed look of each record. True D. Match the followings Column A Column B 1. Fields a. A row which displays the names of the tables from which the fields are selected 2. Show b. A row which holds the conditions on the basis of which the records will be sorted 3. Table c. A row which is used to sort the data in ascending/descending order 4. Criteria d. A row which displays the selected fields from the table 5. Sort e. A row which displays the check marks Column A Column B 1. Fields d. A row which displays the selected fields from the table 2. Show e. A row which displays the check marks 3. Table a. A row which displays the names of the tables from which the fields are selected 4. Criteria b. A row which holds the conditions on the basis of which the records will be sorted 5. Sort c. A row which is used to sort the data in ascending/descending order Class VII Chapter 11 A. Tick () the correct one. 1. Which tag contains all the content of the document? a. b. c. Ans: c. 2. GIF stands for a. Graphics Interchange Format b. Graphics Internal Format c. Grade Interchange Formulae Ans: a. Graphics Interchange Format 3. Which among the following is not a type of marker in the unordered list? a. Square b. Rectangle c. Circle Ans: b. Rectangle 4. Which among the following tags is used for defining the definition of the defined term in tag a. tag b. tag c. tag Ans: b. tag 5. What does tag stand for? a. Anchor b. Arrow c. Anti Ans: a. Anchor B. Fill in the blanks. 1. tag is often used in glossaries to define many terms. 2. tag is used to format a segment of text by changing its appearance. 3. The data in tag and tag is defined by the. 4. HREF attribute of the tag indicates the destination of the link. 5. ALT attribute specifies an alternate text for the image. C. State True or False. 1. HTML is a scripting language which is used to create structured documents. False 2. tag is used to display the text as superscript. False 3. The ordered list can be only numerical. False 4. A nested list is a combination of two or more lists. True 5. The tag does not have a closing tag. True  D. Match the following Column A Column B 1. BgColor a. This attribute is used to change the type of font of the text 2. Face b. This attribute sets how the text will be scrolled within the marquee 3. Noshade C. This attribute is used to specify the URL of the image 4. Src d. This attribute defines the background colour of the web page 5. Behaviour e. This attribute specifies that the horizontal rule should render in one solid line Column A Column B 1. BgColor d. This attribute defines the background colour of the web page 2. Face a. This attribute is used to change the type of font of the text 3. Noshade e. This attribute specifies that the horizontal rule should render in one solid line 4. Src C. This attribute is used to specify the URL of the image 5. Behaviour b. This attribute sets how the text will be scrolled within the marquee Class VII Chapter 12 A. Tick() the correct one. 1. Which attribute defines the background colour of rows and columns? a. BgColor b. BackgroundColor c. BorderColor Ans: a. BgColor 2. Which tag defines the table column? a. b. c. Ans: c. 3. Which attribute is responsible for adding more space inside each cell? a. Cellspacing b. Cellpadding c.Valign Ans: b. Cellpadding 4. Which among the following attributes extends the cells vertically? a. Rowspan b. Colspan c. Align Ans: a. Rowspan 5. Which among the following is not a set value of align attribute? a. Left b. Right c. Bottom Ans: c. Bottom B. Fill in the blanks. 1. The filename extension of HTML documents is.html /.htm. 2. The content of the data cell is known as table data 3. A value of zero indicates that there is no border. 4. Align attribute defines the position of the table with respect to web browser's window pane. 5. Border specifies the width of the border which forms around the table. C. State True or False. 1. HTML tags are displayed in the web pages. False 2. tag is used to define the data cell. False 3. Cellspacing attribute specifies the space between the cell border and cell contents. False 4. We can change the background colour of the table but not the colour of the border of the table. False 5. Colspan attribute's value is set as Left or Right. True D. Match the following. Column A Column B 1. It defines the background colour of rows and columns a. Height 2. It defines the height of the rows b. Align 3.It defines the alignment of the cell contents vertically c. BgColor 4.It defines the alignment of the cell contents horizontally d. Rowspan 5.It extends the cells vertically e. Valign Column A Column B 1. It defines the background colour of rows and columns c. BgColor 2. It defines the height of the rows a. Height 3.It defines the alignment of the cell contents vertically e. Valign 4.It defines the alignment of the cell contents horizontally b. Align 5.It extends the cells vertically d. Rowspan