WorksheetsMIS ERDDB QUIZ
Total questions: 28
Worksheet time: 14mins
Name
Class
Date
1.
A collection of related data stored in a manner so it can be retrieved as needed is known as _____________
a)
Process
b)
Database
c)
Library
d)
None of the Above
2.
A specific field that uniquely identifies the records in a table, used in a relational database to relate tables is known as ______________
a)
Foreign Key
b)
Primary Key
c)
Record Key
d)
Entity Key
3.
Oracle DB, IBM DB2, Microsoft SQL Server, MS Access, MongoDB are all examples of ___________________
a)
Enterprise Management Systems
b)
Software Management Systems
c)
Process Management Systems
d)
Database Management Systems
4.
A ____________ helps to create, maintain, and access databases. <br />
a)
ERP
b)
CRM
c)
DBMS
d)
None of the Above
5.
______________ describe the charecteristics of an Entity
a)
Tuples
b)
Records
c)
Keys
d)
Attributes
6.
__________________ are examples of Entities
a)
Class of Objects
b)
Type of People
c)
Services
d)
Products
e)
All of the Above
7.
Aadhar Card and Citizen of India exhibit ________ type of relationship
a)
1 to 1
b)
1 to Many
c)
Many to Many
d)
None of the Above
8.
Account Holder and Credit Cards typically exhibit ________ type of relationship
a)
1 to 1
b)
1 to Many
c)
Many to Many
d)
None of the Above
9.
Students and Courses typically exhibit ________ type of relationship
a)
1 to 1
b)
1 to Many
c)
Many to Many
d)
None of the Above
10.
If two entities have a 1:1 relationship then typically in a DB it will have _________________
a)
1 Table
b)
2 Table
c)
3 Table
d)
4 Table
11.
If two entities have a 1:M relationship then typically in a DB it will have _________________
a)
1 Table
b)
2 Table
c)
3 Table
d)
4 Table
12.
If two entities have a 1:M relationship then typically in a DB it will have _________________
a)
1 Master Table
b)
1 Master and 1 Transaction Table
c)
2 Master Tables and 1 Transaction Table
d)
None of the Above
13.
If two entities have a M:M relationship then typically in a DB it will have _________________
a)
1 Master Table
b)
1 Master and 1 Transaction Table
c)
2 Master Tables and 1 Transaction Table
d)
None of the Above
14.
If two entities have a 1:M relationship then typically in a DB the _________________
a)
Foreign key of the Master Table is the foreign key in the transaction table
b)
Primary key of the Master Table is the foreign key in the transaction table
c)
Primary key of the Master Table is the Primary key in the transaction table
d)
Foreign key of the Master Table is the Primary key in the transaction table
15.
____________________ identifies a unique record in the Table
a)
Foreign Key
b)
Field Key
c)
Primary Key
d)
Subject Key
16.
PAN Card - Citizen relationship is an example of __________________ relationship
a)
One to Many
b)
One to One
c)
One to Two
d)
Many to Many
17.
Rows in a database table are known as ______________________
a)
Fields
b)
Lines
c)
Rules
d)
Records
18.
Columns in a database table are known as ______________________
a)
Fields or Attributes
b)
Lines
c)
Rules
d)
Records
19.
________________is a database design technique that reduces data redundancy<br />
a)
FORMALIZATION
b)
NORMALIZATION
c)
NATIONALIZATION
d)
DIGITALIZATION
20.
_______________ is a collection of servers at a dedicated and secure place.
a)
Database
b)
Datahub
c)
Datacenter
d)
Databin
21.
The purpose of Normalization is to eliminate _______________data
a)
Remote
b)
Redundant (repetitive)
c)
Recorded
d)
Responsive
22.
Child to Mother is a _____________ entity relationship
a)
One to Many
b)
One to One
c)
Many to Many
d)
Many to One
23.
____________________eliminates undesirable characteristics like Insertion, Update and Deletion anomalies<br />
a)
FORMALIZATION
b)
NORMALIZATION
c)
NATIONALIZATION
d)
DIGITALIZATION
24.
A table is said to be in the 1NF if ________________________
a)
Each table cell should contain a single value.<br />and each record needs to be unique, have a primary key<br />
b)
It should have a foreign key
c)
It should be in a table form
d)
It should be in 2NF
e)
All of the Above
25.
A table is said to be in the 2NF if _____________________________
a)
All non-key attributes are fully functional dependent on the primary key and it is in the 1 NF<br />
b)
It should have a foreign key
c)
It should be in a table form
d)
It should be in 1NF
e)
All of the Above
26.
A table is said to be in the 2NF if _____________________________
a)
All Transitive Dependencies are removed and it is in the 2 NF<br />
b)
It should have a foreign key
c)
It should be in a table form
d)
It should be in 2 NF
e)
All of the Above
27.
A database typically consists of:
a)
Tables (Collection of related records),
b)
Fields or Columns (Single category of data to be stored in a database (name, telephone number,)
c)
Records or Rows (Collection of related fields in a database (all the fields for one customer…)
d)
All of the above
28.
In a database there is one Customer Master Table with the following fields (CustID, CustName, CustAddress, CustDoB where CustID identifies each Customer uniquely) and one Product Master Table with the following fields (ProdtID, ProdtName, Prodt Description where ProdtID identifies each Product uniquely). The records from these two Master Tables are fetched into a Billing Transaction Table using the following foreign keys:
a)
CustID, ProdtID, BillID
b)
CustID, ProdtID
c)
CustID, BillID
d)
ProdtID, BillID
e)
None of the Above
100 %
