Vu All Subjects Assignment Quiz GDB Handouts Available here
Dear Students
ICS403 Quiz#1 Lecture 1 to 10 Spring Fall 2022 /CS403 midterm quiz and mcq 100% correct or right solution.
CS403 Quiz 1 Mcqs Lecture 1 to 10 Spring 2022 #Mid-Term WITH PROVE ANSWER
In database development process, which of the following is
related to requirement gathering phase?
Detailed study of application
In the below entity type which attribute can work as an
alternate key?Employee ( Reg# Primary key,Name ,CNIC,designation,address,phone)
CNIC
External schema evolves, as user needs are _______ over the
time.
Modified
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