MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 47 Mcqs, each offering curated multiple-choice questions to sharpen your Computer Science Mcqs knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
what can be the maximum length of a text field ? |
| A. | 120 |
| B. | 255 |
| C. | 265 |
| D. | 75 |
| Answer» C. 265 | |
| 2. |
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 |
| Answer» D. None of these | |
| 3. |
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 condition |
| D. | ALL conditions |
| Answer» B. AND conditions | |
| 4. |
In the context of Microsoft Access, which of the following statement is true? |
| A. | Reports are used to retrieve andcalculate 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 |
| Answer» D. Reports and forms are similar but forms are use to print but reports to display on screen only | |
| 5. |
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 |
| Answer» D. Any of these can be done to create relationship | |
| 6. |
The expression builder is an access tool that controls an expression___ for entering an expression |
| A. | Table |
| B. | Box |
| C. | Cell |
| D. | Palette |
| Answer» C. Cell | |
| 7. |
Which field type will you select if you need to enter long text in that field? |
| A. | Text |
| B. | Memo |
| C. | Currency |
| D. | Hyperlink |
| Answer» C. Currency | |
| 8. |
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. | CreateTable By Entering Data |
| D. | All of Above |
| Answer» D. All of Above | |
| 9. |
Which of the following is not a type of MS Access databaseobject? |
| A. | Table |
| B. | Form |
| C. | Worksheets |
| D. | Modules |
| Answer» D. Modules | |
| 10. |
The size of a field with number data type can not be _____ |
| A. | 2 |
| B. | 4 |
| C. | 8 |
| D. | 16 |
| Answer» E. | |
| 11. |
Ho 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 of above |
| D. | None of above |
| Answer» D. None of above | |
| 12. |
The size of yes/no field is always ________ |
| A. | 1 Bit |
| B. | 1 Byte |
| C. | 1 Character |
| D. | 1 KB |
| Answer» B. 1 Byte | |
| 13. |
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. |
| Answer» C. It indicates whether the field names to be displayed in query result or not. | |
| 14. |
Which of the following option creates a Drop Down List of values ? |
| A. | Ole Object |
| B. | Hyperlink |
| C. | Memo |
| D. | Lookup Wizard |
| Answer» E. | |
| 15. |
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 |
| Answer» E. | |
| 16. |
Which option allows us to build a new table by entering data directly into a tabular grid ? |
| A. | Datasheet View |
| B. | Design View |
| C. | LinkedTable |
| D. | Grid View |
| Answer» B. Design View | |
| 17. |
Thecommandcenter of Access File thatappearswhen wecreateor open the MSAccess databaseFile. |
| A. | Database Window |
| B. | Query Window |
| C. | Design View Window |
| D. | Switchboard |
| Answer» B. Query Window | |
| 18. |
Which field type can store photos? |
| A. | Hyperlink |
| B. | OLE Object |
| C. | Both can be used |
| D. | It is not possible |
| Answer» C. Both can be used | |
| 19. |
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 |
| Answer» D. Desc | |
| 20. |
How many characters you can type in maximum while writing the field name? |
| A. | 60 |
| B. | 64 |
| C. | 68 |
| D. | Any Number Of Character |
| Answer» C. 68 | |
| 21. |
Which of the following database object hold data? |
| A. | Forms |
| B. | Reports |
| C. | Queries |
| D. | Tables |
| Answer» E. | |
| 22. |
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 |
| Answer» D. Pivot Query | |
| 23. |
When creating a new table which method can be used to choose fields from standard databases and tables |
| A. | CreateTable In Design View |
| B. | CreateTable Using Wizard |
| C. | CreateTable by entering data |
| D. | None of Above |
| Answer» C. CreateTable by entering data | |
| 24. |
Microsoft Access is a ______ kind of application ? |
| A. | RDBMS |
| B. | OODBMS |
| C. | ORDBMS |
| D. | Network Database Model |
| Answer» B. OODBMS | |
| 25. |
Which of the following is not a field type in Microsoft Access ? |
| A. | Memo |
| B. | Hyperlink |
| C. | Ole Object |
| D. | Lookup Wizard |
| Answer» E. | |
| 26. |
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 |
| Answer» E. | |
| 27. |
The upper part of the query design window in MS Access has two parts shows ____________ |
| A. | Fields name with field size |
| B. | Fields name with relationships |
| C. | Fields and Criteria |
| D. | Sorting Options |
| Answer» C. Fields and Criteria | |
| 28. |
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 |
| Answer» C. Write criteria values separated by AND | |
| 29. |
Which of the following is not a type of relationship that can be applied inAccess database? |
| A. | One to One |
| B. | One to Many |
| C. | Many to Many |
| D. | All of above |
| Answer» E. | |
| 30. |
Which feature is used to duplicate a control's formatting ? |
| A. | Manager |
| B. | Wizard |
| C. | Painter |
| D. | Control |
| Answer» D. Control | |
| 31. |
Which kind of query that displays its own dialog box prompting you for entering information before executing ? |
| A. | Select Query |
| B. | Crosstab Query |
| C. | Parameter Query |
| D. | Dialog Query |
| Answer» D. Dialog Query | |
| 32. |
While creating relationship, what happens when you releasemousepointer after you drop the primary key of a table into foreign key of another table? |
| A. | A relationship is created |
| B. | Edit relationship dialog boxappears |
| C. | A connector symbol is created |
| D. | A connecting Line is visible |
| Answer» C. A connector symbol is created | |
| 33. |
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 ensures 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 |
| Answer» D. It is used to delete all the records of related tables in a database | |
| 34. |
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 (e.g photo) |
| D. | It is optional. We can use Report instead of Form |
| Answer» C. It is used for storing special data other than text (e.g photo) | |
| 35. |
Which operator is used to filter and display rows when all (two or more) conditions are satiesfied ? |
| A. | RANGE |
| B. | IN |
| C. | ALL |
| D. | AND |
| Answer» D. AND | |
| 36. |
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 |
| Answer» B. Relationships | |
| 37. |
The columns in a microsoft access table are also called _______ |
| A. | Rows |
| B. | Records |
| C. | Fields |
| D. | Columns |
| Answer» D. Columns | |
| 38. |
While creating relationship using mouse, how the the mousepointer looks like? |
| A. | A thick plus sign |
| B. | A thin plus sign |
| C. | An outlined rectangle |
| D. | Arrow with Plus sign |
| Answer» D. Arrow with Plus sign | |
| 39. |
how can you define a field so that when entering data ##### is displayed? |
| A. | Input Mask |
| B. | Validation Rule |
| C. | Indexed |
| D. | Ime Mode |
| Answer» B. Validation Rule | |
| 40. |
Which of the following is a method tocreatea new table inMS Access? |
| A. | Using Design View |
| B. | CreateTable Wizard |
| C. | Directly Entering Data |
| D. | All of Above |
| Answer» E. | |
| 41. |
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 above |
| Answer» E. | |
| 42. |
The small button with three dots displayed at the right of field properties box is called : |
| A. | Make Button |
| B. | Expression Button |
| C. | Build Button |
| D. | None Of Above |
| Answer» D. None Of Above | |
| 43. |
Which of the following shows the final result in a presentable way ? |
| A. | Forms |
| B. | Reports |
| C. | Queries |
| D. | Tables |
| Answer» C. Queries | |
| 44. |
Which of the following storecommandto gather data from database? |
| A. | Forms |
| B. | Reports |
| C. | Queries |
| D. | Tables |
| Answer» D. Tables | |
| 45. |
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 |
| Answer» D. Comparison operation | |
| 46. |
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 & 64000 Characters |
| D. | 8KB and 1.5 MB |
| Answer» B. 8 And 1 Gb | |
| 47. |
How can we remove a relationship defined between two tables ? |
| A. | From Edit menu (by chosing Delete Relationship) |
| B. | Select the relationship line and press Delete |
| C. | Choose Delete option from Relationship menu |
| D. | Choose Remove option from Relationship menu |
| Answer» C. Choose Delete option from Relationship menu | |