Vu All Subjects Assignment Quiz GDB Handouts Available here
Dear Students
In this post we are providing you CS403 Quiz 1 Mcqs Lecture 1 to 10 Spring Fall 2022 100% correct or right solution.
CS403 Quiz 1 Mcqs Lecture 1 to 10 Spring 2022 #Mid-Term WITH PROVE ANSWER
Which of the following change can
cause problem in database levels?
Deleting an attribute from the
database structure……confirm
In data based development process
which of the following is related to requirement
gathering phase.
Detailed study of system….confirm
Which of the following is correct
about database modeling?
Process of creating the logical structure of the database……confirm
A relationship is an association
between two entities or between an entity and itself.
The diamond symbol for a
relationship is _______ if one of the participants is
dependent on the other.
Doubled…..confirm
Which of the following is
incorrect related to secondary key?
Selected key must be unique
identifier…..confirm
In database system the description
and definition of data is stored in __________.
Schema….confirm
A candidate key that does not have
a null value and is selected to uniquely identify
all other attribute values in any
given row is called a ______.
Primary key….confirm
Which of the following is Not
related to the management of data in the database?
How data will be transformed…..confirm
In entity-relationship diagram the
entity type which has existence dependency
constant is classified as:
Weak entity…..confirm
Which of the following to the
semantic Data Model?
E-R data model…..confirm
Detailed data flow diagram is
created for only those processes from the _____ for
which we want to show the details.
Level 0 diagram…..confirm
The total participation by
entities is represented in E-R diagram as:
Double line….confirm
Which of the following is the
major drawback of file processing system?
Non-sharing of data
A relationship that involves three
entities called.
Ternary relationship….confirm
The entity relationship model
consists of the following major constructs
___________.
Entity, Attribute and
relationship…..confirm
The DBMS uses the ______ to access
the database at each layer or model.
Data Dictionary…..confirm
Which of the following is the best
description of the data security in DBMS?
Efficient Check on all users
access…..confirm
Consider the following tables
EMP(empld, empName, qual, depld)
DEPT(depld, depName, numEmp)
The primary key of EMP table is
_____ whereas foreign key of EMP table is _____.
Empld, depld
Which of the following Greek
letter is used to denote the select operation?
( ) Greek sigma symbol……confirm
In relational data model, a record
or an entity instance is represented as ____ in a
relation.
Row…confirm
While mapping many-to-many
relationship ______ table(s) are created.
Three
Select and project are the
examples of ___________.
Unary Operation…..confirm
In natural join the common
attribute in the output table appears _____.
Once…..confirm
RDM is simple there is just one
structure and that is ______.
a Relation or a table….confirm
RDM stands for ________.
Relational Data model….confirm
Which of the following constant
states that if a foreign key exists in a relation either
the foreign key value must match
the primary key value of some tuple in its home
relation or the foreign key value
must be completely null?
Referential Integrity
Constraint….confirm
Which constraint is generally used
for efficiency purpose in the data entry process.
Default value…..confirm
The relationship between
department to employees is .
One to many….confirm
A row of a table represents a
________ whereas the column of the table represents
the _________.
Record, Attribute….confirm
Which is not the function of
Database Management System?
Failure Response Service
The conceptual database design can
be transformed into any .
Data model
Which of the following is the
second stage in the database development process?
Requirement Analysis
Functional dependencies under
interference rule reflexivity are called
dependencies.
Trivial
If many instances of the “Book”
entity are associated with the many instances of the
“Student” entity, then the
relationship between them is:
Many to many
Which of the following constraints
enforces entity integrity?
PRIMARY KEY
Unary operations involves
Only one relation
A entity has a primary key that is
partially or totally derived from the parent
entity in the relationship.
Weak
Business
Relationship
In _______ appropriate data model
is chosen.
Logical Database Design
Which of the following is drawback
of standardization?
Lack of uniqueness
Recursive relationship is also
called .
Unary
The foreign key attribute, which
is present as a primary key in another relation is
called as
of the foreign key attribute.
Binary relation
Home relation
DFD does not provide us a way to
represent
Decisions
A ________ is used to maintain a
connection between the users of the database
system.
File server…confirm
Which of the following is an
advantage of using the Traditional File Organization?
Simplicity
Which of the following is the
input to Analysis Phase?
DFD
Name and _______ are part of the
definitions of an attribute.
Domain
Which of the following most
certainly implies the need for an entire table to
implement?
A ternary relationship
Core of the Database Architecture
is
Internal level
__________ is same as equi-join
with a slight difference.
Natural join
Which of the following database
environment causes a network overhead?
File server…..confirm
Conceptual database design is
implemented using a .
Semantic data model
Which constraint is generally used
for efficiency purposes in the data entry process?
Default value
A 3 NF relation is converted to
BCNF by
Dependent attributes of overlapping
composite keys are put in a separate
relation
Each _____ of a table contains
atomic/single value.
Cell
A relation is said to be in BCNF
when
It has no overlapping composite
keys which have related attributes
Which one of the following is not
a part of three-level architecture?
Physical level
Which of the following is
INCORRECT about naming entities?
Always use abbreviations as they
are convenient
An instance is
Any particular entity
_______ is an example of metadata
Student
Level of data at which entities or
objects exist in reality is called
Real world data
There are ______ basic properties
of the database relations.
Six
How many types of dependencies
are?
Three…(existence dependency,
Identifier dependency, referential
dependency)…….confirm
In ______ join, only selected rows
of a relation are made cross product with
second relation.
Theta
Which of the following is not a
key?
Integrity constraint key….confirm
A collection of concepts that can
be used to describe the structure of a database
Data model
Any combination of attributes with
super key is
Super key
Binary relationships are those,
which are established between
Two entity type
_______ are called participants,
when enrolled in a relationship.
Entities
Incase of Context-level Diagram,
the system is represented by
One process only
Collection of raw facts is called
.
Data
A software package designed to
store and manage database
DBMS
In ______ join common attributes
appear twice in the output with selected rows.
Equi join
Within a table, each primary key
value .
Must be unique…..confirm
Must be numeric
Must be unique
______ is not an operation of
relational algebra.
Addition
Candidate keys which are not
selected as primary key are called
Alternate keys
Internal schema/view defines the
___ of the data.
Structures…confirm
Major benefits of data sharing is:
Data of different application
places at same place
Functional dependency between two
attributes or sets of attributes i.e. Q and P is
represented as .
Q ? P
Which of the following is not the
component of Relational Data Model?
Manipulation Language
The attribute that is calculated
from other attribute is called .
Derived attribute
Consider the two attributes
“CNIC_NO” and “Registration_NO”. Both the attributes can be used for the unique
identification. Now if the user selects the “CNIC_NO” as primary key, then
“Registration_NO” is a_________ key.
Alternative
Which of the following constraint
is included in the definition of the table?
Null
The database deals with large
amount of data. This property is called
Scalability
Which one of the following is NOT
a characteristic of meta data?
Includes user data…..confirm
Theta join is denoted
mathematically as . R X ?
S
In cross reference matrix
transitions are specified on and database objects are specified on .
Y axis, Y axis
Each component of DBMS performs
functions.
Different
Which of the following data model
is not record based?
Hierarchical Data Model
Network Data model
Semantic Data model
The basic purpose of diamond in ER
diagram is to show them.
Relationships
Which of the following tool is
used to design conceptual database design?
This model is independent of any
tool
In “one to many” cardinality one
instance of a relation is mapped.
Many instances of second entity
type
Cross reference matrix is
developed at the ______ stage of the database.
Designing
User rights information is stored
in
Catalog
Which of the following is
incorrect about attributes?
One entity type may have two attributes
with same name……confirm
Logical data independency provides
independency to change _ model.
Conceptual
In natural join the common attribute
in the output table appears .
Once
Which levels are mostly used for
detailed DFD?
Level-0, Level-1…..confirm
By default, a non-key attribute in
a relation can have ______ value.
Null
The three levels architecture is
useful for.
Hiding the details of internal
systems
With the help of _____ technique
data values with the smaller sized codes can further reduce the space needed by
the data for storage in the database.
Compression
If an entity is linked with
itself, than it is called _______ relationship.
Recursive
Duplication of data in controlled
redundancy is controlled and .
Deliberate…..confirm
Teleprocessing is a sub-type of
______ .
Multi-user database
In an ERD, the focus is on the
_____ and the relationships between them.
Entities
the most widely used conceptual
model is the____ model.
ER
Student and book are two entities,
what is the cardinality between the two?
Many too many
RDM is a simple there is just one
structure and that is .
A relation or a table
A description on a particular
collection of data using the given data model.
Database
Consider thy key “CNIC, Name” and
choose the best option that describes the key most effectively.
The given key is a super key and
candidate key as well.
Normalization is a process of
restricting a relation to
Minimize duplication of data in a
database
Unary relationship involves a
single entity it is also called _ .
Recursive relationship….confirm
Which of the following is a part
of a DFD but not included in the ERD?
The external entity having a
single instance
The database management system
(DBMS) is used to
All of above
In cross reference matrix
attributes are mention on _____ and reports are mention on
X axis, Y axis
A table can be logically connected
to another table by defining a ______.
Primary key…..confirm
In the relation model, the number
of attributes and number of tuples in a relation are termed as ________ and ________respectively.
degree, cardinality
The function that an entity plays
in a relationship is called that entity’s ________.
Role
A database system is designed to
meet the information needs of __________ in an organization.
Multiple users
Which of the following is the
example of a strong entity?
Ahmad account of ABC bank has no
existence if the ABC bank doesn’t
exist anymore
Which of the following is a
completeness constraint?
Partial Completeness Constraint
In an employee entity which of the
following attribute will work as a primary
key?
Employee id
____________ is the first
computer-based approach for handing the
commercial or business
applications
Database Systems
Which of the following is NOT the
classification of entity type?
Dependent entity type
Which of the following is NOT the
type of key?
Derived key
Data Redundancy means
Duplication of data
Which of the following is a type
of dependency?
Referential
In your opinion, why relational
database is widely acceptable?
Due to its dependencies
is the first comprehensive
complete database design.
Conceptual database design
How data security can be assured
in the database?
Implementing encryption algorithms
The attributes whose value is not
stored in a database is known as _
attribute.
Derived….confirm
Logical database design, like
conceptual database design is our
Database design
If a single instance of “student”
is associated with the many instances of the
“subjects” entity, then the
relationship between them is:
One to many
The conceptual database design is
drawn through .
ER model
A relational database is
One that consists of two or more
tables that are joined in some way .
Data, information
Information, data
In which stage of the database
development process logical design is created?
Implementation
Which of the following is NOT an
entity?
Playground
After moving the determined
columns from the original table to the new table while converting to 2NF, the
determinate becomes the of the new table.
Primary key
Binary operator
Project operator
Free standing data dictionary is
created by
CASE tools
A patient can be an outdoor or
indoor. Analyze this statement and tell what
type of constraint will be applied
on patient?
Total completeness
If A ? B and A ? C, then A ? BC.
The inference Rule applies is:
Union
Which of the following is the
correct abbreviation of ERD?
Entity relationship diagram
Database relation is also
represented in a two dimensional structure called
Table
Which of the following specifies
the number of instances of one entity that
can or must be associated with
each instance of another entity?
Cardinality view…..confirm
Data about data is metadata
True
Which of the following describes
the job of a database administrator?
Monitoring and controlling
database security and authorization: setting up
controls to ensure the quality and
integrity of data….confirm
Each table must have a ______ key.
Primary
A relational database system is
based on the concept(s) of:
Tables, row and columns
A ? BC and A ? B, then A ? C
follow inference rule.
Projectivity
Suppose, we have two entities
“shape” and “triangle”, then which of the following is a correct statement?
Shape is a super type entity and
triangle is a sub type entity
The entity that is NOT dependent
on any other entity for its existence is known as entity.
Strong
In cross reference matrix
attributes are specified on
X axis
Which of the following clarify the
semantics of a relationship?
Roles
How many types of cardinality is
specified about relationship?
Four
Which of the following is NOT a
component of a DFD?
Relationship between external
entities
Which of the following provides us
the facility to add properties of one entity
to another entity automatically?
Inheritance
If there is more than one
relationship between two entities and we mentioned
role on the relationship link,
then it is called:
Multiple relationships
Which one of the following is not
an advantage of DBMS
Recovery procedure is difficult
In many to many relationship a
third table is created for the relationship,
which is also called as _
Associative entity type
When one entity instance of
another entity for its existence, then it is called
Existence dependency
Relational data model is widely
accepted due to its mathematically proven
foundation and its
Simplicity
If an entity “motor cycle” is
associated with at most one “driver”, then the
relationship between these two
entities is:
One to one
Database application is a program
which is used for performing certain
operations such as
Insertion of data, Extraction of
data, Updating the data….All of above
Creating the relationships between
new tables and their predecessors through the use of foreign keys is general
requirements of
Second normal form
In the domains of attributes of a
relation are atomic, that is they consist
of single units that cannot be
broken down further.
First normal form
Atomicity is a feature of .
1NF
The_______ can see entire
information structure of the database.
DBA
The attribute whose value is not
stored in a database is known as
attribute.
Derived
are the structure defined for
placing data in the attributes while
designing physical design of
database.
Data types
Suppose a relation has five
columns and ten rows, select the correct option to
identify cardinality of relation.
Ten….confirm
Which feature of database provides
conversion from inconsistent state of DB
to a consistent state ensuring
minimum data loss?
Recovery service
Consider an employee is allotted
an organization vehicle, which might soley be driven by that employee. What
kind of relationship exists between employee and company?
Many to one
Which of the following is a
feature of CHECK constant?
used to enforce referential
integrity
Which of the following semantic
model is used for the graphical
representation to the conceptual
database design?
Entity Relationship (ER)
Suppose we have two entities
department and University. Which type of
dependency exists between these
two entities?
Referential (Not sure)
__________ is the next stage of
conceptual database design.
logical database design
The ______ model is independent of
any tool or data model.
Entity Relationship (ER) (page
122)
While converting to 2NF all the
columns are deleted from the original table
except for the determinate which
will serve as a ________ key.
Primary key
In relational algebra, which of
the following operator is used to find tuples
that are present in one relation
but are not in another?
Union
Subject may be the prerequisite of
another subject, is the example of ______
relationship.
Unary (google)
The maximum PL/SQL size of data
type “VARCHAR2” in DBMS is
bytes a)
32767
is state of database where a
“course” cannot be inserted in the table,
because this course has not been
registered to any “student”.
Insertion anomaly
The maximum PL/SQL size of data
type “BLOG” in DBMS is
4 gigabytes
states that in a relation no
attributes of a primary key (PK) can have a
null value.
Entity integrity constraint
A database state where deletion of
the information about the student record
deletes the course information as
well is called .
Deletion anomaly
An entity type is
A coherent set of similar objects
that we want to store data on (e.g.
STUDENTS, COURSE, CAR)
External scheme evolves as user
needs are ____ over the time.
Modified
An attribute that is the
collection of some other attribute(s) is known as _
attributes.
Composite
Which of the following is correct
regarding Dataflow diagram?
Created at increasing levels of
detail
Used to represent the
relationships among the external entities are those
attributes that are a combination
of two or more than two attributes.
Composite attributes
Controlling redundancy in a
database management system DOES NOT help
to
avoid unauthorized access to data
Which of the following concepts is
applicable with respect to 3NF?
Transitive dependency
Identify the operation which is
NOT one of the parts of the five basic set
operations in relational algebra?
Join
Making a change to the conceptual
schema of a database but not affecting
the existing external schemas is
an example of
Logical data independence.
For a third normal form we
concentrate on relations with one ______ key,
and we eliminate transitive
dependencies
Candidate
The entity relationship diagram is
used to graphically represent the
database model.
Conceptual
The _____ determines that the link
between two entities is optional or
mandatory.
Minimum cardinality
Select the most appropriate
statement. Which of the following data model is
used to design logical database
design?
Relational
________ are used by database
administrator in situations where we have
large
number of records and wastage of
small amount of space in each record can lead to
loss of huge amount of data
storage space.
Codes
An attribute in a relation is
foreign key If the ________ key from one relation
is used as an attribute in that
relation.
Primary….confirm
in data flow diagram which of the
following operator is used, when data
flows from a source process to one
of the mentioned sinks?
Ring Sum Operator
The _______ rule specifies that an
entity can be a member of only one
subtype at a time.
disjoint page no 108
In relational algebra, which of
the following Greek is used to represent the
project operator?
? (PI) (page no 150)
In three level architecture of the
database, which level is helpful to display
data which is not actually placed
in the database?
External Level….confirm
Which of the following normal
forms deals multivalued dependency?
4NF
While mapping ___________
relationship, primary key of the entity type
against one side of relationship
will be included in the entity type on the many side
of the relationship as foreign
key.
one to many
In data flow diagram ________
symbol is used to represents data flows.
arrow (google)
In the below entity type which
attribute can work as an alternate key?
Employee (Reg# Primary
key,Name,CNIC,designation,address,phone)
CNIC
From the following who is
responsible for proper working of the database
and DBMS?
Database administrator
Suppose that “Program” is an
entity which represents different courses are being offered by an institute,
like MCS. BCS etc. Following are the major attributes of this entity. Identify
the attribute which can be used as primary key.
program_ Code
The following is an of _______
inference rule.
If stId –> prName and prName
–> credits then stId –> credits
Transitivity
Which of the following is the
example of a weak entity?
The tire can exist without being
attached to the car
In Relational Data Model, the
_______ of a relation is the number of columns in that relation
Degree
Which of the following normal form
deals with possible loss less decompositions?
5NF
Suppose we have a list of bank
customers which availed loan facility from different branches of a bank. If we
want to get a list of all customers and the amount of the loans excluding
branch name. Which of the following operation allows us to generate this
relation?
Union
Which of the following provides us
data independency?
3-Level Architecture
Cross reference matrix is a tool
available in the data dictionary, which helps us in finding ____.
Entities of the database and their
associations
Conceptual database design, expressed
in E-R data model can be implemented using any ______.
Database Management System (DBMS)
Which of the following might be
represented with a single-valued attribute?
Computer’s processor speed
Which of the following is a Unary
operation?
Project
193. Which of the following data
model has the following components?
Construct (Tables)
Manipulation language (SQL)
integrity constraints?
Relational
Which of the following Greek is
used to represent the select operation?
s (page 149)
Data about data is called
metadata.
True (page no 10)
Normalization of database is used
to ______.
Eliminate redundancy
In student entity which of the
following is the best example of multivalued
attribute?
Email address
Theta join is denoted
mathematically as
R X theta S
In which normal form, we convert
composite attributes into individual
attributes?
1NF
Which of the following tool is
used to graphically represent the components
and design of the system?
DFD
Data type “BLOB” in database
management system stands for _________.
Binary Large Object (page no 185)
In a three level DBMS architecture,
the ________ level interacts directly with
the users.
External
In the Database System ___________
provides many features to ensure the data integrity.
Database Management System (DBMS)
The process of defining one or
more subtypes of super and forming relationships is known as
Generalization
External scheme evolves, as user
needs are _______ over the time.
Switch
______ of the Database is most
difficult to change when a database is created.
Extension
In Database development process,
which phase involves designing of any new application for the enhancement of
the system?
Maintenance phase….confirm
An attribute of one entity is
associated with another attribute of the same entity is called:
Recursive relationship….confirm
Relational Data model is created
in the __________ phase.
Analysis
Database system saves lots of
efforts and finances, this advantage provides
________.
Time saving structure
Data inconsistency leads to a
number of a problems such as _______. loss of information and incorrect results
Every primary key (PK) will be a
candidate key and every candidate key will be a ______.
Super key
If we want to include attributes
from two different relations, which of the following operations will be used?
Union
When have two entities “Person”
and “Doctor. Which of all is best suitable type of relationship between the
mentioned entities?
Inheritance…..confirm
Thanks everone