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

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

Try The Short Questions For ICS Part 2 Computer Science Chapter 6 Short Questions Preparation

Total Questions10
Available Sets2

Start Test Download PDF

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

Question # 1

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 .

Question # 2

List Some Advantages of Query.

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

Question # 3

Define Relationship.?

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

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

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

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

Write two table views in MS- Access.

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.

Question # 8

List two Disadvantages of integrated development environment .

Ans 1: 1) Learning Curve : IDEs are complicated tools. Maximizing their benefit will require time and patience.

2) Will Not Fix bad code, Practice : You still need to be proficient and meticulous. An IDE will not eliminate efficiency or performance problems in your application. IDEs are like paintbrushes. Whether you create a van Gogh or a Velvet Elvis is dictated by your skill and decisions.

Question # 9

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

Define Degree of Relation.

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.

Submit

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

Set 1

10 Questions
Start
Set 2

10 Questions
Start

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

Question # 1

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 .

Question # 2

List Some Advantages of Query.

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

Question # 3

Define Relationship.?

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

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

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

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

Write two table views in MS- Access.

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.

Question # 8

List two Disadvantages of integrated development environment .

Ans 1: 1) Learning Curve : IDEs are complicated tools. Maximizing their benefit will require time and patience.

2) Will Not Fix bad code, Practice : You still need to be proficient and meticulous. An IDE will not eliminate efficiency or performance problems in your application. IDEs are like paintbrushes. Whether you create a van Gogh or a Velvet Elvis is dictated by your skill and decisions.

Question # 9

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

Define Degree of Relation.

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.

Submit

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

Question # 1

List Some Advantages of Query.

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

Question # 2

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

What is the use of Input Mask?

Ans 1: An input mask controls the value of a record and set it in a specific format. They are similar to the format property , but instead display the format on the datasheet before the data is entered. For Example, a telephone number field can be formatted with an input mask to accept ten digits in the form "(555) 123-4567". The blank field would look like(_____)_____.

Question # 4

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

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

Name three methods for creating tables in MS-Access.

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

Question # 7

List Some Advantage of IDE .

Ans 1: 1) Less Time and Effort : The entire purpose of an IDE is to make developing faster and easier. Its tools and features are supposed to help you organized resources, prevent mistakes, and provide shortcuts.

2) Enforce Project or Company Standards : Simply by working in the same development environment ,a group of programmers will adhere to a standard way of doing things. Standard can be further enforced if the IDE offers predefined templates, or if code libraries are shared between different team members working on the same project.
3) Project Management : This can be twofold .First many IDEs have documentation tools that either automate the entry of developer comments, or many actually force developers too write comments in different areas.Second, simply by having a visual presentation of resources. It should be a lot easier to know how an application is laid out as opposed to traversing the file system for arcane files in the file system.

Question # 8

Write two table views in MS- Access.

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.

Question # 9

List two Disadvantages of integrated development environment .

Ans 1: 1) Learning Curve : IDEs are complicated tools. Maximizing their benefit will require time and patience.

2) Will Not Fix bad code, Practice : You still need to be proficient and meticulous. An IDE will not eliminate efficiency or performance problems in your application. IDEs are like paintbrushes. Whether you create a van Gogh or a Velvet Elvis is dictated by your skill and decisions.

Question # 10

Write the use of data sheet form.

Ans 1: Following steps are used to add record to a table in data sheet view
.
1) To add record to a table in datasheet view, open the desired table in date sheet view.
2)Click the "New Record" button at the right end of the record navigation button group. It is located in the lower left corner of the datesheet view. It is the button with the arrow and asterisk [*] on its face
3)d Then enter the information into the fields in the "New Records" row. It is the bottommost row in the datasheet view that display the asterisk [*] at the left end of the row.
4) When you have finished entering the new record, you can move down to enter the next new record into the new row that has appeared.
5) Close the table when you are finished adding records.

Submit

Computer Science

6th Chapter

12th Computer Science Chapter 6 Preparation

Here you can prepare 12th Computer Science Chapter 6 Problem Solving Preparation. Click the button for 100% free full practice test.

Start Chapter 6 Test

Chapter 1

Chapter 2

Chapter 3

Chapter 4

Chapter 5

Chapter 6

Chapter 7

Chapter 8

Chapter 9

Chapter 10

Chapter 11

Chapter 12

Chapter 13

Chapter 14

Short Questions
Ics Part 2

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

Define Join?

List Some Advantages of Query.

Define Relationship.?

What is OLE Object in MS- Access?

Difference between degree of relation and cardinality of relation.

Write down the use of filters in MS-Access.

Write two table views in MS- Access.

List two Disadvantages of integrated development environment .

Define Sorting.

Define Degree of Relation.

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

Define Join?

List Some Advantages of Query.

Define Relationship.?

What is OLE Object in MS- Access?

Difference between degree of relation and cardinality of relation.

Write down the use of filters in MS-Access.

Write two table views in MS- Access.

List two Disadvantages of integrated development environment .

Define Sorting.

Define Degree of Relation.

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

List Some Advantages of Query.

Define Sorting.

What is the use of Input Mask?

Difference between degree of relation and cardinality of relation.

What is OLE Object in MS- Access?

Name three methods for creating tables in MS-Access.

List Some Advantage of IDE .

Write two table views in MS- Access.

List two Disadvantages of integrated development environment .

Write the use of data sheet form.

12th Computer Science Chapter 6 Preparation

Is this page helpful?