Olympiad Test: MS Access - 2 | 20 Questions MCQ Test National Cyber Olympiad Class 8 Class 8

QUESTION: 1

What are the different views to display a table

A.
Datasheet View
B.
Design View
C.
Pivot Table & Pivot Chart View
D.
All of above

Solution:

QUESTION: 2

Which of the following creates a drop down list of values to choose from?

A.
Ole Object
B.
Hyperlink
C.
Memo
D.
Lookup Wizard

Solution:

QUESTION: 3

The command center of access file that appears when you create or open the ms access database file.

A.
Database Window
B.
Query Window
C.
Design View Window
D.
Switchboard

Solution:

QUESTION: 4

The third stage in designing a database is when we analyze our tables more closely and create a ______ between tables

A.
Relationship
B.
Join
C.
Query
D.
None of these

Solution:

QUESTION: 5

In a database table, the category of information is called ______

A.
Tuple
B.
Field
C.
Record
D.
All of above

Solution:

QUESTION: 6

This key uniquely identifies each record

A.
Primary Key
B.
Key Record
C.
Unique Key
D.
Field Name

Solution:

QUESTION: 7

It is an association established between common

A.
Line
B.
Relationship
C.
Primary K ey
D.
Records

Solution:

QUESTION: 8

This is the stage in database design where one gathers and list all the necessary fields for the database project.

A.
Data Definition
B.
Data Refinement
C.
Establishing Relationship
D.
None of above

Solution:

QUESTION: 9

A database language concerned with the definition of the whole database structure and schema is ______

A.
DCL
B.
DML
C.
DDL
D.
All of above

Solution:

QUESTION: 10

Which of the field has width 8 bytes?

A.
Memo
B.
Number
C.
Date/Time
D.
Hyperlink

Solution:

QUESTION: 11

Which of the following statement is true?

A.
Foreign key fields don’t allow duplicate values
B.
In primary key field you can enter duplicate value
C.
In an indexed field you may or may not enter duplicate value depending upon setting
D.
All statements are true

Solution:

QUESTION: 12

Following is not a database model

A.
Network Database Model
B.
Relational Database Model
C.
Object Oriented Database Model
D.
None

Solution:

QUESTION: 13

Microsoft access is a

A.
RDBMS
B.
OODBMS
C.
ORDBMS
D.
Network Database Model

Solution:

QUESTION: 14

DCL provides commands to perform actions like

A.
Change the structure of tables
B.
Insert, update or delete records and data values
C.
Authorizing access and other control over database
D.
None of above

Solution:

QUESTION: 15

The database language that allows you to access or maintain data in a database

A.
DCL
B.
DML
C.
DDL
D.
None of above

Solution:

QUESTION: 16

What is the maximum length a text field can be?

A.
120
B.
255
C.
265
D.
75

Solution:

QUESTION: 17

Which of the following is not a database object?

A.
Tables
B.
Queries
C.
Relationships
D.
Reports

Solution:

QUESTION: 18

A ______ enables you to view data from a table based on a specific criterion

A.
Form
B.
Query
C.
Macro
D.
Report

Solution:

QUESTION: 19

What are the columns in a microsoft access table called?

A.
Rows
B.
Records
C.
Fields
D.
Columns

Solution:

QUESTION: 20

Which of the following is not a type of microsoft access database object?

A.
Table
B.
Form
C.
Worksheets
D.
Modules

Solution:

Olympiad Test: MS Access - 2

20 Questions MCQ Test National Cyber Olympiad Class 8 | Olympiad Test: MS Access - 2

What are the different views to display a table

Which of the following creates a drop down list of values to choose from?

The command center of access file that appears when you create or open the ms access database file.

Recommended Content

NCERT Textbook: Resources

NCERT Solutions: Comparing Quantities- 1

NCERT Solutions: Data Handling- 1

Chapter Notes (Part - 2) - Resources

What is Soil Preparation?

Recommended Tests

Olympiad Test: Integers

Test: Nutrition in Animals

Test: Globe Latitudes And Longitudes

Test: Environment

Test: Nutrition in Plants- 1

Download free EduRev App

Similar Content

MS access

MS- ACCESS DBMS

MS Access and its Components

MS Excel: Logical Test

Related tests

Olympiad Test: MS Access - 2

Olympiad Test: MS Access - 1

Test: MS Access- 2

Olympiad Test: MS Powerpoint - 2

Test: MS Access- 1

Schools

Competitive Examinations

Quick Access Links

Technical Exams