CSE 511 Midterm Review UPDATED
ACTUAL Exam Questions and CORRECT
Answers
Which database type is most commonly used to efficiently store unstructured data?
a) Relational database
b)Hadoop
c) NoSQL database
d) Spark - CORRECT ANSWER -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 - CORRECT ANSWER -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 - CORRECT ANSWER -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 - CORRECT ANSWER -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? - CORRECT ANSWER -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 - CORRECT ANSWER -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 - CORRECT ANSWER -12
Which of the following will eliminate duplicate items in the target list?
a) FROM
b) SELECT
c) WHERE
d) DISTINCT - CORRECT ANSWER -DISTINCT
, To sort the result data, which SQL term is used?
a) ORDER BY
b) ORDER
c) SORT
d) SORT BY - CORRECT ANSWER -ORDER BY
GIS(Geographic Information system) allows you at store, manage, evaluate, and display the
spatial data.
True or False? - CORRECT ANSWER -True
To insert new data into a database, which SQL query is used?
a) ADD
b) INSERT INTO
c) INSERT NEW
d) PUT - CORRECT ANSWER -INSERT INTO
ID NAME COURSE
1, Sam, CSE
2, Max, EE
3, George, ME
4, Alex, EE
For the table above, what is the degree?
a) 12
b) 4
c) 3
d) 7 - CORRECT ANSWER -3
ACTUAL Exam Questions and CORRECT
Answers
Which database type is most commonly used to efficiently store unstructured data?
a) Relational database
b)Hadoop
c) NoSQL database
d) Spark - CORRECT ANSWER -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 - CORRECT ANSWER -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 - CORRECT ANSWER -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 - CORRECT ANSWER -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? - CORRECT ANSWER -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 - CORRECT ANSWER -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 - CORRECT ANSWER -12
Which of the following will eliminate duplicate items in the target list?
a) FROM
b) SELECT
c) WHERE
d) DISTINCT - CORRECT ANSWER -DISTINCT
, To sort the result data, which SQL term is used?
a) ORDER BY
b) ORDER
c) SORT
d) SORT BY - CORRECT ANSWER -ORDER BY
GIS(Geographic Information system) allows you at store, manage, evaluate, and display the
spatial data.
True or False? - CORRECT ANSWER -True
To insert new data into a database, which SQL query is used?
a) ADD
b) INSERT INTO
c) INSERT NEW
d) PUT - CORRECT ANSWER -INSERT INTO
ID NAME COURSE
1, Sam, CSE
2, Max, EE
3, George, ME
4, Alex, EE
For the table above, what is the degree?
a) 12
b) 4
c) 3
d) 7 - CORRECT ANSWER -3
