Sunday, February 21, 2021

MS ACCESS MCQ For HPSSC JOA IT Exam

MS ACCESS MCQ For HPSSC JOA IT Exam

MS ACCESS MCQ For HPSSC JOA IT Exam


TEST SERIES:- HPSSC JOA IT Daily Test 2021 (TOTAL TEST 5 WITH ANSWER KEY


MS ACCESS MCQ For HPSSC JOA IT Exam


 1. Microsoft Access provides visual environment for design of _______.

(a) tables

 (b) reports

 (c) forms

 (d) all of them


2. By default, new table is displayed in ______view.

(a) Datasheet View 

(b) Design View 

(c) Report View

 (d) Form View


3. _______ is an alternate to datasheet view for design of table in MS Access.

(a) Datasheet View

 (b) Design View 

(c) Report View

 (d) Form View


4. An ordinary form for data entry in MS Access tables may be created using______ menu.

(a) Create >Form

 (b) Create >Split Form

(c) Create >Multiple Items

 (d) Create >Blank Form


5. In MS Access, a form with data records at one half and entry format at the other half may be

created using______ menu.

(a) Create >Form 

(b) Create >Split Form

(c) Create >Multiple Items

 (d) Create >Blank Form


6. In MS Access, multiple rows of data may be created using______ menu.

(a) Create >Form 

(b) Create >Split Form

(c) Create >Multiple Items 

(d) Create >Blank Form


7. In MS Access, blank form may be created using______ menu.

(a) Create >Form 

(b) Create >Split Form

(c) Create >Multiple Items

 (d) Create >Blank Form


8. In MS Access, form may created through a wizard using______ menu.

(a) Create >More Forms >Form Wizard 

(b) Create >Split Form

(c) Create >Multiple Items 

(d) Create >Blank Form


9. In MS Access, data sheet may be created using _______ menu.

(a) Create >More Forms >Form Wizard

 (b) Create >More Forms >Data Sheet

(c) Create >More Forms >Modal Dialog 

(d) Create >Blank Form


10. In MS Access, form dialog may be created using_______ menu.

(a) Create >More Forms >Form Wizard 

(b) Create >More Forms >Data Sheet

(c) Create >More Forms >Modal Dialog 

(d) Create >Blank Form


11. In MS Access, form may be manually designed through available components (like textfield,

datapicker, combo-box, etc.) using ______menu.

(a) Create >More Forms >Form Wizard

 (b) Create >More Forms >Data Sheet

(c) Create >More Forms >Modal Dialog

 (d) Create >Form Design


12. In MS Access, default report may be created using ______ menu.

(a) Create >Report

(b) Create >Blank Report

(c) Create >Report Wizard

(d) Create >Report Design


13. In MS Access, blank report may be created using_______ menu.

(a) Create >Report

(b) Create >Blank Report

(c) Create >Report Wizard

(d) Create >Report Design


14. In MS Access, report may be created through wizard using_______ menu.

(a) Create >Report

(b) Create >Blank Report

(c) Create >Report Wizard

(d) Create >Report Design


15. In MS Access, report may be designed using components like combobox, text field, text area,

list, etc. using _______menu.

(a) Create >Report 

(b) Create >Blank Report

(c) Create >Report Wizard 

(d) Create >Report Design


16. In MS Access, macro may be recorded to carry out different actions using______ menu.

(a) Create >Report

 (b) Create >Blank Report

(c) Create >Report Wizard

 (d) Create >Macro


17. In MS Access, a macro can be activated by pressing,_______ button.

(a) Form 

(b) Report

 (c) Run

 (d) Table


18. In MS Access, macros can automate__________ .

(a) program flow/ data entry 

(b) data import/ data export

(c) filter/ query/ search 

(d) all of them


19. What is the maximum length of the field name in Access?

A 16 characters

 B 32 characters

C 64 characters 

D 128 characters


20. Which view is used to arrange table data in different graphical layouts to summarize data?

A Table view

B Design view

C Data sheet view

D Pivot chart view


21. Which view allows to modify table‘s structure in Access?

A Design view

B Datasheet view

C Pivot table view

D Pivot shart view


22. Which object stores information about related data?

A Document

B Table

C Page

D Screen


23. Which key stoke moves the active cell towards left in Access table?

A F2

B F5

C Tab

D Shift + Tab


24. Which combination of key zooms the content of active cell in Access table?

A Ctrl + F2

B Ctrl + F5

C Shift + F2

D Shift + F5


25. Which technique prevents invalid data being saved in Access table?

A Index

 B Filter 

C Validation rule 

D Input mark


26. Which validation rule accepts only a - z letters for fields in Access?

A Is null or NOT like ―*[! a - z]*‖

B Is null or NOT like ―*[a - z ]*‖

C Is null or NOT like ―*![a - z]*‖

D Is null or NOT like ―[! a - z]‖


27. Which validation rule allows only 0 - 9 for fields in Access?

A Is Null or Not Like ―*[ ! 0 - 9 ]*‖

B Is Null or Not Like ―[! 0 - 9]‖

C Is Null or Not Like ―*[0 - 9]*‖

D Is Null or Not Like ―*[!0-9]*‖


28. Which validation rule allows only positive numbers for fields in?

A Is Null or > = 0

B Is Null or Positive

C Is Null or < 0

D Is Null or = ―+‖


29. What is allowed the input mark symbol # in Access?

A Letter or digit

B Letter A through Z

C A digit 0 - 9 with +/- sign

D A digit 0 - 9 without +/- sign


30. Which validation rule allows exactly digits for number fields in Access?

A Is Null or Between 100000 and 99999

B Is Null or Like ―????‖

C Is Null or >= 0 AND< = 99999

 D Is Null or < = 99999

 

31. What is the output when the data ‗1678.95‘ is set to the number format ‗###0.00‘ in Access?

A 1670.00

B 1670.95

C 1678.00

D 1678.95


32. Which of the following is a valid time format is Access?

A hh:mm:ss AM/PM

B hh.mm.ss AM/PM

C hh-mm-ss AM/PM

D hh/mm/ss AM/PM


33. Write the output when the data ‗Primary Key‘ is set to the text < in Access?

A Primary key

B primary key

C PRIMARY KEY

D Primary Key


34. What is the output when the data ―FOREIGN key‘ is set to the text format > in Access?

A foreign key 

B FOREIGN KEY 

C Foreign Key

 D Foreign key


35. What is the reason for not accepting zero in the fields of Access tables?

A Fields is set with is Null or > 0

B Fields is set with is Null or < = 0

C Fields is set with is Null or! [0]

D Fields is set with is Null or like ―?‖


36. Which field type will you select when you need to enter long text in the field?

a) Text

 b) memo

 c) currency

 d) hyperlink


37. The expression builder is access tool that controls expression ____ for entering expression

a) Table 

b) Box 

c) Cell 

d) Palette


38. Which of the following is not type of MS Access database object?

a) Table 

b) Form 

c) Worksheets 

d) Modules


39. In which method we don‘t need to specify the field type and size while creating a new table?

a) Design view

 b) While using Wizard

c) Create Table by entering Data 

d) All of these


40.Th size of yes/no field is always ______ .

a) 1 Bit

 b) 1 byte 

c) 1 character 

d) 1 kb


41. The size of a field with number data type can not be ____

a) 2

 b) 4 

c) 8 

d) 16


42. What does the show check box in query design window indicate?

a) It indicates whether the field is to be used or not.

b) It indicates whether the field is to be displayed in query result or not

c) It indicates whether the field names to be displayed in query result or not.

d) It indicates whether the field is to be used for grouping result or not.


43. Which of the following option creates a Drop Down list of values ?

a) Ole Object

 b) Hyperlink

 c) Memo 

d) Lookup wizard


44. What is a form that we can create in MS Access ?

a) it is used to take printout of a form from Access Tables.

b) It is an input screen for viewing and entering data.

c) It is used for storing special data other than text.

d) It is optional. We can use report instead of Form


45. What cascade delete option is used for?

a) It is used to delete all the records of all tables in a database.

b) It repeats the recent delete operation to all the records of current table.

c) It ensure that all the related records will be deleted automatically when the record from parent table is deleted.

d) It is used to delete all the records of related tables in a database.


46. The ______ button on the tool box display data from a related table.

a) Sub form sub report

 b) Relationships 

c) select objects 

d) More controls


47. The command center of MS access file that appears when we create or open the MS Access database file

a) Database window 

b) Query window 

c) Design view window 

d) switchboard


48. While creating relationship using mouse, how the mouse pointer looks like?

a) A thick plus sign

 b) A thin plus sign 

c) An outlined rectangle 

d) Arrow with plus sign


49. The columns is a Microsoft access table are also called ______.

a) Rows 

b) Records

 c) Field 

d) Columns


50. how can you define a field so that when entering data #### is displayed?

a) Input mask 

b) Validation rule 

c) Indexed 

d) Ime mode


51. In the context of Microsoft access, which of the following statement is true?

a) Reports are used to retrieve and calculate data from tables.

b) Queries can be printed and presented as the information

c) Queries can include calculated fields that do not exist in table

d) Reports and forms are similar but forms are use to print but reports to display on screen only


52. The upper part of the query design window in MS Access has two parts shows ______.

a) Fields name with field size

b) Field name with relationships

c) Fields and Criteria

d) Sorting Options


53. To define AND condition while entering criteria in a query design window we write ____

a) Criteria values vertically one in a row

b) Criteria values horizontally

c) Write criteria values separated by AND

d) Write criteria values using & (anchor and) sign


54. Which feature is used to duplicate a control‘s formatting ?

a) Manager

 b) Wizard 

c) Painter 

d) Control


55. Which of the following is not a type of relationship that can be applied in Access database?

a) One to one 

b) One to many

 c) Many to many

 d) All of these


56. While creating relationship, what happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?

a) A relationship is created 

b) Edit relationship dialog box appears

c) A connector symbol is created 

d) A connecting line is visible


57. What is the role of Cascade update option ?

a) It says do not change the value in the primary key field if that record has related records in another table

b) It means change all the related records in child tables if the record in parent table is changed

c) Both A and B

d) None of these


58. How many ways to open a table in MS Access ?

a) 3

 b) 2 

c) 1 

d) 4


59. Which of the following is a method to create a new table in MS Access?

a) Using Design View 

b) Create Table Wizard

c) Directly Entering Data

 d) All of these


60. If you write criteria values one in a row in query design window, that means you are specifying

a) Or Conditions

 b) AND Conditions

 c) NOT Conditions

 d) ALL conditions


61. How can we create a query in Microsoft Access?

a) Drag and drop fields

b) Type the SQL

c) Use Query wizard

d) All of these


62. Which option allows us to build a new table by entering data directly into a tabular grid?

a) Datasheet view 

b) Design view 

c) Linked Table

 d) Grid view


63. What is the shortcut key to switch between the field names and properties panels in table

design view?

a) F3 key 

b) F4 key

 c) F5 key

 d) F6 key


64. Which field type can store photos ?

a) Hyperlink 

b) OLE object

 c) Both can be used

 d) it is not possible


65. Which data type should we use if we are planning to store a couple of paragraph or detailed description in a field ?

a) Text

 b) Para

 c) Memo

 d) Desc


66. Which of the following database object hold data?

a) Forms 

b) Reports

 c) Queries

 d) Tables


67. When creating a new table which method can be used to choose fields from standard databases and tables

a) create table in design view 

b) create table using wizard

c) Create table by entering 

d) none of these


68. Which one of these is the most common type of query that retrieves records from one or more tables and then displays the result in tabular form?

a) Tabular Query 

b) Crosstab query 

c) Select query

 d) pivot query


69. Microsoft Access is a _____ kind of application ?

a) RDBMS 

b) OODBMS 

c) ORDBMS 

d) Network Database Model


70. Queries in MS Access can be used _____

a) To view data

 b) As source for forms 

c) As source for Reports 

d) All of these


71. The small button with three dots displayed at the right of field properties box is called :

a) Make button

 b) Expression Button

 c) Built Button

 d) None of these


72. Which of the following shows the final result in a presentable way ?

a) Forms 

b) Reports

 c) Queries

 d) Tables


73. In MS Access, how can we create relationship between two tables in the GUI?

a) Drag the foreign key of a table into the primary key of another table

b) Drag any field from parent table and drop on child table

c) Drag the primary key of a table into foreign key of another table

d) Any of these can be done to create relationship


74. Which of the following store command to gather data from database ?

a) Forms

 b) Reports 

c) Queries 

d) Tables


75. A search value in SQL query can be a specific value or it can be _____

a) Logical Operator

 b) Relationship

c) Wild card Character

 d) Comparison operation


76. What is the default and maximum size of text field in MS Access ?

a) 50 and 255 characters 

b) 8 and 1 Gb

c) 266 and 64000 characters

 d) 8KB and 1.5 MB


77. How can we remove a relationship defined between two tables?

a) From edit menu ( by choosing delete relationship)

b) Select the relationship line and press delete

c) Choose Delete option from relationship menu

d) Choose remove option from relationship menu


78. In MS Access to open new database press

a) Ctrl + N

 b) Ctrl + o

 c) Alt + F4

 d) None of these


79. In MS Access to open a combo box

a) F4 or Alt + Down Arrow 

b) Down Arrow 

c) Page down

 d) F9


80. In MS Access to open an existing database press

a) Ctrl + N 

b) Ctrl + o 

c) Alt + F4 

d) None of these


81. In MS Access to refresh the contents of a lookup field (Lookup field: A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or stores a static set of values.) list box or combo box

a) F4 or Alt + Down Arrow 

b) Down Arrow 

c) Page down 

d) F9


82. Press the following keys in MS Access to cancel print preview or layout preview

a) Ctrl + p

 b) P or ctrl + P 

c) ctrl + s 

d) C or Esc


83. Press the following keys in MS Access to Print the current or selected object

a) Ctrl + P

 b) P or Ctrl + P

 c) ctrl + s 

d) C or Esc


84. In MS Access press Alt + F11 to

a) Display the control menu

 b) Display the shortcut menu

c) Close the active window 

d) None of these


85. How can you display the relationship in a database?

a) Select view > Relationship from the menu

b) Click the relationship button on the toolbar

c) Select Edit > Relationship from the menu

d) All of these


86. How can you display Pivot table report summary data in a currency format ?

a) Use custom calculation 

b) Type in the currency symbol

c) Modify the field settings 

d) None of these


87. A query summarizes information in a grid, organized by regions and months. Which type of query is this?

a) A cross tab query 

b) An update query

c) A parameter query 

d) An active query


88. The filters by selection feature allows you to filter

a) Those records that match an entity in a field

b) Records based on a criterion you specify

c) Records that meet any of several criteria you specify

d) All of these


89. How can you display sales grouped by country, region, and salesperson, all at the same time?

a) Use the sort descending command

 b) Use the pivot table view command

c) Use the fine command on specified group 

d) All of these


90. What is the memo data type field used for?

a) To add table 

b) To store objects created in other programs

c) For long text entries 

d) For shout text entries of no more than 255 characters


91. The checking operation performed on input data is called the

a) Validation of data

 b) Verification of data

c) Cross check

 d) Control of data


92. What is the purpose of the description column in Table Design view?

a) To define the data type applied to each field within the table

b) To describe the data that should be entered in each field

c) To enter lookup data that the field should refer to

d) None of these


93. What is the purpose to a sub datasheet?

a) To provide a hierarchical view of related tables or queries in a single window

b) To display grouped data in a report

c) To display summarized data.

d) All of these


94. You can keep the sum ([sales]) to calculate the totals for each month in

a) The report footer section

 b) the page footer section

c) the month group footer section 

d) the summary section


95. The type of query extract the data and put them into separate table

a) A parameter query

 b) A make-table query

c) An update query 

d) A crosstab query


96. The procedure for selecting multiple controls on a report

a) Hold down the shift key as you click each object that you want to select

b) If the controls are aligned along a horizontal or vertical line, click the horizontal or vertical ruler above or to the left of the controls

c) Hold down the Ctrl key as you click each object that you want to select

d) All of these


97. The following database object can you import from one MS-Access database to another?

a) Queries

 b) Tables 

c) Forms

 d) All of these


98. What field type is used to store picture in a table?

a) Memo 

b) OLE 

c) Hyperlink 

d) None


99. Queries design window has two parts. The upper part shows

a) Name of fields, field type and size 

b) Sorting check boxes

c) Tables with fields and relationships between tables 

d) None of these


100. In a database table, the category of information is called _____

a) record

 b) Tuple

 c) field 

d) None of these


101. Which of the following is not a database object?

a) Form

 b) Tables

 c) Reports 

d) Relationships


102. This is the stage in database design where one gathers and lists all the necessary fields for the database project.

a) Data dictionary 

b) data refinement 

c) data definition 

d) none of these


103. This key uniquely identifies each record

a) key record 

b) composite key

c) foreign key 

d) primary key


104. Which of the field has width 8 bytes?

a) Currency 

b) memo 

c) hyperlink 

d) date/time


105. Which of the following are view to display a table in Access?

a) Datasheet view 

b) Design view

c) Both A and B 

d) None of these


106. A _____ enables you to view data from a table based on a specific criterion

a) Query 

b) Report 

c) Form 

d) All of these


107. Which of the following database object produces the final result to present ?

a) Table

 b) Reports

 c) Queries 

d) None of these


108. The database language that allows you to access or maintain data in a database

a) DML

 b) DCL 

c) DDL 

d) TCL


109. What are the columns in Microsoft Access table called?

a) Table

 b) Reports 

c) Queries

 d) fields


110. The ______ operator will cause a report to be selected only if two or more conditions are satisfied

a) NOT 

b) XOR 

c) OR 

d) AND


111. What is the maximum length a text field can be?

a) 255 

b) 256

 c) 257

 d) 355


112. DCL provide commands to perform actions like

a) Change the structure of tables

b) Authorizing access and other control over database

c) Insert, update or delete records and data values

d) All of these


113. Which of the following store command to retrieve data from database?

a) Queries 

b) Forms 

c) Records

 d) Reports


114. A part of database that stores only one type of data is

a) Record 

b) Table 

c) Field

 d) Report


115. A database can be best described as

a) Useful presentation of data 

b) Organized collection of data

c) Graphical representation of data 

d) None of these


116. Collection of related records in a database is known as

a) Record 

b) Table 

c) Field 

d) Report


117. The complete information about an entity in a database is called

a) Record

 b) Table 

c) Field

 d) Report


118. The task of arranging data in order is called

a) Ordering 

b) Searching

 c) Sorting

 d) Ascending


119. A composite key is

a) The primary key with Auto Number as the field type

b) Is a foreign key that uniquely identifies records

c) Made up of two or more fields to uniquely identify records

d) None of these


120. An organized collection of logically related data is known as

a) Data base 

b) Meta data 

c) Information 

d) Information


121. HSAM stands for______

a) Hierarchic standard and method

 b) Hierarchic Sequential and method

c) Hierarchic standard Access method 

d) Hierarchic Sequential Access Method


122. In a database, what does each row represent ?

a) Field 

b) Database 

c) Record 

d) All of these


123. What do you call a primary key field included in another table ?

a) Child key 

b) Composite key 

c) Parent key 

d) Foreign key


124.Which data type is better to use for storing the price of an item?

a) Number 

b) Text 

c) Currency

 d) Hyperlink


125. The basic elements of a form or a report are called :

a) Windows 

b) Controls

 c) Objects

 d) Table


126. Which of the following data type is used to store logical value in MS Access?

a) Yes/No

 b) On/ Off 

c) True/False

 d) All of these


127. In MS Access ―Lookup Wizard‖ is used to

a) To select value from another table

 b) To select values from Excel sheet

c) To select from previous values 

d) None of the Above


128. Which of the following is use to get data from user?

a) Query

 b) Form

 c) Report

 d) Table


129. Validation Rule in a field will

a) Defines the appearance for the text

b) Displays the value in specified format when user leave the field

c) Checks the value entered when user leaves the field

d) None of the above


130. Query can be used to select data from

a) single table

 b) multiple table

 c) Both single & Multiple tables

 d) None of these


131. Data can be import into Access Database from

a) Notepad Files 

b) Power point files

 c) Word files 

d) Excel files


132. Queries can be created in Access by

a) Using Query Wizard 

b) Typing Queries in SQL View

c) Drag and Drop fields on Query Builder 

d) All of these


133. Which of the following is the default join between two records?

a) Inner join

 b) Outer join 

c) Right outer join

 d) None of these


134. Any report, including a basic report, can be modified in ______ .

a) Print Preview 

b) Report view 

c) Layout view 

d) All of these


135. Using he keyword _____ will return records is which the field value equals a defined text.

a) Like 

b) Between 

c) Is Null

 d) Equal


136. In a query, using the keyword ______ will return records in which the field value is between two numbers.

a) Like 

b) Between

 c) Is Null

 d) Equal


137. Database is also called as ______

a) DBMS 

b) RDMS 

c) DDMS 

d) None of these


138.In Access data is stored in _____

a) Rows 

b) Columns

 c) Both A and B

 d) None of these


139. The organization of a table is _______.

a) Logical 

b) Physical 

c) Both A and B

 d) None of these


140. Access contains objects like _____

a) Tables 

b) Forms 

c) Queries 

d) All of these


141. Popular Databases are _____

a) Access

 b) FoxPro

 c) Clipper

 d) All of these


142. In RDMS, a table is comparable to a database file but more_____

a) Lonely structured

 b) Highly Structured

 c) Non structured 

d) None of these


143. Each record in a table contain _____ keys.

a) Unique 

b) Primary keys 

c) Both A and B 

d) None of these


144. OLE data object data type can store ______

a) Video clips 

b) Pictures

 c) Graph 

d) All of these


145. Querying a database is a method of ______

a) Retrieving specific data 

b) Displaying specific data

c) Both A and B 

d) None of these


146. Sorting can be done in _______ order.

a) Ascending 

b) Descending

 c) Both A and B

 d) None of these


147. Reports are required for presenting information on _______

a) Paper 

b) On screen 

c) Both A and B 

d) None of these


148. Tree structured are used to stored data in

a) Network model

 b) Relational model

 c) Hierarchical model

 d) File base system


149. The rule that a value of a foreign key must appear as a value of some specific table is called

a) Referential constraint

 b) index 

c) Integrity constraint 

d) Functional dependency


150. ______ view permits selection of data types, default values and constraints for each column.

(a) Datasheet 

(b) Design

 (c) Report

 (d) Form


151. A relation is in ______ if an attribute of a composite key is dependent on an attribute of other composite key.

a) 2NF 

b) 3NF 

c) BCNF 

d) 1NF


152. What is data integrity?

a) It is the data contained in database that is non redundant

b) It is the data contained in database that is accurate and consistent

c) it is the data contained in database that is secured.

d) It is the data contained in database that is shared.


153. Which of the following is not a database application?

a) dBase 

b) Flash 

c) FoxPro

 d) Access


154. Which of the following is not a logical database structure?

a) Chain 

b) Network 

c) Tree 

d) Relational


155. A ____ is a unit of information in a ______

a) record, field

 b) field, record 

c) data source, field 

d) record, data source


156. Which type of field is increment automatically?

a) Auto Elevate 

b) Auto Number 

c) Auto Increment

 d) Auto Value


157. Which will display values in drop down box from another table while entering data….

a) Query wizard 

b) Look up wizard 

c) Form Wizard 

d) Report wizard


158. A primary key in any table has the following properties

a) Not Null 

b) No Duplicates

 c) Both A and B

 d) None of these


159. What is the file extension of MS Access 2003?

a) .mdb 

b) .mcb 

c) .acc 

d) .mcd


160. Which option allows you to build a new table by entering data directly into the datasheet.

a) Datasheet view 

b) design view 

c) link table 

d) None of these


161. Which key stoke is used to move the active cell towards right, in access table?

A Ctrl + Tab

B Alt + Tab

C Tab

D Shift + Tab


162. Refresh button can be found in….

a) Create Tab

 b) External Data 

c) Home Tab 

d) Database Tool


163. How can you protect your data with password?

a) From Macro

 b) From database tool 

c) From SQL server

 d) From Datasheet tab


164. Which will help to search data from database?

a) Queries 

b) Froms

 c) Reports

 d) Macros


165. Which combination of key allows user to move to the first field in the first record in Access table?

A Ctrl + Tab

B Shift +Tab

C Shift + Home

D Ctrl + Home


166. Which command quickly locates the data is Access table?

A Find

B Locate

C Search

D Edit


167. OODBMS stands for_______.

a) object oriented database management system. 

b) order data base management system

c) order base management system 

d) office data base management system


168. MS Access creates files are stored with______ extension.

(a) .docx 

(b) .xlsx 

(c) .accdb 

(d) .pptx


169. New database created in MS Access has got a default table named________ .

(a) Table1 

(b) Database1

 (c) Column1

 (d) Row1


170. What can be created to help easy data entry in MS Access tables.

(a) Form 

(b) Report 

(c) database

 (d) spreadsheet


171. By default, first column of an MS Access table is named _______ and it has auto increment property.

(a) NAME

 (b) DATE

 (c) NULL

 (d) ID


172. How can you edit a relationship already established between two tables?

a) Right click the relationship line and choose edit relationship

b) Double click the relationship line

c) Both the above

d) None of the above


173. Which of the following database object hold data?

a) Reports

 b) Tables 

c) Forms 

d) All of these


174. Full form of DBMS

a) Data base management system

 b) Document Base Management System

c) Digital Base Management System

 d) None of these

PAID TEST SERIES:- HPSSSB JOA IT EXAM TEST SERIES(10 TEST WITH ANSWER KEY) 







                                    Join Our Telegram Group

No comments: