vu cs403 Mid Term - Quiz No.3
vu cs403 Database Management Systems Quiz
This quiz belongs to book/course code vu cs403 Database Management Systems of vu organization. We have 18 quizzes available related to the book/course Database Management Systems. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Mid Term. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: Consider the relation Interview (CandidateNo, InterviewDate, InterviewTime, StaffNo, RoomNo) and the following functional dependencies.
FD1 : CandidateNo, InterviewDate -> InterviewTime, StaffNo, RoomNo
FD2 : RoomNo, InterviewDate, InterviewTime -> StaffNo, CandidateNo
FD3 : StaffNo, InterviewDate -> RoomNo
Which of the following is correct?
FD1 : CandidateNo, InterviewDate -> InterviewTime, StaffNo, RoomNo
FD2 : RoomNo, InterviewDate, InterviewTime -> StaffNo, CandidateNo
FD3 : StaffNo, InterviewDate -> RoomNo
Which of the following is correct?
The FD3 violates 3NF.
The relation Interview is in 3NF
The relation Interview is in BCNF.
The FD2 violates 2NF.
Question 2: A database system allows the following EXCEPT
management and control of data towards an efficient working of an organization.
more critical functions in organizations to be computerized and the need to keep a large volume of data available in an up to the minute current state increased.
any user to access all its data.
integration of data across multiple applications into a single application.
Question 3: Select the correct statement about the ANSI/SPARC architecture.
The conceptual level is a level of indication between the internal level and the external level.
The internal level in a database system will definitely be relational.
Any given database has many conceptual schemas and one physical schema, but it has only one external schemas.
The external level is not concerned with individual user perceptions, while the conceptual level is concerned with a community user perception.
Question 4: If K is a foreign key in relation R1, then
every tuple of R1 has a distinct value for K.
K cannot have a null value for tuples in R1.
K is a key for some other relation.
K is a primary key for R1.
Question 5: Consider the following relation R and its sample data. (Consider that these are the only tuples for the given relation)
Which of the following statements is NOT correct?
Which of the following statements is NOT correct?
The functional dependency (EmpNo, DeptNo) -> ProjNo holds over R.
The functional dependency EmpNo -> DeptNo holds over R.
The functional dependency ProjNo -> DeptNo holds over R.
The functional dependency (EmpNo, ProjNo) -> DeptNo holds over R.
Question 6: A relation (from the relational database model) consists of a set of tuples, which implies that
all tuples in a relation must be distinct.
relational model supports multi-valued attributes whose values can be represented in sets.
for any two tuples, the values associated with all of their attributes may be the same.
all tuples in a particular relation may have different attributes.
Question 7: Which of the following is a correct way to implement one-to-many relationship while designing tables?
using a junction table with the keys from both the tables forming the composite primary key of the junction table.
by splitting each table into three
by splitting the data into two tables with primary key and foreign key relationships.
as a single table and rarely as two tables with primary and foreign key relationships.
Question 8: Identify the correct statement with respect to normalization.
Normalization is a formal technique that can be used only at the starting phase of the database design.
Normalization can be used as a top-down standalone database design technique.
The process of normalization through decomposition must achieve the lossless join property at any cost whereas the dependency reservation property is sometimes sacrificed.
The process of normalization through decomposition must achieve the dependency reservation property at any cost whereas the lossless join property is sometimes sacrificed.
Question 9: Which of the following functions are NOT performed by a database administrator?
Planning, designing and implementing database systems
Establishing standards and procedures for database systems
Communicating with database users
Allocation of storage locations and data structures
Question 10: Which of the following is not true about relational tables?
Column values are of the same kind.
Each row is unique.
Each column must have a unique name.
The sequence of rows is significant.
