Friday, June 23, 2017

MCQ - MS ACCESS - SEE 2074 [COMPUETR SCIENCE]



1.      What is extension of access database? (MS-Access 2003 version)
DBF                       MDB                MBD                DBM
2.      _____ is the table design creating option to create custom table design.
Datasheet                Design view                  Wizard             Link Table
3.      Object primarily used to store the data in database.
Table                      Form                Query               Report
4.      A field name can be up to _____ characters long.
40                          46                    64                    2048
5.      _____ is a data type used for lengthy text and numbers
Text                       Long Text                     OLE Object                  Memo
6.      Data type that requires 8 bytes of storage.
Yes/No                   Currency                       Long Integer                 All of them
7.      The name of caption can be declared up to _____ characters.
1024                       2024                             2048                             2005
8.      Memory space used by a auto number data type is _____
1 Byte                    2 Bytes                         4 Bytes                         8 Bytes
9.      The primary key contains _____ value.
Null                        No Null                                    Number                  Auto number
10.   Which specifies the expression that checks the invalid data.
Validation Rule                   Validation Text             Input Mask       Required
11.   _____ is not a field property of MS-Access.
Caption                   Index                            Color                            Format
12.   Format symbol that converts all characters to uppercase.
@                           &                                 <                                  >
13.   What kind of data is kept in memo field?                                                     
(i) Hyperlink        (ii) Software      (iii) Data           (iv) Pictures
14.   What is the extension of database file in Access?                                          
(i) .DB                 (ii) .MDB                     (iii) .DBF          (iv) .ADB
15.   What is the default size of Access?                                                  
(i) 10                (ii) 20               (iii) 30              (iv) 50
16.   Which is not the database?
i. Phone diary                      ii. Mark ledger  iii. Attendance Register    iv. Report Card
17.   MS-Access is a software.
i. Utility                  ii. Application               iii. System        iv. None of the above.
18.   Which is DBMS?
i. Database              ii. Metabase                  iii. dBase          iv. MS-Excel.
19.   __________uniquely identifies records of a table.
i. Foreign key                      ii. Primary key               iii. Field name  iv. Composite key
20.   The object of MS-Access that stores data is known as________
i. Query                  ii. Table                        iii. Form                       iv. Report
21.   Which of the following is not the data type used in MS-Access?
i. Date/Time                        ii. Counter                    iii. Hyperlink                iv. Caption
22.   The object of MS-Access that is used to prepare read-to-print document is_________
i. Query      ii. Table            iii. Form           iv. Report
23.   The Date/Time fields data type occupies_ Bytes of memory.
i. 4             ii. 2                  iii. 8                 iv. 16
24.   The extension of database file in MS-Access  is_____________
i. .DBF                   ii. .DMB           iii. .MDB          iv. DMB
25.   A field property that limits the data to be entered in a field is___________
i. Validation Rule    ii. Format                      iii. Input Mask              iv. Indexed
26.   Which is the subtype of number data type?
i. Integer                 ii. Byte                         iii. Single                      iv. All of the above.
27.   __________allows MS-Access to query and sort record faster.
i. Sorting                ii. Editing                     iii. Filtering                   iv. Indexing
28.   The maximum number of characters that can be stored in a field is determined by_
i. Field Type                       ii. Field Size                 iii. Field Length iv. Field width
29.   The logical field data type of MS-Access is______________
i. Yes/No                ii. True/False                 iii. On/Off                     iv. All of the above.
30.   The field size of logical field data type is __________ in MS-Access.
i. 1 bit                                ii. 1 byte                       iii. 2 bytes                     iv. 2 bits
31.   A (n) ____________________ is an organized collection of the related information.
            Object              database            Property                        document
32.   Field size, format, input mask, caption and default values are:
            Key elements                field properties              Navigating modes          data types
33.   The storage size of date/time type is
            4 bytes              1 bytes              8 bytes              16 bytes
34.   The _________________ key uniquely identifies each record
            Primary            database                        Object              premier
35.   ___________________ is a set of rules used by Access to ensure that the relationships between tables are valid and that the related data is not accidentally changed or deleted.
            Relationship                  Referential integrity                   Query               Forms
36.   __________________ is an Access databases objects that information in a printed format.
            Table                Form                Query               Report
37.   A Database Management System can be used to                               .
i. retrieve information          ii. search information    iii. sort information   iv. all of the above
38.   The storage size of date and time is                        .
i.4 bytes                  ii.6 bytes           iii.8 bytes          iv.12 bytes
39.   The data type appropriate to store address is                   .
i. Memo                  ii. Currency                   iii. Text                         iv. Auto number
40.   The object of MS-ACCESS that issued to present the data stored in tables or queries in a printed form.
i. Query                  ii. Table                                    iii.Form                                    iv. Report
41.   A collection of records for a single subject, such as all of the customer records.
i. Field                    ii. Record                      iii. Table                      iv. Data
42.   Which of the following is not a data type in Microsoft Access?
i. Text                      ii. Currency                  iii. Hypertext                 iv. Date/Time
43.   A                            key is a field that uniquely identifies a record.
i. Candidate             ii. Alternate                  iii. Primary       iv. Foreign
44.   What is the extension of Access database file?
i. .MBD                  ii..MDB            iii..DBF            iv..DFB
45.   The logical data type of access is                     .
i. Yes/No                ii. True/False                 iii. On/Off         iv. All of the above
46.   Primary key does not accept                             .
i. Text                   ii. Number                      iii. Null value             iv. None of the above
47.   Field name can be up to                    characters long.
i.64                         ii.16                 iii.128                           iv.40
48.   The default field size of “AutoNumber” data type is                 .
i. Byte                    ii. Integer                      iii. Long Integer                        iv. Long Integer
49.   An                                              is an organized collection of related information.
                        i) object                          ii) database           iii) property                  iv) document
50.   The maximum text field size in Access is 
                         i)50                         ii)256                             iii)10                     iv)255
51.   Uniquely identifies any field.
                           i)Index                   ii)Memo field                 iii)Primary key                 iv)Query
52.   The object of Access that stores the data the data is known as
                           i) Query                  ii)Table                      iii)Form                              iv)Report
53.   Which of the following is not MS-Access database object?
i. Table                      ii. Form                     iii. Query                         iv. Print
54.   Which of the following data type is appropriate to store gender of person in terms M or F?
i. Memo                    ii. Currency              iii. Yes no                         iv. Auto number
55.   Form is designed for
i. filters data              ii. Sort data               iii. Sort data                      iv. Modify data
56.   Query is used to
i. retrieves data from database          ii. Create table in database    iii. Print database      iv. All  
57.   Report is used for
i. Printing database               ii. Process database     iii. Filter database           iv. None
58.   Which of the following is not a data type?
i. Picture                  ii.date/time                  iii.text                              iv.number
59.   What is the maximum length of text field?
i.512 characters            ii.50 characters         iii. 255 characters        iv.No limit
60.   Which of the following is not field property?
i. indexed               ii. Field size                 iii.color                            iv.format
61.   What field type is used to store picture in a table?
i.memo                  ii.OLE                          iii.hyperlink                     iv.None
62.   Which of the following uniquely identifies any field.
i.Index                  ii.Memo                      iii.Primary key                 iv.Query
63.   The object of MS-Access that stores the data is known as
i.Query                 ii.Table                        iii.Form                            iv.report
64.   Which is the example of Relational Database Management System?
i.Oracle                ii.FoxBASE                  iii.Sybase                          iv.FoxPro
65.   The datatype which is used for only integer value.
i.text                     ii.currency                    iii.number                         iv.OLE
66.   What kind of data are kept in memo field?
i.Name of Student     ii.Students phone number     iii.Students Bio data     iv.Students picture
67.   Which of the following is not the datatype of MS-Access?
i.yes/no                ii.true/false                   iii.on/off                               iv.All
68.   A field is also known as
i.records               ii.column                     iii.Database                          iv.entity
69.   Which of the following field property limits from wrong data entry.
i.Input mask         ii.caption                     iii.required                            iv.validation rule
70.   The default field size value of text field is ___________.
40              50                    256                   64
71.   Which component of MS-Access is used to enter data?
Query                     Forms               Report              Both (i) and (ii)
72.   __________ is a Database Management System.
DBase                    MSAV              EXCEL            All of above
73.   A column in MS-Access Table is __________
Field                       Query               Database           Record
74.   MS-Access is a
DBMS                    RDBMS           Database           Metabase
75.   A row in a table is known as _____________.
Field                       Content             Record              Text table
76.   Which is the database?
Data of SLC Exam  Oracle              MS-Access                   Excel
77.   A key which uniquely identifies each record of a table is ____________.
Primary key            Foreign key       Both (i) and (ii)             None of above
78.   Field size of logical field is __________ in Access.
1 bit                       1 byte               8 byte               0 bit
79.   Which component of MS-Access is used to print data?
Query                     Form                Report              None
80.   MS-Access is used to create _____________.
Database     DBMS              Record              Table
81.   A caption can have maximum of __________ character.
2062                       2048                 64000               2006
82.   The logical data type of Access is __________
Yes/No                   True/False         On/Off              All
83.   What is the extension of Access database?
MBD                      MDB                DBF                 ADB
84.   Number field is used for storing only _______________.
Number      Text and Number          Number and Time         Number and Year
85.   ___________ is not DBMS.
Oracle                    dBase               FoxPro             Paint
86.   MS-Access is a kind of ______________.
System Software     Operating System          Application Software     Utility Software
87.   Which is an example of database?
DBase                    MS-Access       Telephone Directory      All
88.   Report is the printed output we generate from _______________.
Table                      Query               Forms               Both (i) and (ii)
89.   Which of them is not a data type?
Memo                     Yes/No             Time/Date         Caption
90.   Which is the subtypes for the number data type?
Hyperlink   Bit                    Index                Integer
91.   The maximum size of the text field is _______________.
253             255                   256                   254
92.   database is a
i.tool of editing documents               ii. way to automate common tasks
ii. collection of related information
93.   a collection of records for a single subject,such as all of the customer record is called 
i.Field                     ii.Record                       iii.Table
94.   which of the following is not a datatype
i. text                      ii.currency                    iii.hypertext
95.   ………….. are web pages that allow you to view and work with data that is stored in an access database on the internet
i.form                     ii.data access page                     iii. module
96.   …………… defines a standard pattern for the appearance of all data entered in the field
i.format                  ii.input mask                 iii.default value
97.   a …………. Key is a field that uniquely idectifies each record
i.candidate              ii.alternate                     iii.primary
98.   A report is a
i.printed version of the data in a database                  ii.way of sorting and filtering data
iii. tool that deletes information in your database
99.   The logical data type of MS-ACCESS is
i. Yes/ NO              ii. On/Off          iii. True/False    iv. All
100.          Which is the example of database?
i. dBASE    ii. MS-ACESS  iii. Telephone directory  iv. All
101.          Primary key does not accept
i. Text                    ii. Number        iii. Null value    iv. None
102.          Which component of MS-ACCESS does not allow entering data?
i. Table                   ii. Query                       iii. Form           iv. None of them
103.          …………… is not the data type of MS-Access.
i) Number   ii) Text             iii) Memo         iv) Form
104.          …………… is the DBMS.
i) Fox-Pro   ii) MS-Excel                 iii) Lotus-123    iv) All of the above
105.          Primary key does not accept ……………
i) Text                    ii) Number        iii) Null value    iv) None of the above
106.          In MS-Access we enter data using ………….
i) Form       ii) Table            iii) Report         iv) Both (i) &(ii)
107.          Date/Time occupies ……….  bytes of memory.
i) 4             ii) 2                  iii) 8                 iv) 16
108.          The extension of database file in MS-Access is……….
i) DBF        ii) DBM            iii) MDB           iv)DMB
109.          The object of MS-Access that is used to generate hard copy of records.
i) Query      ii) Table            iii) Form           iv) Report
110.          A ………….. Key uniquely identifies a record.
i) Primary   ii) Foreign         iii) Composite   iv) None          
111.          Which is not a type of query?
i) Search     ii) Select           iii) Update        iv)All of the above
112.          The storage size of data and time is :
i) 4 bytes    ii)6 bytes          iii)8 bytes         iv)10 bytes
113.           Collecting multiple related files is called:
i)Records    ii)Table iii) Forms          iv)Query
114.          The data type appropriate to store salary is:
i)Memo      ii)Currency       iii)Text             iv) Auto number
115.          ………………. Is not a data type of MS-Access.
i) Number               ii) Text             iii) Memo         iv) Form
116.          Primary key does not accept ……….
i) Text                    ii) Number        iii) Null value    iv) None of the above
117.          ……………….. object of access is used to print formatted data.
i) Query                  ii) Form                        iii) Report         iv) Table
118.          In MS-Access data are stored in ………………
i) Form                   ii) Query           iii) Table           iv) All of the above
119.          Which of the following is not a database application?
          i) Oracle                   ii) Foxpro         iii) MS-Access      iv) MS-Excel
120.          Memory space consumed by a currency data type maximally is …………
          i) 2 bytes                  ii) 4 bytes         iii) 8 bytes        iv) 1 GB
121.               c) The default data type of MS-Access is:
          i) Number     ii)Text              iii) Memo         iv) Auto number
122.          Row is also called …………
          i) Record                  ii) Field            iii) Database      iv) Table
123.          The columns in database tables are called:
i) Record          ii) Field            iii) Report         iv) Memo
124.          Which is suitable data type to store video?
i) Text              ii) Number        iii) Hyperlink    iv) OLE object
125.          Text data type can store maximum of ___characters
i) 250               ii) 350              iii) 255             iv) 355
126.          Which of the following is database application?
i) MS-Word      ii) MS-Access   iii) MS-Excel    iv) QBASIC
127.          The maximum size of text field in MS-Access is ………….
         i) 50              ii) 10                iii) 6400                        iv) 255
128.          The default data type in MS-Access is ……..
         i) Number                  ii) Date/Time    iii) Memo         iv) Text
129.          Report can be generated by using data from …………
         i) Table                      ii) Query           iii) Forms          iv) Both (i) &(ii)
130.          …………….. query changes value in main table.
         i) Select                     ii) Update         iii) Both (i) &(ii)           iv) None of the above


2 comments: