InterviewSolution
Saved Bookmarks
InterviewSolution
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
When Memo data type is preferred over Text type for a field? |
|
Answer» When the length of the field is more than 255 characters. Text data type is not capable to store the project description because its length cannot be more than 255 characters so, Memo data type is preferred over the Text data type. |
|
| 2. |
What data type should you choose for a zipcode field in a table?(a) Text (b) Number (c) Memo (d) All of these |
|
Answer» (b) Number data type should be chosen for a zip code field in a table. |
|
| 3. |
Write one example of each field, for which you would use1. Text data type2. Memo data type |
|
Answer» 1. Text data type It allows to store text or combination of text and numbers as well as numbers that don’t require calculations such as phone number. This data type allows maximum 255 characters to store. e.g. if Employee is a table and Emp_No, Name and Description are fields, then name will be a Text field. Because, name is a character entry field. 2. Memo data type It allows long blocks of text that uses text formatting, e.g. in the Employee table, the field Description will be of Memo data type, because the length of description of employee may be large. |
|
| 4. |
Which field properties are used in Office Access 2007? Give the purpose of each field property. |
||||||||||||||||||||||||||||||||||||
|
Answer» Field Properties After you create a field and set its data types, you can also set additional field properties. Setting field properties can give the database extra flexibility and functionality. Some important properties of field are as follows:
|
|||||||||||||||||||||||||||||||||||||
| 5. |
Give any one difference between freezing a field and hiding a field. |
|
Answer» When you freeze a field, then no matter how far you scroll down in a datasheet, you will always see the frozen field. But, when you hide a field, then it means that the field is not displayed on the screen. |
|
| 6. |
What is a primary key? How do we set a primary key? |
|
Answer» Primary key is the key which is used to uniquely identify the records into the table. To set the primary key you have to follow the steps given below: Step 1 Select the field that you want to set as a primary key. Step 2 Click Primary Key button from the Design tab. or Right click on the selected field and select Primary Key. |
|
| 7. |
What is Fixed Field Length? |
|
Answer» It refers to a type of field length in which the number of characters you enter will be fixed. |
|
| 8. |
Write one example of data field for which you would set the Required property to Yes? |
|
Answer» In a table, when we declare a field as a primary key, then the field’s Required property must be set to Yes because, in a primary key field, we need to enter data always. |
|
| 9. |
What is the purpose of Default Value field property? |
|
Answer» If there is a situation when you want to enter the same value for all records. Then, to avoid typing the same thing many times, you can set as a Default Value property. |
|
| 10. |
The default data type for a field is(a) Number(b) AutoNumber(c) Currency(d) Text |
|
Answer» (d) The default data type for a field is Text. |
|
| 11. |
The following table named SummerCamp shows part of the information kept on children attending the summer camp in Shimla.Child IDFirst NameLast NameDOBGenderGroup109VedanshGupta30/06/10M2A214MackTyagi09/12/08M1B115AditiThakur13/04/09F1A108VikrantChauhan02/02/09M2A141SwatiSaini06/05/10F2B233VishakhaTyagi01/08/10F3A274MadhuGupta06/03/10M3B1. State the number of fields in’the above table.2. State the number of records in the above table.3. Give one reason why SummerCamp would add a record.4. Give one reason why SummerCamp would edit a record.5. Give one reason why SummerCamp would delete a record.6. Give any two data types used in the table. |
|
Answer» 1. Number of fields-6 2. Number of records-7 3. If a new child joins the SummerCamp, then SummerCamp would add a record to the table. 4. If a child is shifted from one group to another, then SummerCamp would edit a record in the table. 5. If any child leaves the SummerCamp, then SummerCamp would delete a record of that child from the table. 6. Text and Date/Time. |
|
| 12. |
Which property is used to add a label to the field to assist the user?(a) Default value(b) Caption(c) Format(d) Indexed |
|
Answer» (b) Caption is used to add a label to the field for assisting to the user. |
|
| 13. |
Answer the following questions based on the database given below:1. Identify the primary key and justify your answer.2. Suggest suitable data type for Unit_Cost and justify your answer.3. If the database is sorted in ascending order of UnitCost. What is the product name of last record?4. How will you ensure that Supplier_No must not be empty?5. To add the details of new product, what should the user add: record or field? Write the steps for the same.6. How will you ensure that ‘1’ must appear in Supplier_No, if no value is entered?7. How many records and fields are there in the above table?8. It is needed to add photograph of the product in the database. Which is suitable data type for the same? |
|
Answer» 1. The primary key of the given table Product will be Prod _Id because no two products have the same Product_Id. So, it will be uniquely identified for each record in the table. 2. The suitable data type for the field Unit_Cost is Number because this field in the table contains the value in numbers only. 3. Crayons. 4. By setting the Required property to Yes. 5. To add the details of the new product the user should add a record. The steps are as follows: Step 1 Open the database. Step 2 Open the table in which you want to add a record in a Datasheet View. Step 3 If you open the table, a new blank record will automatically appear at the end of the table. Step 4 Type the data into the fields. Step 5 Save the table. 6. By setting the property Default Value which is to be set as 1. 7. Records = 8, Fields = 8 8. The data type OLE Object is suitable for adding the photograph of the product to the table. |
|
| 14. |
Which data type helps you to handle input that is in boolean format?(a) OLE Object(b) Attachment(c) Yes/No(d) None of these |
|
Answer» (c) Yes/No will allow boolean value. |
|
| 15. |
Pronita is a programmer in an institution and is asked to handle the records containing personal information of the teachers teaching in the institution. Use the information to give the answer of the following questions (1) to (3). 1. Suggest five held names, which you think must be present in the table Teacherlnfo and why? 2. Give the data type of the suggested fields. 3. Which held is most likely to be the key field and why? |
|
Answer» Suggested five fields are as follows: 1. TCode —> To store the code of the teachers. TName —> To store the name of the teachers. TSubject —> To store the name of subjects for which the teacher is placed in the institution. Address —> To store the address of the teachers. Salary —> To store the monthly income of the teachers. 2. TCode —> Text TName —> Text TSubject —> Text Address —> Text Salary —> Number 3. TCode is most likely to be the key field because it has a unique value for each of the records. |
|
| 16. |
Microsoft Access is an example of(a) Computer(b) DBMS(c) CPU(d) Device |
|
Answer» (b) MS-Access is the DataBase Management System (DBMS) found in the Microsoft Office suite. |
|
| 17. |
Consider the following database:Product CodeProduct NameDate of saleQtySoldCustomer NameAmountP001Pencil05/10/115Himanshu25P002Eraser04/01/124Ali8P003Sharpner09/12/116Deepak12P004Whitener25/04/112Ankit30P005Glue Pen20/07/123Ruchi301. Write the name of the field that contains numeric data.2. Identify the primary key field in the database.3. Identify the field type of the DateofSale field.4. Identify the names of the fields that contain textual data.5. The given table contains how many fields and records?6. Which property should you use, if you want to make sure that the QtySold entered is less than 10? |
|
Answer» 1. Qty Sold and Amount fields 2. ProductCode field 3. Date/Time data type 4. ProductCode, ProductName and CustomerName fields 5. 6 fields and 5 records 6. Validation Rule |
|
| 18. |
Damini is a programmer in an institute and is asked to handle the records containing information of students. Suggest any 5 fields name and their data type of students database. |
||||||||||||
Answer»
|
|||||||||||||
| 19. |
Look at the given table called ‘Item’ and answer the questions.ItemIdItemNameItemStockItemDOPQuanity Purchased1. Suggest the data types of all the fields.2. Which two fields can act as the primary key from the above table? |
|
Answer» 1. ItemID —> Text ItemName —> Text ItemStock —> Number ItemDOP —> Date QuantityPurchased —> Number 2. ItemID and ItemName can act as primary key. |
|
| 20. |
When you define a field for a table, which of the following parameters do Access always consider optional?(a) Field Name(b) Data Type(c) Field Size(d) Description |
|
Answer» (d) Description field of the table is optional, as it depends on the database designer that he/she wants to describe a field or not. |
|
| 21. |
The ………….. field property makes data entry compulsory, so that the field cannot be left blank. |
|
Answer» The Required field property makes data entry compulsory so that the field cannot be left blank. |
|
| 22. |
Explain field length with its types. |
||||||||||||||||||||||||
|
Answer» It refers to the maximum number of characters that a field can contain. Each character requires one byte for its storage. Field length is of two types which are as follows: 1. Fixed length field It is a type of field length in which the number of characters you enter in a field is fixed. These are present in Format option in Data Type Formatting group (in Datasheet tab) such as Currency, Euro, Percent etc. 2. Variable length field In this type of field length, the number of characters is not fixed. Actually, the number of characters of the data entered in the field decide the field length. The field length or field size of each data type are as follows:
|
|||||||||||||||||||||||||