Punjab 12th Class Computer Chapter 9 Introduction to Access Database Mcqs Test Online Punjab 12th Class Computer Chapter 9 Introduction to Access Database Mcqs Test Online 1234567891011121314151617181920Show paginator Hide paginator Question 1 of 20Computer Science 1. To create relationship between two tables: 1.Drag the foreign key of a table into the primary key of another table 2.Any of above can be done to create relationship 3.Drag any field from parent table and drop on child table 4.Drag the primary key of a table into foreign key of another table Question 1 of 20Question 2 of 20 2. What is the maximum length a text field can be? 1.255 2.120 3.265 4.75Question 2 of 20Question 3 of 20 3. After entering all fields required for a table, if you realize that the third field is not needed, how will you remove? 1.Select the third row in table design view then delete2.Select the third column in datasheet view then delete 3.You need to delete the whole table. There is no method to remove a particular field only. 4.Delete all the fields from third downwards and re-enter the required fields again. Question 3 of 20Question 4 of 20 4. Which of the following database object is created first before any other created? 1.Table 2.Query 3.Form 4.Report Question 4 of 20Question 5 of 20 5. What are the columns in a table called? 1.Records 2.Fields 3.Rows 4.ColumnsQuestion 5 of 20Question 6 of 20 6. Which of the following is a method to create a new table in ms access? 1.Create Table Using Wizard 2.None of these 3.Create Table In Design View 4.A and B Question 6 of 20Question 7 of 20 7. A relational database must have at least how many databases? 1.One 2.A relational database has no databases 3.Two 4.Five Question 7 of 20Question 8 of 20 8. When entering field name, how many characters you can type in maximum? 1.Any number of characters2.60 3.64 4.68 Question 8 of 20Question 9 of 20 9. Which of the following is not a database object? 1.Reports 2.Queries 3.Tables 4.Relationships Question 9 of 20Question 10 of 20 10. The file extension for an Access database is 1.EXC 2.MDB3.DOC 4.EXE Question 10 of 20Question 11 of 20 11. Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship command? 1.View Menu 2.File menu 3.Tools Menu 4.Database Menu Question 11 of 20Question 12 of 20 12. Which of the following is not a field type in Access? 1.Memo 2.Lookup Wizard 3.Ole Object 4.Hyperlink Question 12 of 20Question 13 of 20 13. In a database table, the category of information is called __________. 1.Tuple 2.All of these3.Field 4.Record Question 13 of 20Question 14 of 20 14. Which field type will you select when creating a new table if you want to enter long text in that field? 1.Text 2.Hyperlink3.Currency 4.Memo Question 14 of 20Question 15 of 20 15. What are the different views to display a table? 1.Pivot Table & Pivot Chart View 2.All of these 3.Datasheet View 4.Design View Question 15 of 20Question 16 of 20 16. The command center of Access file that appears when you create or open the Access database file. 1.Design view window 2.Query window 3.Database window 4.Switchboard Question 16 of 20Question 17 of 20 17. Which of the following is not a type of relationship that can be applied in Access database? 1.Many to Many 2.One to One 3.One to Many 4.All of above can be applied Question 17 of 20Question 18 of 20 18. In designing a database, when we analyze our tables more closely we create a _________ between tables. 1.None of these2.Query 3.Join 4.Relationship Question 18 of 20Question 19 of 20 19. This key uniquely identifies each record. 1.Key Record 2.Field Name 3.Primary Key 4.Unique Key Question 19 of 20Question 20 of 20 20. Microsoft Access is a 1.OODBMS 2.Network Database Model3.RDBMS 4.ORDBMS Question 20 of 20 Loading... Test By Subject Punjab Test By Topics 11th Class Computer You Can Learn and Gain more Knowledge through our Online Quiz and Testing system Just Search your desired Preparation subject at Gotest.