Punjab 12th Class Computer Chapter 9 Introduction to Access Database Mcqs Test Online

Please wait...

• <<
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• >>

 

Question 1 of 20

Computer Science

1. In designing a database, when we analyze our tables more closely we create a _________ between tables.

1.None of these

2.Relationship

3.Join

4.Query

Question 1 of 20

Question 2 of 20

2. Which of the following database object is created first before any other created?

1.Table

2.Query

3.Form

4.Report

Question 2 of 20

Question 3 of 20

3. This key uniquely identifies each record.

1.Field Name

2.Unique Key

3.Primary Key

4.Key Record

Question 3 of 20

Question 4 of 20

4. What are the columns in a table called?

1.Records

2.Columns

3.Fields

4.Rows

Question 4 of 20

Question 5 of 20

5. When entering field name, how many characters you can type in maximum?

1.60

2.68

3.Any number of characters

4.64

Question 5 of 20

Question 6 of 20

6. What are the different views to display a table?

1.Datasheet View

2.Pivot Table & Pivot Chart View

3.All of these

4.Design View

Question 6 of 20

Question 7 of 20

7. The file extension for an Access database is

1.EXE

2.MDB

3.DOC

4.EXC

Question 7 of 20

Question 8 of 20

8. The command center of Access file that appears when you create or open the Access database file.

1.Switchboard

2.Design view window

3.Query window

4.Database window

Question 8 of 20

Question 9 of 20

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

1.Reports

2.Tables

3.Relationships

4.Queries

Question 9 of 20

Question 10 of 20

10. In a database table, the category of information is called __________.

1.All of these

2.Field

3.Tuple

4.Record

Question 10 of 20

Question 11 of 20

11. 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 the primary key of a table into foreign key of another table

4.Drag any field from parent table and drop on child table

Question 11 of 20

Question 12 of 20

12. 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.Database Menu

4.Tools Menu

Question 12 of 20

Question 13 of 20

13. Which field type will you select when creating a new table if you want to enter long text in that field?

1.Hyperlink

2.Text

3.Memo

4.Currency

Question 13 of 20

Question 14 of 20

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

1.75

2.120

3.255

4.265

Question 14 of 20

Question 15 of 20

15. A relational database must have at least how many databases?

1.A relational database has no databases

2.Two

3.Five

4.One

Question 15 of 20

Question 16 of 20

16. Which of the following is a method to create a new table in ms access?

1.Create Table In Design View

2.Create Table Using Wizard

3.None of these

4.A and B

Question 16 of 20

Question 17 of 20

17. Which of the following is not a field type in Access?

1.Memo

2.Ole Object

3.Lookup Wizard

4.Hyperlink

Question 17 of 20

Question 18 of 20

18. Microsoft Access is a

1.RDBMS

2.OODBMS

3.ORDBMS

4.Network Database Model

Question 18 of 20

Question 19 of 20

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

1.One to One

2.One to Many

3.All of above can be applied

4.Many to Many

Question 19 of 20

Question 20 of 20

20. 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 delete

2.Delete all the fields from third downwards and re-enter the required fields again.

3.Select the third column in datasheet view then delete

4.You need to delete the whole table. There is no method to remove a particular field only.

Question 20 of 20

 Loading...

 

Other Related test

• Punjab 12th Class Physics Chapter 10 Nuclear Physics Mcqs Test Online
• Punjab 12th Class Urdu Mureed Pur Ka Peer Mcqs Test Online
• Punjab 12th Class Math Chapter 4 Introduction to Analytical Geometry Mcqs Test Online
• Punjab 10th Class Computer Science Chapter 3 Input and Output Handling Mcqs Test Online
• Punjab 11th Class Physics Chapter 1 Measurements Mcqs Test Online
• Punjab 11th Class Biology Chapter 6 Kingdom Prokaryotae of Life Mcqs Test Online
• Punjab 11th Class Math Chapter 12 Application of Trigonometry Mcqs Test Online
• Punjab 11th Class Physics Chapter 8 Waves Mcqs Test Online
• Punjab 11th Class English It’s Country For Me Mcqs Test Online
• Punjab 11th Class Chemistry Chapter 2 Experimental Techniques in Chemistry MCQs Test Online