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

Question # 1

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

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

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

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.

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

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

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

What is the use of field size property?

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

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

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.

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 Relationship.?

Create a query in Design View .

Define Join?

Define Degree of Relation.

Difference between degree of relation and cardinality of relation.

List two Disadvantages of integrated development environment .

What is the use of Input Mask?

What is the use of field size property?

Define Integrated Development Environment (IDE).?

Write two table views in MS- Access.

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 Relationship.?

Create a query in Design View .

Define Join?

Define Degree of Relation.

Difference between degree of relation and cardinality of relation.

List two Disadvantages of integrated development environment .

What is the use of Input Mask?

What is the use of field size property?

Define Integrated Development Environment (IDE).?

Write two table views in MS- Access.

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

Difference between degree of relation and cardinality of relation.

What is the use of Input Mask?

Write the use of data sheet form.

List Some Advantages of Query.

Write down the use of filters in MS-Access.

Define Integrated Development Environment (IDE).?

Define Degree of Relation.

List of Field Properties ?

List Some Advantage of IDE .

Write two table views in MS- Access.

12th Computer Science Chapter 6 Preparation

Is this page helpful?