Question No: 1 ( Marks: 1 ) - Please choose one ? Minimize insertion anomolies ?
ID: 3615798 • Letter: Q
Question
Question No: 1 ( Marks: 1 ) - Please choose one
? Minimize insertion anomolies
? Minimize deletion anomolies
? Minimize updation anomolies
? Maximize redundancy
Question No: 2 ( Marks: 1 ) - Please choose one
? Dataflow
? Datastore
? Externalentities
? Relationshipbetween external entities
Question No: 3 ( Marks: 1 ) - Please choose one
? Single DFD is required to represent a system
? The dataflow must be bidirectional
? Created at increasing levels of detail
? Used torepresent the relationships among the external entities
Question No: 4 ( Marks: 1 ) - Please choose one
? Datadefinition languages are used to specify the conceptual schema only.
? Datamanipulation languages are used to create the databases.
? Datamanipulation languages are used for retrieval, insertion, deletion andmodification of data.
? Datadefinition langauges are only used to update data in the DBMS.
Question No: 5 ( Marks: 1 ) - Please choose one
? avoidduplication
? avoidunnecessary wastage of storage space
? avoidunauthorised access to data
? avoidinconsistency among data
Question No: 6 ( Marks: 1 ) - Please choose one
? Fullfunctional dependency
? Anykind of dependency
? Transitivedependency
? Partialfunctional dependency
Question No: 7 ( Marks: 1 ) - Please choose one
? 12
? 9
? 16
? 7
Question No: 8 ( Marks: 1 ) - Please choose one
? 6
? 9
? 4
? 5
Question No: 9 ( Marks: 1 ) - Please choose one
? StudentID
? StudentID, CourseID
? StudentID, CourseID, InstructorID
? StudentID, CourseSectionID
Question No: 10 ( Marks: 1 ) - Please choose one
? Normalizationis a formal technique that can be used only at the starting phase of thedatabase design.
? Normalizationcan be used as a top-down standalone database design technique.
? Theprocess of normalization through decomposition must achieve the lossless join
property at any cost whereas the dependencyreservation property is sometimes
sacrificed.
? Theprocess of normalization through decomposition must achieve the dependency
reservation property at any cost whereas the losslessjoin property is sometimes
sacrificed.
Question No: 11 ( Marks: 1 ) - Please choose one
? Column values are of the same kind.
? Eachrow is unique.
? Eachcolumn must have a unique name.
? Thesequence of rows is significant.
Question No: 12 ( Marks: 1 ) - Please choose one
? Join
? Union
? CartesianProduct
? SetDifference
Question No: 13 ( Marks: 1 ) - Please choose one
A. An entity integrity constraint states that noprimary key value can be null.
B. A referential integrity constraint is specifiedbetween two relations.
C. A foreign key cannot be used to refer to its ownrelation.
Identify which of the above statements is/are correct.
? OnlyA
? OnlyB
? OnlyB and C
? Only A and B
&
Explanation / Answer
x.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.