12th Class Computer Science Chapter 06 MCQs with Answers

Welcome to the 12th Class Computer Science Chapter 06 MCQs Online Test. We are presenting you with top MCQ questions from the 12th Class Computer Science Chapter Table and Query.

We want to tell you that you can find all the 12th Class Computer Science Chapter 06 MCQs online tests on our website. These online tests are great for learning and as well as for scoring maximum marks in your Intermediate Exams. We are making these Class 12 Computer Science MCQs online tests for those who want full marks in their exams. Attempt all these Grade 12 Computer Science Online Multiple Choice Questions MCQs before going for the exam and it will be beneficial for you! These online tests contain all the important multiple choice questions in the important topics of the FSC Part-II  Computer Science Chapter 06 Table and Query. 

12th Class Computer Science Chapter 06 MCQs with Answers

Youth For Pakistan has provided an excellent opportunity for the students of the 12th class to prepare their Computer Science Chapter 06 Table and Query online with MCQs test.

This is a free platform for students to prepare for Computer Science Exams for Class 12 to get the best accomplishments in annual exams. 12th class Students can analyze themself by attempting this online test system as many times as they want until they find themself fully prepared.

MCQs Class 12 Computer Science with Answers

The purpose of these online MCQs tests is to help you evaluate your 12th Class Computer Science Chapter 06 MCQs. These Multiple Choice Questions (MCQs) will prepare you for your academic success in the 12th Class Exams. 12th Class Computer Science Chapters include Chapter No 1 Data basics, Chapter No 2 Basic Concepts And Terminology, Chapter No 3 Database Design Process, Chapter No 4 Data Integrity & Normalization, Chapter No 5 Introduction of Microsoft Access, Chapter No 6 Table and Query, Chapter No 7 Microsoft Access forms & Reports, Chapter No 8 Getting Started with C, Chapter No 9 Element Of C, Chapter No 10 Input/Output, Chapter No 11 Decision Constructors, Chapter No 12 Loop Constructors, Chapter No 13 Functions and Chapter No 14 File Handling in C. 

Table and Query

In the previous lesson, you learned how to create a simple query with one table. Most queries you design in Access will likely use multiple tables, allowing you to answer more complex questions. In this lesson, you’ll learn how to design and create a multi-table query.

Chapter No 6 Table and Query

1. The data in the table is entered in

1. Design View
2. Normal View
3. Datasheet View
4. Layout View

2. The rule that a record from a table cannot be deleted if its associated record exists in a related table is called _____rule

1. Referential Integrity
2. Entity-Relationship
3. Normalization
4. all of them

3. The fundamental concept of relational database is choose which one is correct:

1. Query
2. Table
3. Form
4. Record

4. The actual data of database is stored in choose which one is correct:

1. Query
2. Table
3. Forms
4. Report

5. is the object of MS-Access database file choose which one is correct:

1. Queries
2. Tables
3. Forms
4. All of these

6. In a relational database, a single piece of information is called choose which one is correct:

1. Field
2. Attribute
3. Entity
4. Both (a) & (b)

7. The number of fields in a relation or table is called choose which one is correct:

1. Degree of relation
2. Cardinality of relation
3. State of relation
4. None

8. Which of the following buttons of Find and Replace dialog box is clicked to start he search process choose which one is correct?

1. Find
2. Find Next
3. Search
4. Next

9. As in design view, you can move from field to field in the table window in datasheet view using ________button.

1. Tab
2. Esc
3. Enter
4. Spacebar

10. The number of records (or row) in a table or relation is called choose which one is correct:

1. Degree of relation
2. Cardinality of relation
3. State of relation
4. None

11. How may table view are available in MS-Access choose which one is correct?

1. 1
2. 2
3. 3
4. 4

12. The data in table is entered in choose which one is correct:

1. Design View
2. Normal View
3. Datasheet View
4. Layout View

13. The structure of table is designed in choose which one is correct:

1. Design View
2. Normal View
3. Datasheet View
4. Layout View

14. views can be used to add, edit, and delete records to and from the table choose which one is correct:

1. Design View
2. Record View
3. Datasheet View
4. Edit View

15. The relationship between countries and their capitals is an example of ________relationships.

1. One-to-one
2. one-to-many
3. Many-to-many
4. none of them

16. menus in MS-Access contains commands that can be used to switch between table views choose which one is correct?

1. File
2. View
3. Edit

17. The maximum length of text type field is choose which one is correct:

• 50 Characters
• 250 characters
• 155 characters
• 255 characters

18. is not an example of data type in MS-Access choose which one is correct:

1. Memo
2. Menu
3. Text
4. Currency

19. is the default data type in MS-Access choose which one is correct:

1. Memo
2. AutoNumber
3. Text
4. None of these

20. is the default field size of Text data type in MS-Access choose which one is correct:

1. 100
2. 50
3. 255
4. 150

21. In memo type field, more than ______ characters can be stored.

1. 64
2. 640
3. 6400
4. 64000

22. The structure of a table can be modified in

1. Datasheet View
2. Normal Layout
3. Design View
4. None of above

23. The maximum length of text type field is

1. 16 Characters
2. 255 characters
3. 64 Characters
4. 32 Characters

24. type of fields cannot be used as key field choose which one is correct:

1. Memo
2. AutoNumber
3. Text
4. Number

25. type of fields is used to store the URL address of website choose which one is correct:

1. Text
2. Hyper Link
3. OLE Object
4. Memo

26. can be used to define a field that can store picture, chart, or other graphic object choose which one is correct:

1. Text
2. Hyper Link
3. OLE Object
4. Memo

27. can be used to define a field that can create a sequence of number automatically choose which one is correct:

1. Currency
2. AutoNumber
3. Number
4. Memo

28. specifies the Field property choose which one is correct:

1. Default Value
2. Input Mask
3. Field Size
4. All

29. table views, Field properties are shown choose which one is correct:

1. Design View
2. Form
3. Datasheet View
4. Report

30. Which field is used to store URL address

1. Memo
2. Hyperlink
3. Text
4. OLE object

31. Which of the following type of queries is used to make changes in database choose which one is correct?

1. Parameter Query
2. Action Query
3. Select Query
4. Crosstab Query

32. field types can be indexed choose which one is correct:

1. Memo
2. Hyper Link
3. OLE Object
4. Number

33. The maximum length of a field name in MS-Access is _____ characters.

1. 64
2. 640
3. 6400
4. 64000

34. To find a four-characters name that starts with H, the criteria is specified as choose which one is correct:

1. H*4
2. H choose which one is correct?4
3. H
4. H###

35. manus contains Find and Replace commands choose which one is correct:

1. File
2. View
3. Edit
4. Tool

36. For which data user need not to enter data for that field

1. Number
2. Auto Number
3. Automatic Number
4. Auto

37. OLE stands for

1. Object Linking and Embedding
2. Object Like Embedding
3. Optional Link Encoding
4. None of Above

38. A ___________ will link to a website or another location in the database

1. Link
2. Network
3. Hyperlink
4. HTTP

39. buttons of Find and Replace dialog box is clicked to start the search process choose which one is correct:

1. Find
2. Find Next
3. Search
4. Next

40. In Design view, you can move from field to field in the Table window in Datasheet view using ______ button choose which one is correct:

1. Tab
2. Esc
3. Enter
4. Spacebar

41. An association established between common fields in two tables is called choose which one is correct:

1. Entity
2. Entity-Relationship Model
3. Relationship
4. Integrity

42. How many types of relationship are there choose which one is correct?

1. 2
2. 3
3. 4
4. 5

43. Arranging data or records of a table in a specific order i.e, in alphabetical or numeric order is called choose which one is correct:

1. Data sorting
2. Data Filtering
3. Data querying
4. All

44. is wildcard character choose which one is correct:

1. >
2. <
3. +
4. *

45. The optional information while creating a table in design view is

1. Field Data Type
2. Description
3. Field Size
4. Field Name

46. A value that is set automatically for a field if not value is given by the user is called

1. Automatic Value
2. Value
3. Natural Value
4. Default Value

47. _________controls the value of a record and sets it in a specific format

1. Field Validation Rules
2. Data Format
3. Input Mask
4. Indexes

48. ________ specify criteria for the data entered in the worksheet

1. Field Validation Rules
2. Data Format
3. Input Mask
4. Indexes

49. _________allow Access to query and sort records faster

1. Key
2. Primary Key
3. Index
4. All of Above

50. is wildcard character choose which one is correct:

1. choose which one is correct?
2. *
3. !
4. Both a and b

51. The resulting collection of records is called choose which one is correct:

1. Report
2. Query
3. Dynaset
4. Form

52. queries is used to perform calculations on the data of numeric fields choose which one is correct:

1. Select Query
2. Action Query
3. Parameter Query
4. Crosstab Query

53. is not an example action query choose which one is correct:

1. Select
2. Delete
3. Parameter
4. Convert

54. query is used to join two tables choose which one is correct:

1. Select
2. Delete
3. Parameter
4. Crosstab

55. query displays a dialog box to get information from user choose which one is correct:

1. Select
2. Delete
3. Parameter
4. Crosstab

56. Which menu is used to sort data in Microsoft Access

1. Tools
2. Data
3. Records
4. Query

57. Which sign is used for not equal to in Microsoft Access Filter

1. !=
2. Not =
3. Not Equal To
4. <>

58. The filtered contents of a filter in Microsoft Access can be saved as

1. File
2. Table
3. Sheet
4. Query

59. Criteria to find a word which starts with z and ends with c but can have any number of characters

1. z choose which one is correct?c
2. z&c
3. z#c
4. z*c

60. The __________ is specified in a table to avoid duplicate entries of records

1. Key
2. Field
3. Primary Key
4. All of Above