? Minimize insertionanomolies ? Minimize deletionanomolies ? Minimize updationan
ID: 3615881 • Letter: #
Question
? Minimize insertionanomolies
? Minimize deletionanomolies
? Minimize updationanomolies
? Maximize redundancy
Which of the following is NOT a component of a DFD?
? Dataflow
? Datastore
? External entities
? Relationship betweenexternal entities
Which of the following is correct regarding Dataflowdiagram?
? Single DFD is required to represent a system
? the dataflow must be bidirectional
? Created at increasing levels of detail
? Used to represent the relationships amongthe external entities
Which of the following is CORRECT about database managementsystem's languages?
? Data definition languages are used to specify the conceptualschema only.
? Data manipulation languages are used to create thedatabases.
? Data manipulation languages are used for retrieval, insertion,deletion and modification of data.
? Data definition langauges are only used to update data in theDBMS.
Controlling redundancy in a database management system DOES NOThelp to
? avoid duplication
? avoid unnecessary wastageof storage space
? avoid unauthorised accessto data
? avoid inconsistency amongdata
Which of the following concepts is applicable with respect to3NF?
? Full functionaldependency
? Any kind ofdependency
? Transitive dependency
? Partial functionaldependency
Consider two sets A and B. A contains 3 elements and B contains4. How many elements do their cartesian product contains?
? 12
? 9
? 16
? 7
Consider two sets A and B. A contains 2 elements and B contains3. How many elements do their cartesian product contains?
? 6
? 9
? 4
? 5
In a conceptual database model, which of the following mostlikely represents a valid identifier for a class grades?
? StudentID
? StudentID, CourseID
? StudentID, CourseID,InstructorID
? StudentID,CourseSectionID
Identify the correct statement with respectto normalization.
? Normalization is a formaltechnique that can be used only at the starting phase of thedatabase design.
? Normalization can be usedas a top-down standalone database design technique.
? The process ofnormalization through decomposition must achieve the losslessjoin
property at any cost whereas the dependency reservation propertyis sometimes
sacrificed.
? The process ofnormalization through decomposition must achieve the dependency
reservation property at any cost whereas the lossless joinproperty is sometimes
sacrificed.
Which of the following is not true about relational tables?
? Column values are of thesame kind.
? Each row is unique.
? Each column must have aunique name.
? The sequence of rows issignificant.
Identify the operation which is NOT one of the parts of the fivebasic set operations in relational algebra?
? Join
? Union
? Cartesian Product
? Set Difference
Consider the following statements.
A. An entity integrity constraint states that no primary keyvalue can be null.
B. A referential integrity constraint is specified between tworelations.
C. A foreign key cannot be used to refer to its ownrelation.
Identify which of the above statements is/are correct.
? Only A
? Only B
? Only B and C
? Only A and B
If K is a foreign key in relation R1, then
? every tuple of R1 has adistinct value for K.
? K cannot have a nullvalue for tuples in R1.
? K is a key for someother relation.
? K is a primary key forR1.
Making a change to the conceptual schema of a database but notaffecting the existing external schemas is an example of
? Physical dataindependence.
? Concurrency control.
? Logical dataindependence.
? Functional dependency
Explanation / Answer
x.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.