Monday, August 9, 2021

Database Management System (KMBIT04) MCQ Set 4

 

DBMS (KMBIT04) MCQ

Q.

What do you mean by one to many relationship between Teacher and Class table?

A.

One class may have many teachers

B.

One teacher can have many classes

 

C.

Many classes may have many teachers

D.

Many teachers may have many classes

 

Answer : One teacher can have many classes [Option : B]



Q.

What are the different view to present a Table ?

A.

Datasheet View

B.

Design View

 

C.

Pivote TableView

D.

All Of Above

 

Answer : All Of Above [Option : D]



Q.

In one-to-many relationship the table on 'many' side is called _______

A.

Parent

B.

Child

 

C.

Sister

D.

Master

 

Answer : Child [Option : B]



Q.

In which state one gathers and list all the necessary fields for the database design project.

A.

Data Definition

B.

Data Refinement

 

C.

Establishing Relationship

D.

None Of The Above

 

Answer : Data Definition [Option : A]



Q.

Which of the following enables us to view data from a table based on a specific criterion

A.

Form

B.

Query

 

C.

Macro

D.

Report

 

Answer : Query [Option : B]



Q.

Which database object is ideal to view, change, andanalyze datain different ways ?

A.

Table

B.

Form

 

C.

Query

D.

Report

 

Answer : Query [Option : C]

Q.

In one-to-many relationship the table in 'one' side is called _______

A.

Child

B.

Owner

 

C.

Parent

D.

Owner

 

Answer : Parent [Option : C]

Q.

Which data type allows alphanumeric characters and special symbols to be entered?

A.

Text

B.

Memo

 

C.

Auto number

D.

Mixed

 

Answer : Text [Option : A]



Q.

It is used to establish an association between related tables.

A.

Line

B.

Relationship

 

C.

Primary Key

D.

Records

 

Answer : Relationship [Option : B]

Q.

This key that uniquely identifies each record is called :

A.

Primary Key

B.

Key Record

 

C.

Unique Key

D.

Field Name

 

Answer : Primary Key [Option : A]

Q.

Which name must be unique within a database ?

A.

Table

B.

Field

 

C.

Record

D.

Character

 

Answer : Table [Option : A]

Q.

The third stage of designing a database is when we create___________ between tables

A.

Relationship

B.

Join

 

C.

Query

D.

None of These

 

Answer : Relationship [Option : A]

Q.

Two tables can be linked with relationship to _____

A.

Ensure data entry

B.

Ensure data integrity

 

C.

Create Primary Key

D.

Ensure Foreign Key

 

Answer : Ensure data integrity [Option : B]

Q.

In a database Table, the each category of information Is called __________

A.

Tuple

B.

Field

 

C.

Record

D.

All Of Above

 

Answer : Field [Option : B]

Q.

Which of the following fields has width of 8 bytes?

A.

Memo

B.

Number

 

C.

Date/time

D.

Hyperlink

 

Answer : Date/time [Option : C]

Q.

which of the following is not a database object?

A.

Tables

B.

Queries

 

C.

Relationships

D.

Reports

 

Answer : Relationships [Option : C]

Q.

Which one is the guideline of Referential integrity in a relationship ?

A.

Do not enter a value in the primary key field of chield table if that value does not exist inthe primary key of the parent table

B.

Do not enter a value in the foreign key field of a parent table if that value doesnot exist in the primary key of the child table

 

C.

Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table

D.

Do not enter a value in the foreign key field of child table if that value does not exist inthe foreign key of the parent table

 

Answer : Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table [Option : C]

Q.

Which of the following is not a database model

A.

Network Database Model

B.

Relational Database Model

 

C.

Object Oriented Database Model

D.

None

 

Answer : None [Option : D]

Q.

The overall description of a database is called______.

A.

Data integrity

B.

Data manipulation

 

C.

Database schema

D.

Data definition

 

Answer : Database schema [Option : C]

Q.

A data dictionary is a repository that manages _____

A.

Memory

B.

Metadata

 

C.

Spell Checker

D.

Data Validator

 

Answer : Metadata [Option : B]


No comments:

Post a Comment

NEET College Predictor 2023

EET College Predictor 2023 NEET college predictor is a tool to assist medical aspirants in predicting top medical colleges based on their NE...