Home/Tests/Test/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

Please wait...

Question 1 of 20

Computer Science

1. This key uniquely identifies each record.

1.Unique Key

2.Key Record

3.Primary Key

4.Field Name

Question 1 of 20

Question 2 of 20

2. Microsoft Access is a

1.ORDBMS

2.RDBMS

3.Network Database Model

4.OODBMS

Question 2 of 20

Question 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.Delete all the fields from third downwards and re-enter the required fields again.

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

3.Select the third row in table design view then delete

4.Select the third column in datasheet view then delete

Question 3 of 20

Question 4 of 20

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

1.Text

2.Currency

3.Hyperlink

4.Memo

Question 4 of 20

Question 5 of 20

5. 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 5 of 20

Question 6 of 20

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

1.Tables

2.Relationships

3.Queries

4.Reports

Question 6 of 20

Question 7 of 20

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

1.All of these

2.Tuple

3.Record

4.Field

Question 7 of 20

Question 8 of 20

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

1.Many to Many

2.One to Many

3.One to One

4.All of above can be applied

Question 8 of 20

Question 9 of 20

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

1.Query window

2.Switchboard

3.Database window

4.Design view window

Question 9 of 20

Question 10 of 20

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

1.Memo

2.Lookup Wizard

3.Hyperlink

4.Ole Object

Question 10 of 20

Question 11 of 20

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

1.Query

2.Relationship

3.Join

4.None of these

Question 11 of 20

Question 12 of 20

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

1.Pivot Table & Pivot Chart View

2.Datasheet View

3.All of these

4.Design View

Question 12 of 20

Question 13 of 20

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

1.Form

2.Query

3.Report

4.Table

Question 13 of 20

Question 14 of 20

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

1.A relational database has no databases

2.Two

3.Five

4.One

Question 14 of 20

Question 15 of 20

15. What are the columns in a table called?

1.Fields

2.Rows

3.Records

4.Columns

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.None of these

3.Create Table Using Wizard

4.A and B

Question 16 of 20

Question 17 of 20

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

1.Any number of characters

2.60

3.68

4.64

Question 17 of 20

Question 18 of 20

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

1.120

2.265

3.255

4.75

Question 18 of 20

Question 19 of 20

19. Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship command?

1.Tools Menu

2.File menu

3.View Menu

4.Database Menu

Question 19 of 20

Question 20 of 20

20. The file extension for an Access database is

1.EXE

2.DOC

3.MDB

4.EXC

Question 20 of 20

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.

Other Related Tests

Punjab 11th Class Physics Chapter 9 Physical O...
Punjab 12th Class Computer Chapter 12 Using Qu...
Punjab 11th Class Biology Chapter 3 Enzymes Mc...
Punjab 12th Class Physics Chapter 3 Electromag...
Punjab 10th Class Math Chapter 11 Practical Ge...
Punjab 9th Class Math Chapter 8 Linear Graphs ...
Punjab 12th Class Pak Study Chapter 8 National...
Punjab 9th class Urdu Poem Barsat Ki Baharain ...
Punjab 12th Class Biology Behaviour Mcqs Test ...
Punjab 11th Class Physics Chapter 1 Measuremen...

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

Test Name

Subject

Test Type

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