Before starting our second DBMS MCQ Question, Let’s know the terms Data Processing that is widely used in Database Management systems.
Data Processing: The carrying out of operations on data, especially by a computer, to retrieves, transforms, or classifies information. Broadly, speaking data processing is the collection and manipulation of items of data to produce meaningful information. In this sense, it can be considered a subset of information processing,. The process of processing the input data by the CPU of the computer for giving meaningful results as output is known as data processing.
DBMS MCQ Questions and Answer Set 2
21. How can you define a field so that when entering data for that field it will display ********* instead of actual typed text
| A. Input Mask | B. Validation Rule |
| C. Indexed | D. IME MOde |
A. Input Mask
22. To sort records in table
| A. Open table, click on the field on which the sorting is to be done, then click the sort button on the database toolbar |
| B. Open table, Click sort button on database toolbar, choose field based on which to sort, click Ok |
| C. Click the field heading to sort it ascending or descending |
| D. All of above |
A. Open table, click on the field on which the sorting is to be done, then click the sort button on the database toolbar
23. To create a relationship between two tables
| A. Drag the primary key of the table into the foreign key of another table |
| B. Drat the foreign key of a table into the primary key of another table |
| C. Drag any field from the parent table and drop it on the child table |
| D. Any of the above can be done to create a relationship |
A. Drag the primary key of the table into the foreign key of another table
24. After entering all fields required for a table, if you realize that the third field is not needed, how will your remove it?
| A. You need to delete the whole tab. There is no method to remove a particular field only. |
| B. Delete all the fields from third downwards and recenter the required fields again. |
| C. Select the third column in datasheet view then delete |
| D. Select the third row in the table design view then Delete |
D. Select the third row in the table design view then Delete
25. To duplicate a controls formatting you can use …….
| A. Manager | B. Wizard |
| C. Painter | D. Control |
C. Painter
26. Which field type will you select when creating a new table if you require to enter long text in that field?
| A. Text | B. Memo |
| C. Currency | D. Hyperlink |
B. Memo
27. In the table design view what are the first column of buttons used for
| A. Indicate Primary Key | B. Indicate Current Row |
| C. Both of above | D. None of the Above |
C. Both of above
28. What does the show check box in the 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 or not |
| C. It indicates whether the field names to be displayed in query result or not |
| D. None of the above |
B. It indicates whether the field is to be displayed in query or not
29. 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 the above can be applied |
D. All of the above can be applied
30. The complete information about an entity is a database is called
| A. Data | B. Information |
| C. Field | D. Record |
D. Record
31. Database Management System is featured with
| A. The facility to easy editing, spelling check, auto pagination, layout, and printing reports. |
| B. The ability to store large quantities of data to facilitate easy update, sort, and retrieval |
| C. The ability to calculate efficiently with the help of built-in functions and analyze |
| D. All of above |
B. The ability to store large quantities of data to facilitate easy update, sort, and retrieval
32. Which of the following can be an example of a database?
| A. Address book of all the suppliers of a company |
| B. Salary sheet of all the employees of a company |
| C. Records of daily sales transactions of a company |
| D. All of the above |
D. All of the above
33. An access database object that is used to enter, view, or edit records
| A. table | B. Form |
| C. Query | D. Report |
B. Form
34. Which of the following expresses correct order?
| A. Characters, Fields, Records, Tables, Files, Databases |
| B. Files, Database, Tables, Records, Fields, Characters |
| C. Characters, Fields, Records, Tables, Database, Files |
| D. Databases, Tables, Files, Records, Field, Character |
A. Characters, Fields, Records, Tables, Files, Databases
35. Every table in a relational database contain a field or combination of fields that can uniquely identify each record, it is called
| A. Foreign Key | B. Native Key |
| C. Composite Key | D. Primary Key |
D. Primary Key
36. if I create the ‘Student’ field in the ‘fees’ table to store ‘student_id’ of the ‘Students’ table, then this ‘Student’ field in ‘Fees table is called
| A. Foreign Key | B. Native Key |
| C. Composite Key | D. Primary Key |
A. Foreign Key
37. A composite key is
| A. Required when a table does not have any unique fields in it. |
| B. The primary key with Auto Number as the field type |
| C. Made up of two or more fields to uniquely identify records |
| D. Is a foreign key that uniquely identifies records. |
C. Made up of two or more fields to uniquely identify records
38. A primary key in any table has the properties
| A. Not Full | B. No duplicates |
| C. Both of Above | D. None of the Above |
C. Both of Aboves
39. To create a primary key for a table when in design view
| A. Type Primary in field type box when creating required field |
| B. Mark the primary check box in field name of required field |
| C. Click the primary key button in the Design ribbon when the cursor is in the required field |
| D. None of above |
C. Click the primary key button in the Design ribbon when the cursor is in the required field
40. How can you link a table with another so that a field in the current table will display values in the drop down box from another table while entering data
| A. Query Wizard | B. Look Up Wizard |
| C. Form Wizard | D. Report Wizard |
B. Look Up Wizard
