by Set-1
Select the correct answer
a) The maximum text field size in Access is ……….
i) 50 ii) 10 iii) 256 iv) 255
Ans: 255
b) The extension of database file in Access is ……..
i) .DBF ii) .MDB iii) .DMB iv) .DBM
Ans: .MDB
c) …….uniquely identifies the record.
i) Index ii) Memo field iii) Primary key iv) Query
Ans: Primary Key
d) The object of Access that stores the data is known as……
i) Query ii) Table iii) Form iv) Report
Ans: Table
Match the following
a) Indexing data Retrieves data
b) Long text DBMS
c) FoxPro Memo field
d) Query Searching fast
Report
Ans:
a) Indexing data Searching fast
b) Long text Memo field
c) FoxPro DBMS
d) Query Retrieves data
Set-2
Select the correct answer
a) A field size which accepts logical type of data
i) Yes/No ii) Date iii) 1/0 iv) Number
Ans: Yes/No
b) A row in a table is also known as ………..
i) field ii) content iii) record iv) text table
Ans: Record
c) The size of caption is declared up to……… characters.
i) 2048 ii) 64000 iii) 255 iv) 271
Ans: 2048
d) The text field is used for declaring up to………. Characters.
i) 50 ii) 64000 iii) 255 iv) 8
Ans: 255
Match the following
a) Database Date / Time
b) OLE Data of SLC exam
c) Date of joining Entering and modifying data
d) Form picture
Object of Access
Ans:
a) Database Data of SLC exam
b) OLE picture
c) Date of joining Date / Time
d) Form Entering and modifying data
Set-3
Select the correct answer
a) Field size of a logical field is …………..in Access
i) 1 ii) 2 iii) 3 iv) 0
Ans: 1
b) A table is intersection of …………… used for storing records.
i) rows and columns ii) records iii) data iv) database
Ans:rows and column
c) Ms Access is used to create…………..
i) database ii) DBMS iii) Record iv) Table
Ans:database
d) Extracts selected record for viewing data as user’s requirement.
i) Query ii) Field iii) Table iv) Tuple
Ans:Query
Match the following
a) Primary Key 8 bytes
b) Number Non-repetition of data
c) Date/Time Data
d) Query Sort and Filter
Only for numeric values
Ans:
a) Primary Key Non-repetition of data
b) Number Only for numeric values
c) Date/Time 8 bytes
d) Query Sort and Filter
Set-4
Select the correct answer
a) What is the extension of Access database?
i) DB ii) MDB iii) DBF iv) ADB
Ans: .MDB
b) ………..is a database management system.
i) Word ii) Lotus iii) All iv) FOXPRO
Ans: FOXPRO
c) ……… displays alternative name for the field in datasheet, form, report.
i) Caption ii) Text iii) Memo iv) None
Ans: Caption
d) The data type appropriate to store salary of employee is
i) Memo ii) Currency iii) Text iv) Auto number
Ans: Currency
Match the following
a) Data entry Easy to search
b) Memo Table
c) Formatted output Query
d) Sort Query Data type
Report
Ans:
a) Data entry Table
b) Memo Data type
c) Formatted output Report
d) Sort Query Easy to search
Set- 5
Select the correct answer
a) -----------------------displays alternative name for the field in datasheet, form, report.
i) Caption ii) Text iii) Memo iv) None
Ans: Caption
b) Field names can contain upto---------------characters including space.
i)60 ii)50 iii)200 iv) None
Ans: None
c) Hyperlink is a ------------
i) Data type ii) Data iii) Field property iv) Field
Ans: Data type
d) ---------------------accelerates the query and sort operation .
i) Index ii)Sort iii)Number iv) filter
Ans: Index
Match the following
a) Caption DBMS
b) Table used by logical operation
c) Yes/No Field property
d) Sybase Object of access
Feature of Access
Ans:
a) Caption Field property
b) Table Object of access
c) Yes/No used by logical operation
d) Sybase DBMS
Set-6
Select the correct answer
a) Which is not MS-Access object?
i. Form ii. Table iii. Query iv. Caption
Ans: Caption
b) A field property that limits the data to be entered in a field is…..
i. Format ii. Validation rule iii.Input mask iv. Indexed
Ans: Validation rule
c) The logical data type of MS-Access is…..?
i. Yes/No ii. On/Off iii. True/False iv. All of above
Ans: Yes/No
d) The ready to print information is……..
i. Query ii. Report iii. Database iv. Table
Ans: Report
5. State whether the following statements are true or false:
a) In the Table Datasheet view, a user can change the data type of field.False
b) A row of table is known as field in MS-Access.False
c) A query can be created without tables.False
d) A report can be used to modify data of a table.False
Set-7
Select the correct answer
a) A table structure can be modified in …………………view
i. Design ii. Datasheet iii.Wizard iv. Data Entry
Ans: Design
b) Which is not a data type?
i. Memo ii. Hyperlink iii.OLE objects iv. Required
Ans: Required
c) The value which automatically repeated in each row in a table is …………..
i. Input masks value ii. Format value iii.Default value iv. All of above
Ans: Default value
d) The range of Year in Date & Time data type is between ……….years.
i. 100 to 9999 ii. 1000 to 9999 iii.999 to 9999 iv. 100 to 999
Ans: 100 to 9999
Match the following
a) General date 30 June 13
b) Long Date 06/30/2013
c) Short Date Friday, June 30, 2013
d) Medium Date 04:05:2013
06/30/2013 10:30 a.m.
Ans:
a) General date 06/30/2013 10:30 a.m.
b) Long Date Friday, June 30, 2013
c) Short Date 06/30/2013
d) Medium Date 30 June 13
Set-8
Select the correct answer
a) Date/Time occupies ….bytes of memory.
i. 4 ii. 2 iii.8 iv. 16
Ans:8
b) The extension of database file in MS-Access is …………
i. DBF ii. DBM iii.MDB iv. DMB
Ans:.MDB
c) The object of MS-Access that is used to generate hard copy of records is ………….
i. Query ii. Table iii.Form iv. Report
Ans:Report
d) A ………….key uniquely identifies a record
i. primary ii. Foreign iii.Composite iv. None
Ans:Primary
Match the following
a) Default value 255 characters
b) Fox pro column name
c) Text DBMS
d) Field field properties
Search fast
Ans:
a) Default value field properties
b) Fox pro DBMS
c) Text 255 characters
d) Field column name
Set-9
State whether the following statements are true or false.
a) A form is useful for entering and editing records.True
b) DBMS is word processing software.False
c) The table of MS-Access has .tbl extension.False
d) A field name can have maximum number of 64 characters.True
Match the following
a) Text field 1 MB
b) Memo field 1 GB
c) Yes/No 255 characters
d) OLE field 1 Bit
65535 characters
Ans:
a) Text field 255 characters
b) Memo field 65535 characters
c) Yes/No Bit
d) OLE field 1 GB
Set-10
Select the Best Answer
a) Which object can be stored in memo field?
i) Hyperlink ii) Data iii) Picture iv) Word
Ans:Picture
b) What is the extension of access database?
i) DBF ii) MDB iii) MBD iv)None
Ans:.MDB
c) The name of caption can be declared up to ………….characters.
i) 1024 ii) 2024 iii)2048 iv)2005
Ans:2048
d) The framework for storing records in database is………
i) Query ii)Form iii)Report iv)Table
Ans:Table
Match the following
a) Data integrity no. of character can be entered.
b) Automatic validation rule
c) Field size caption
d) Label for field indexed
Default value
Ans:
a) Data integrity validation rule
b) Automatic default value
c) Field size no. of character can be entered.
d) Label for field caption
Select the correct answer
a) The maximum text field size in Access is ……….
i) 50 ii) 10 iii) 256 iv) 255
Ans: 255
b) The extension of database file in Access is ……..
i) .DBF ii) .MDB iii) .DMB iv) .DBM
Ans: .MDB
c) …….uniquely identifies the record.
i) Index ii) Memo field iii) Primary key iv) Query
Ans: Primary Key
d) The object of Access that stores the data is known as……
i) Query ii) Table iii) Form iv) Report
Ans: Table
Match the following
a) Indexing data Retrieves data
b) Long text DBMS
c) FoxPro Memo field
d) Query Searching fast
Report
Ans:
a) Indexing data Searching fast
b) Long text Memo field
c) FoxPro DBMS
d) Query Retrieves data
Set-2
Select the correct answer
a) A field size which accepts logical type of data
i) Yes/No ii) Date iii) 1/0 iv) Number
Ans: Yes/No
b) A row in a table is also known as ………..
i) field ii) content iii) record iv) text table
Ans: Record
c) The size of caption is declared up to……… characters.
i) 2048 ii) 64000 iii) 255 iv) 271
Ans: 2048
d) The text field is used for declaring up to………. Characters.
i) 50 ii) 64000 iii) 255 iv) 8
Ans: 255
Match the following
a) Database Date / Time
b) OLE Data of SLC exam
c) Date of joining Entering and modifying data
d) Form picture
Object of Access
Ans:
a) Database Data of SLC exam
b) OLE picture
c) Date of joining Date / Time
d) Form Entering and modifying data
Set-3
Select the correct answer
a) Field size of a logical field is …………..in Access
i) 1 ii) 2 iii) 3 iv) 0
Ans: 1
b) A table is intersection of …………… used for storing records.
i) rows and columns ii) records iii) data iv) database
Ans:rows and column
c) Ms Access is used to create…………..
i) database ii) DBMS iii) Record iv) Table
Ans:database
d) Extracts selected record for viewing data as user’s requirement.
i) Query ii) Field iii) Table iv) Tuple
Ans:Query
Match the following
a) Primary Key 8 bytes
b) Number Non-repetition of data
c) Date/Time Data
d) Query Sort and Filter
Only for numeric values
Ans:
a) Primary Key Non-repetition of data
b) Number Only for numeric values
c) Date/Time 8 bytes
d) Query Sort and Filter
Set-4
Select the correct answer
a) What is the extension of Access database?
i) DB ii) MDB iii) DBF iv) ADB
Ans: .MDB
b) ………..is a database management system.
i) Word ii) Lotus iii) All iv) FOXPRO
Ans: FOXPRO
c) ……… displays alternative name for the field in datasheet, form, report.
i) Caption ii) Text iii) Memo iv) None
Ans: Caption
d) The data type appropriate to store salary of employee is
i) Memo ii) Currency iii) Text iv) Auto number
Ans: Currency
Match the following
a) Data entry Easy to search
b) Memo Table
c) Formatted output Query
d) Sort Query Data type
Report
Ans:
a) Data entry Table
b) Memo Data type
c) Formatted output Report
d) Sort Query Easy to search
Set- 5
Select the correct answer
a) -----------------------displays alternative name for the field in datasheet, form, report.
i) Caption ii) Text iii) Memo iv) None
Ans: Caption
b) Field names can contain upto---------------characters including space.
i)60 ii)50 iii)200 iv) None
Ans: None
c) Hyperlink is a ------------
i) Data type ii) Data iii) Field property iv) Field
Ans: Data type
d) ---------------------accelerates the query and sort operation .
i) Index ii)Sort iii)Number iv) filter
Ans: Index
Match the following
a) Caption DBMS
b) Table used by logical operation
c) Yes/No Field property
d) Sybase Object of access
Feature of Access
Ans:
a) Caption Field property
b) Table Object of access
c) Yes/No used by logical operation
d) Sybase DBMS
Set-6
Select the correct answer
a) Which is not MS-Access object?
i. Form ii. Table iii. Query iv. Caption
Ans: Caption
b) A field property that limits the data to be entered in a field is…..
i. Format ii. Validation rule iii.Input mask iv. Indexed
Ans: Validation rule
c) The logical data type of MS-Access is…..?
i. Yes/No ii. On/Off iii. True/False iv. All of above
Ans: Yes/No
d) The ready to print information is……..
i. Query ii. Report iii. Database iv. Table
Ans: Report
5. State whether the following statements are true or false:
a) In the Table Datasheet view, a user can change the data type of field.False
b) A row of table is known as field in MS-Access.False
c) A query can be created without tables.False
d) A report can be used to modify data of a table.False
Set-7
Select the correct answer
a) A table structure can be modified in …………………view
i. Design ii. Datasheet iii.Wizard iv. Data Entry
Ans: Design
b) Which is not a data type?
i. Memo ii. Hyperlink iii.OLE objects iv. Required
Ans: Required
c) The value which automatically repeated in each row in a table is …………..
i. Input masks value ii. Format value iii.Default value iv. All of above
Ans: Default value
d) The range of Year in Date & Time data type is between ……….years.
i. 100 to 9999 ii. 1000 to 9999 iii.999 to 9999 iv. 100 to 999
Ans: 100 to 9999
Match the following
a) General date 30 June 13
b) Long Date 06/30/2013
c) Short Date Friday, June 30, 2013
d) Medium Date 04:05:2013
06/30/2013 10:30 a.m.
Ans:
a) General date 06/30/2013 10:30 a.m.
b) Long Date Friday, June 30, 2013
c) Short Date 06/30/2013
d) Medium Date 30 June 13
Set-8
Select the correct answer
a) Date/Time occupies ….bytes of memory.
i. 4 ii. 2 iii.8 iv. 16
Ans:8
b) The extension of database file in MS-Access is …………
i. DBF ii. DBM iii.MDB iv. DMB
Ans:.MDB
c) The object of MS-Access that is used to generate hard copy of records is ………….
i. Query ii. Table iii.Form iv. Report
Ans:Report
d) A ………….key uniquely identifies a record
i. primary ii. Foreign iii.Composite iv. None
Ans:Primary
Match the following
a) Default value 255 characters
b) Fox pro column name
c) Text DBMS
d) Field field properties
Search fast
Ans:
a) Default value field properties
b) Fox pro DBMS
c) Text 255 characters
d) Field column name
Set-9
State whether the following statements are true or false.
a) A form is useful for entering and editing records.True
b) DBMS is word processing software.False
c) The table of MS-Access has .tbl extension.False
d) A field name can have maximum number of 64 characters.True
Match the following
a) Text field 1 MB
b) Memo field 1 GB
c) Yes/No 255 characters
d) OLE field 1 Bit
65535 characters
Ans:
a) Text field 255 characters
b) Memo field 65535 characters
c) Yes/No Bit
d) OLE field 1 GB
Set-10
Select the Best Answer
a) Which object can be stored in memo field?
i) Hyperlink ii) Data iii) Picture iv) Word
Ans:Picture
b) What is the extension of access database?
i) DBF ii) MDB iii) MBD iv)None
Ans:.MDB
c) The name of caption can be declared up to ………….characters.
i) 1024 ii) 2024 iii)2048 iv)2005
Ans:2048
d) The framework for storing records in database is………
i) Query ii)Form iii)Report iv)Table
Ans:Table
Match the following
a) Data integrity no. of character can be entered.
b) Automatic validation rule
c) Field size caption
d) Label for field indexed
Default value
Ans:
a) Data integrity validation rule
b) Automatic default value
c) Field size no. of character can be entered.
d) Label for field caption
No comments:
Post a Comment