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

Question # 1

What is OLE Object in MS- Access?

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

Define Integrated Development Environment (IDE).?

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

Difference between degree of relation and cardinality of relation.

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

What is the use of datasheet view in MS-Access?

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

Create a query in Design View .

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

Define Sorting.

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

List of Field Properties ?

Ans 1: 1) Field Size
2) Byte
3) Integer
4) Long Integer
5) Single
6) Double
7) Decimal
8) Format
9) Number Format
10) Currency Format
11) Date Format
12) Yes/No

Question # 8

List Some Advantages of Query.

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

Question # 9

Write down the use of filters in MS-Access.

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

Define Join?

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 .

Latest Educational News Stories

Pakistan's Largest Database of Colleges and Universities

BS Programs

University Past Papers

University Results

Exam Results 2024

Study Abroad Programs and Opportunities for Pakistani Students

ICS Part 2 Computer Science Chapter 6 Short Questions Test With Answer

Online Short Questions For Chapter 6 "ICS Part 2 Computer Science Chapter 6 Short Questions Preparation "

Computer Science - ICS Part 2 Computer Science Chapter 6 Short Questions Preparation

What is OLE Object in MS- Access?

Define Integrated Development Environment (IDE).?

Difference between degree of relation and cardinality of relation.

What is the use of datasheet view in MS-Access?

Create a query in Design View .

Define Sorting.

List of Field Properties ?

List Some Advantages of Query.

Write down the use of filters in MS-Access.

Define Join?

Prepare Complete Set Wise Questions For Chapter 6 "ICS Part 2 Computer Science Chapter 6 Short Questions Preparation "

Set 1

Set 2

ICS Part 2 Computer Science Chapter 6 Short Questions Preparation - Set 1

What is OLE Object in MS- Access?

Define Integrated Development Environment (IDE).?

Difference between degree of relation and cardinality of relation.

What is the use of datasheet view in MS-Access?

Create a query in Design View .

Define Sorting.

List of Field Properties ?

List Some Advantages of Query.

Write down the use of filters in MS-Access.

Define Join?

ICS Part 2 Computer Science Chapter 6 Short Questions Preparation - Set 2

Write two table views in MS- Access.

What is the use of Input Mask?

List of Field Properties ?

List Some Advantages of Query.

Write the use of data sheet form.

Name three methods for creating tables in MS-Access.

Difference between degree of relation and cardinality of relation.

What is the use of datasheet view in MS-Access?

Define Relationship.?

Define Sorting.

12th Computer Science Chapter 6 Preparation