CSE 511 Midterm Review Questions And Answers
With Verified Solutions
Which database type is most commonly used to efficiently store unstructured data?
a) Relational database
b)Hadoop
c) NoSQL database
d) Spark ANS NoSQL database
In which level of abstraction the logical structure of data is defined?
a) Conceptual Schema
b) External Schema(View)
c) Physical Schema
d) Filesystem Schema ANS Conceptual Schema
In the above ER diagram the Works_In relationship is uniquely identified by which entities?
a) did
b) Departments
c) ssn
d) Employees ANS Departments
Employees
Which of the following scenario perfectly matches the above ER diagram?
a) Departments can be managed by at most one employee
b) Departments can be managed by all employees
c)Some employees can manage all departments
d) No departments can be managed by any employee ANS Department can be managed by at most one
employee
A weak entity can be identified uniquely only by considering the primary key of owner entity.
True or False? ANS True
, Suppose there are two tables with names cse_majors (Computer science majors) and eee_majors(Electrical
Engineering majors) with same schema {id, name, class}.
Statement: List the student details for computer science majors who are not electrical engineering double
majors.
For the above statement what is relational algebraic expression below?
a) cse_majors x eee_majors
b) cse_majors U eee_majors
c) cse_majors ^ eee_majors
d) cse_majors - eee_majors ANS cse_majors - eee_majors
Table A: 4 tuples
Table B: 3 tuples
How many tuples will result from Cartesian product A x B?
a) 7
b) 12
c) 4
d) 3 ANS 12
Which of the following will eliminate duplicate items in the target list?
a) FROM
b) SELECT
c) WHERE
d) DISTINCT ANS DISTINCT
To sort the result data, which SQL term is used?
a) ORDER BY
b) ORDER
c) SORT
d) SORT BY ANS ORDER BY
With Verified Solutions
Which database type is most commonly used to efficiently store unstructured data?
a) Relational database
b)Hadoop
c) NoSQL database
d) Spark ANS NoSQL database
In which level of abstraction the logical structure of data is defined?
a) Conceptual Schema
b) External Schema(View)
c) Physical Schema
d) Filesystem Schema ANS Conceptual Schema
In the above ER diagram the Works_In relationship is uniquely identified by which entities?
a) did
b) Departments
c) ssn
d) Employees ANS Departments
Employees
Which of the following scenario perfectly matches the above ER diagram?
a) Departments can be managed by at most one employee
b) Departments can be managed by all employees
c)Some employees can manage all departments
d) No departments can be managed by any employee ANS Department can be managed by at most one
employee
A weak entity can be identified uniquely only by considering the primary key of owner entity.
True or False? ANS True
, Suppose there are two tables with names cse_majors (Computer science majors) and eee_majors(Electrical
Engineering majors) with same schema {id, name, class}.
Statement: List the student details for computer science majors who are not electrical engineering double
majors.
For the above statement what is relational algebraic expression below?
a) cse_majors x eee_majors
b) cse_majors U eee_majors
c) cse_majors ^ eee_majors
d) cse_majors - eee_majors ANS cse_majors - eee_majors
Table A: 4 tuples
Table B: 3 tuples
How many tuples will result from Cartesian product A x B?
a) 7
b) 12
c) 4
d) 3 ANS 12
Which of the following will eliminate duplicate items in the target list?
a) FROM
b) SELECT
c) WHERE
d) DISTINCT ANS DISTINCT
To sort the result data, which SQL term is used?
a) ORDER BY
b) ORDER
c) SORT
d) SORT BY ANS ORDER BY
