computer MCQs - 12th class Chapter 06 Mcqs

1

In a relational database, data is stored in what fundamental structure?

A

Queries

B

Forms

C

Tables

D

Reports

2

What is another term for a table in a relational database?

A

Record

B

Relation

C

Field

D

Object

3

Which of the following is NOT a characteristic of a relational table?

A

Each row is distinct

B

The order of columns is material

C

Each cell contains only one value

D

The order of rows is immaterial

4

The number of fields in a relation is called the __________ of a table.

A

Cardinality

B

Domain

C

Degree

D

Schema

5

The number of records in a relation is called the __________ of the relation.

A

Degree

B

Attribute

C

Tuple

D

Cardinality

6

In Microsoft Access, what does IDE stand for?

A

Integrated Design Environment

B

Integrated Development Environment

C

Internal Development Engine

D

Interface Design Engine

7

Which view in Access allows you to define fields and their data types before adding data?

A

Datasheet View

B

Layout View

C

PivotTable View

D

Design View

8

Which view in Access is similar to an Excel worksheet and is used for entering raw data?

A

Design View

B

Datasheet View

C

Form View

D

Report View

9

What is the maximum number of characters allowed in a Text data type field in Access?

A

64

B

255

C

512

D

64,000

10

Which data type is used for detailed descriptive fields and can store more than 64,000 characters?

A

Text

B

OLE Object

C

Memo

D

Hyperlink

11

Which data type automatically assigns a unique integer to a new record?

A

Number

B

AutoNumber

C

Text

D

Primary Key

12

An OLE object in Access can be which of the following?

A

A sound, picture, or Word document

B

Only a picture

C

Only a sound file

D

Only a text file

13

What is the default field size for the Text data type?

A

255

B

100

C

50

D

10

14

Which field property is used to control the display format of data, such as converting text to lowercase?

A

Field Size

B

Input Mask

C

Format

D

Validation Rule

15

In Text format property, what does the '>' symbol do?

A

Converts characters to lowercase

B

Indicates a required character

C

Converts characters to uppercase

D

Indicates an optional character

16

Which property specifies criteria for the data entered into a field?

A

Default Value

B

Validation Rule

C

Indexed

D

Required

17

An Input Mask like '(@@@) @@@-@@@@' is typically used for what kind of data?

A

Date/Time

B

Currency

C

Telephone Number

D

Postal Code

18

What is the primary purpose of a Primary Key?

A

To sort the table data

B

To uniquely identify each record in a table

C

To link to external websites

D

To store large amounts of text

19

How is a primary key field often marked in the Design View?

A

With a star image

B

With a plus image

C

With a key image

D

With a checkmark image

20

If no existing field provides unique values, what data type does Access suggest for a new primary key field?

A

Text

B

Number

C

Autonumber

D

Yes/No

21

Which wizard helps you create tables using predefined templates?

A

Table Wizard

B

Query Wizard

C

Form Wizard

D

Report Wizard

22

How can you add a new record in Datasheet View?

A

By clicking the asterisk (*) symbol

B

By using the 'Add Record' wizard

C

By right-clicking a column header

D

By going to the File menu

23

To delete an entire column in Datasheet view, you select it and choose __________ from the menu bar.

A

Edit Delete Column

B

File Delete

C

Tools Remove Field

D

Format Delete

24

What feature in Access allows you to keep certain columns visible while you scroll through others?

A

Hiding Columns

B

Resizing Columns

C

Locking Columns

D

Freezing Columns

25

Which command is used to locate data in a datasheet quickly?

A

Search

B

Lookup

C

Find

D

Locate

26

What is the function of the 'Replace All' button in the Find and Replace dialog box?

A

Replaces only the first occurrence

B

Replaces all occurrences in one step

C

Finds the next value to replace

D

Replaces values in a different table

27

Relationships between tables are established by linking which of the following?

A

A primary key in one table to a foreign key in another

B

Two fields with the same name

C

Two fields with the Text data type

D

The first field of each table

28

What does 'Enforce Referential Integrity' ensure?

A

Data is not accidentally lost or invalidated

B

All tables have a primary key

C

All fields have validation rules

D

The database is password protected

29

What is a 'join' in the context of relational databases?

A

The process that makes relationships work

B

A type of query

C

A way to merge two databases

D

A tool for sorting data

30

If Cascade Update Related Fields is selected, changing a primary key value in the parent table will do what?

A

Delete the related records in the child table

B

Prevent any changes to the primary key

C

Automatically update the foreign key value in related records

D

Create a copy of the related records

31

The feature that allows you to view only those records that meet certain criteria is called?

A

Sorting

B

Indexing

C

Filtering

D

Relating

32

What does the wildcard character '*' represent in a query criterion?

A

A single character

B

Any number of characters

C

A numeric digit only

D

A required character

33

What does the wildcard character '?' represent in a query criterion?

A

Any number of characters

B

A numeric digit between 0 and 9

C

A single character

D

An optional character

34

A collection of records selected by a query is called a __________.

A

Dynaset

B

Tableset

C

Recordset

D

Toolset

35

Which type of query makes changes to records, such as deleting or updating them?

A

Select Query

B

Action Query

C

Parameter Query

D

Crosstab Query

36

An Append Query is a type of Action Query that does what?

A

Deletes a group of records

B

Makes changes to existing records

C

Adds records to the end of a table

D

Creates a new table

37

Which type of query prompts the user for information when it is run?

A

Crosstab Query

B

Select Query

C

Append Query

D

Parameter Query

38

Which query calculates a sum, average, or count on data that is grouped by two types of information?

A

Parameter Query

B

Crosstab Query

C

Action Query

D

SQL Query

39

In the query design grid, where do you specify the conditions that records must meet to be included in the results?

A

Sort row

B

Show row

C

Criteria row

D

Field row

40

To find a four-character name that starts with 'H', which criteria would you use?

A

H*

B

H???

C

H###

D

H&

41

Which function in a query finds the total of the values in a field?

A

Avg

B

Count

C

Sum

D

Max

42

Which function counts the number of non-null values in a field?

A

Count

B

Sum

C

Total

D

Number

43

The 'Is Null' criterion in a query is used to find records where the field has __________.

A

a value of zero

B

no value

C

a text value

D

a negative value

44

What does a Delete Query do?

A

Deletes a table

B

Deletes a database

C

Deletes a group of records

D

Deletes a single field

45

Which wizard is specifically designed to find records with duplicate values in a field?

A

Simple Query Wizard

B

Crosstab Query Wizard

C

Find Duplicates Query Wizard

D

Find Unmatched Query Wizard

46

What is the term for the rule that ensures consistency between related tables?

A

Join Integrity

B

Relational Integrity

C

Referential Integrity

D

Database Integrity

47

In the query design grid, what does the 'Expression' calculation type do?

A

Calculates a standard deviation

B

Finds the first field value

C

Creates a calculated field using a formula

D

Averages the values

48

To sort records in a query, which row in the design grid do you use?

A

Criteria

B

Sort

C

Field

D

Table

49

Which data type would be most appropriate for storing a person's date of birth?

A

Text

B

Number

C

Date/Time

D

AutoNumber