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

Question # 1

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

Question # 2

Ans 1: Following steps are to create a query in Design View.
1) From the queries page on the Database Window, click the 'New' button.
2) Select Design View and click Ok.
3) Select tables and exciting queries from the Tables and Queries Tabs and click the Add Button to add each one to the new query.
4) Click Close When all of the tables and queries have been selected.

Question # 3

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.

Question # 4

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 # 5

Ans 1: An OLE (Object Linking and Embedding) object is a sound, picture, or other object such as a Word document or Excel spreadsheet that is created in another program . Use this data type to embed an OLE object or link to the object in the database.

Question # 6

Question # 7

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 # 8

Ans 1: The number of field in a relation is called the degree of a table. Once the table is created, its degree usually does not change,e.g. A table with five fields has a degree of 5.

Question # 9

Ans 1: Degree of Relation: The number of field in a relation is called the degree of a table. Once the table is created, its degree usually does not change,e.g. A table with five fields has a degree of 5.
Ans 2: Cardinality of Relation: The Number of record in a relation is called the cardinality of the relation. The cardinality of a relation as new records are added or existing records are deleted, e.g a table with 50 record has a cardinality of 50

Question # 10

Ans 1: Following are two types of table views in MS-Access:

1)Design View : Design view allows you to define fields in the table before adding data to datasheet.
2) Datasheet View :When you open a table or query using the database window, it will be displayed in datasheet view.The Datasheet view is like worksheet.