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

• <<
• 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. Microsoft Access is a

1.Network Database Model

2.ORDBMS

3.RDBMS

4.OODBMS

Question 1 of 20

Question 2 of 20

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

1.One

2.Five

3.A relational database has no databases

4.Two

Question 2 of 20

Question 3 of 20

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

1.Hyperlink

2.Ole Object

3.Lookup Wizard

4.Memo

Question 3 of 20

Question 4 of 20

4. The file extension for an Access database is

1.MDB

2.EXE

3.DOC

4.EXC

Question 4 of 20

Question 5 of 20

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

1.Reports

2.Queries

3.Tables

4.Relationships

Question 5 of 20

Question 6 of 20

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

1.Datasheet View

2.Design View

3.All of these

4.Pivot Table & Pivot Chart View

Question 6 of 20

Question 7 of 20

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

1.All of above can be applied

2.Many to Many

3.One to Many

4.One to One

Question 7 of 20

Question 8 of 20

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

1.Currency

2.Hyperlink

3.Memo

4.Text

Question 8 of 20

Question 9 of 20

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

1.68

2.60

3.Any number of characters

4.64

Question 9 of 20

Question 10 of 20

10. To create relationship between two tables:

1.Any of above can be done to create relationship

2.Drag the primary key of a table into foreign key of another table

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

4.Drag the foreign key of a table into the primary key of another table

Question 10 of 20

Question 11 of 20

11. What are the columns in a table called?

1.Columns

2.Records

3.Fields

4.Rows

Question 11 of 20

Question 12 of 20

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

1.Tuple

2.Field

3.Record

4.All of these

Question 12 of 20

Question 13 of 20

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

1.Database Menu

2.File menu

3.Tools Menu

4.View Menu

Question 13 of 20

Question 14 of 20

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

1.Database window

2.Query window

3.Switchboard

4.Design view window

Question 14 of 20

Question 15 of 20

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

1.255

2.75

3.265

4.120

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 Using Wizard

2.A and B

3.Create Table In Design View

4.None of these

Question 16 of 20

Question 17 of 20

17. This key uniquely identifies each record.

1.Primary Key

2.Unique Key

3.Field Name

4.Key Record

Question 17 of 20

Question 18 of 20

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

1.Query

2.Form

3.Report

4.Table

Question 18 of 20

Question 19 of 20

19. 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.Select the third row in table design view then delete

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

4.Select the third column in datasheet view then delete

Question 19 of 20

Question 20 of 20

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

1.Relationship

2.Join

3.None of these

4.Query

Question 20 of 20

 Loading...

 

Other Related test

• Punjab 10th Class Urdu Chapter 11 Ali Baksh Mcqs Test Online
• Punjab 12th Class English Good Bye Mr. Chips Chapter 15 MCQs Test Online
• Punjab 12th Class Chemistry d and f Block Elements Mcqs Test Online
• Punjab 9th Class Islamiat Chapter 3 Ilm Ki Farziyat o Fazeelat Mcqs Test Online
• Punjab 10th Class English Chapter 1 Hazrat Muhammad (SAW) An Embodiment of Justice Mcqs Test Online
• Punjab 10th Class Physics Chapter 3 Geometrical Optics Mcqs Test Online
• Punjab 11th Class Chemistry Acids Bases and Salts Mcqs Test Online
• Punjab 9th Class Urdu Model Paper 6 Mcqs Test Online
• Punjab 9th Class Chemistry Model Paper 8 Mcqs Test Online
• Punjab 11th Class Math Chapter 11 Trigonometric Functions and Their Graphs Mcqs Test Online