12th Class Computer Science Chapter 6 Short Questions with Answers Online Preparation

Question # 1

Ans 1: Field size is used to set the number of characteristics needed in a text or number field. The default field size for the text type is 50 characters. If the records in the field will only have two or three characters, you can change the size of the field to save disk space or prevent entry errors by limiting the number of characters allowed.

Question # 2

Question # 3

Ans 1: A relationship is a powerful method for organizing your data. Using a relationship, you can join data in one or more tables based on common field values,different field values , or a comparison of values in two or more fields. It is important to note that whenever you want to use data from another table- either in a relational database or for a lookup --- you must first define a relationship between the two tables.

Question # 4

Ans 1: Datasheet View: To see many records of data in MS- Access at the same time, you use a Datasheet view. When you open a table or query using the database window, it will be displayed in datasheet view. A table or query is opened in Datasheet view to perform different operations on the data in the table such as displaying data, adding new data , searching data etc. The Datasheet view is like worksheet. When table is opened in Datasheet view, the field names are displayed as header of columns and each row contains a complete records.

Question # 5

Ans 1: 1) Creating Table in Design view
2) Creating Table by using wizard
3) Creating table by entering data

Question # 6

Ans 1: Sorting is a term to view records in a table in a different order than they appear such as sorting by dates or in alphabetical order. Follow these steps to sort records in table based on the value of one field.
1) In table view, place the cursor in the cursor in the column that you want to sort by.
2) Select Record | Sort | Sort Ascending or Record |sort| Sort Descending from the menu bar or click Sort Ascending or sort Descending buttons on the toolbar.

Question # 7

Ans 1: 1) High Speed
2) Well Defined Standards Exist \
3) No Coding Required
4) Emergence of RDBMS

Question # 8

Ans 1: Join are what make relationship work. With something like a flat-file, none of this is a concern to you . Of course, that's not necessarily good because you're probably more concerned with having hundreds or thousands more records than you actually need or can manage .

Question # 9

Ans 1: Filtering is useful way to see only the data that you want displayed. You can use filters to display specific records in a form, report, query, or datasheet or to print only certain records from a report, table , or query . By applying a filter, you are able to limit the data in a view without altering the design of the underlying object. There are the following method are available for filtering .
1) Filter by Selection
2) Filter by Form

Question # 10

Ans 1: IDE stands For Integrated Development Environment Information. It is an interface that is used to create a database. An IDE makes the using of database simple, manageable for end users who may not have a complicate programming Knowledge of the database system.