DBMS (KMBIT04) MCQ
|
Q. |
What
do you mean by one to many relationship between Teacher and Class table? One class may have
many teachers One teacher can have
many classes Many classes may have
many teachers 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 ? Datasheet View Design View Pivote TableView All Of Above Answer
: All
Of Above [Option : D]
|
|
Q. |
In
one-to-many relationship the table on 'many' side is called _______ Parent Child Sister Master Answer
: Child [Option
: B]
|
|
Q. |
In
which state one gathers and list all the necessary fields for the database
design project. Data Definition Data Refinement Establishing
Relationship 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 Form Query Macro Report Answer
: Query [Option
: B]
|
|
Q. |
Which
database object is ideal to view, change, andanalyze datain different ways ? Table Form Query Report Answer
: Query [Option : C] |
|
Q. |
In
one-to-many relationship the table in 'one' side is called _______ Child Owner Parent Owner Answer
: Parent [Option : C] |
|
Q. |
Which
data type allows alphanumeric characters and special symbols to be entered? Text Memo Auto
number Mixed Answer
: Text [Option : A]
|
|
Q. |
It
is used to establish an association between related tables. Line Relationship Primary
Key Records Answer
: Relationship [Option : B] |
|
Q. |
This
key that uniquely identifies each record is called : Primary
Key Key
Record Unique
Key Field
Name Answer
: Primary Key [Option : A] |
|
Q. |
Which
name must be unique within a database ? Table Field Record Character Answer
: Table [Option : A] |
|
Q. |
The
third stage of designing a database is when we create___________ between
tables Relationship Join Query None
of These Answer
: Relationship [Option : A] |
|
Q. |
Two
tables can be linked with relationship to _____ Ensure
data entry Ensure
data integrity Create
Primary Key Ensure
Foreign Key Answer
: Ensure data integrity [Option : B] |
|
Q. |
In
a database Table, the each category of information Is called __________ Tuple Field Record All
Of Above Answer
: Field [Option : B] |
|
Q. |
Which
of the following fields has width of 8 bytes? Memo Number Date/time Hyperlink Answer
: Date/time [Option : C] |
|
Q. |
which
of the following is not a database object? Tables Queries Relationships Reports Answer
: Relationships [Option : C] |
|
Q. |
Which
one is the guideline of Referential integrity in a relationship ? 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 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 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 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 Network
Database Model Relational
Database Model Object
Oriented Database Model None Answer
: None [Option : D] |
|
Q. |
The
overall description of a database is called______. Data
integrity Data
manipulation Database
schema Data
definition Answer
: Database schema [Option : C] |
|
Q. |
A
data dictionary is a repository that manages _____ Memory Metadata Spell
Checker Data
Validator Answer
: Metadata [Option : B] |
