12th Class Class Computer Mcqs Chapter No 6 | 2nd Year Computer Mcqs Chapter Wise Pdf

by
Print/Downlaod pdf

Chapter No 6

Table and Query

1. The data in 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 

<Previous Chapter
Take Quiz No 6
Next Chapter >

Post Views: 682