DBI202 Exam Questions with Verified Answers
(UPDATED 2025)
Which statement is true?
a. Xml documents must have a root tag
b. All of the others
c. Xml tags are case sensitive
d. Xml elements must be properly nested
B
In a typical olap application, there is a central relation or
collection
Of data, called ______
a. The fact table
b. All of the others
c. The dimension table
d. The star table
A
There is a way of describing xml data, how?
a. Xml uses a dtd to describe the data
b. All of the others
c. Xml uses a description node to describe data
d. Xml uses xsl to describe data
A
Given relation r(a,b) that has 2 tuples (1, 2) and (3, 4); relation
s(b,
C, d) has 3 tuples (2, 5, 6), (4, 7, 8) and (9, 10, 11). The natural
Join of r and s has ______
a. 2 tuples (1, 2, 5, 6) and (3, 4, 7, 8)
b. 1 tuple (1, 2, 10, 11)
c. 2 tuples (1, 2, 2, 5) and (3, 4, 4, 7)
d. 2 tuples (1, 2, 3, 4) and (5, 6, 7, 8)
A
, DBI202 Exam Questions with Verified Answers
(UPDATED 2025)
Suppose a schema of relation supplierproduct is supplierproduct(no,
Supplierid, producttype) where no is a identifier, supplierid is an
Identifer of each supplier, and productype is a type of product which
This supplier provides. What will be returned when the following sql
Statement is executed?
Select supplierid from supplierproduct
Group by supplierid having count (*) in
(select count (distinct producttype) from supplierproduct);
a. A listing of supplierids, which provide all product types
b. A listing of supplierids, which provide some product types
c. A listing of supplierids, which provide a specified number of
Product types
d. No result, the query is invalid
C
Which sql statement is used to return only different values?
a. Select distinct
b. Select different
c. Select unique
d. Select different all
A
We can turn the result of a query into a data cube by appending ______
To a group-by clause
a. With sum
b. With cube
c. All of the others
d. With aggregate
B
Choose a well-formed xml document
a. <?Xml version="1.0"?>
<to>tove</to><from>jani</from><heading>reminder</heading><body>don't
, DBI202 Exam Questions with Verified Answers
(UPDATED 2025)
Forget me this weekend!</body>
b. <?Xml version="1.0"?>
<envelope><to>tove</to><from>jani</from><heading>reminder</heading><bo
dy>don't
Forget me this weekend</body></envelope>
c. <?Xml version="1.0"?>
<to>tove</to><from>jani</from><heading>reminder</heading><body>don't
Forget me this weekend!</body></end>
d. None of the others
B
The multiplicity of a binary relationship could be _____
a. Many-to-many
b. One-to-many
c. All of the others
d. One-to-one
C
Choose the wrong statement
a. None of the others
b. The database tier executes queries that are requested from the
Application tier
c. There can be many processes in the database tier and the processes.
Can be distributed over many machines or all be together on one
d. Since creating connections to database takes significant time, we
Normally keep a large number of connections open and allow application
Processes to share the connection
A
Choose the wrong statement:
a. The subclasses of a class in uml can be disjoint partial
b. The subclasses of a class in uml can be disjoint overlapping
c. The subclasses of a class in uml can be disjoint complete
d. The subclasses of a class in uml can be overlapping partial
(UPDATED 2025)
Which statement is true?
a. Xml documents must have a root tag
b. All of the others
c. Xml tags are case sensitive
d. Xml elements must be properly nested
B
In a typical olap application, there is a central relation or
collection
Of data, called ______
a. The fact table
b. All of the others
c. The dimension table
d. The star table
A
There is a way of describing xml data, how?
a. Xml uses a dtd to describe the data
b. All of the others
c. Xml uses a description node to describe data
d. Xml uses xsl to describe data
A
Given relation r(a,b) that has 2 tuples (1, 2) and (3, 4); relation
s(b,
C, d) has 3 tuples (2, 5, 6), (4, 7, 8) and (9, 10, 11). The natural
Join of r and s has ______
a. 2 tuples (1, 2, 5, 6) and (3, 4, 7, 8)
b. 1 tuple (1, 2, 10, 11)
c. 2 tuples (1, 2, 2, 5) and (3, 4, 4, 7)
d. 2 tuples (1, 2, 3, 4) and (5, 6, 7, 8)
A
, DBI202 Exam Questions with Verified Answers
(UPDATED 2025)
Suppose a schema of relation supplierproduct is supplierproduct(no,
Supplierid, producttype) where no is a identifier, supplierid is an
Identifer of each supplier, and productype is a type of product which
This supplier provides. What will be returned when the following sql
Statement is executed?
Select supplierid from supplierproduct
Group by supplierid having count (*) in
(select count (distinct producttype) from supplierproduct);
a. A listing of supplierids, which provide all product types
b. A listing of supplierids, which provide some product types
c. A listing of supplierids, which provide a specified number of
Product types
d. No result, the query is invalid
C
Which sql statement is used to return only different values?
a. Select distinct
b. Select different
c. Select unique
d. Select different all
A
We can turn the result of a query into a data cube by appending ______
To a group-by clause
a. With sum
b. With cube
c. All of the others
d. With aggregate
B
Choose a well-formed xml document
a. <?Xml version="1.0"?>
<to>tove</to><from>jani</from><heading>reminder</heading><body>don't
, DBI202 Exam Questions with Verified Answers
(UPDATED 2025)
Forget me this weekend!</body>
b. <?Xml version="1.0"?>
<envelope><to>tove</to><from>jani</from><heading>reminder</heading><bo
dy>don't
Forget me this weekend</body></envelope>
c. <?Xml version="1.0"?>
<to>tove</to><from>jani</from><heading>reminder</heading><body>don't
Forget me this weekend!</body></end>
d. None of the others
B
The multiplicity of a binary relationship could be _____
a. Many-to-many
b. One-to-many
c. All of the others
d. One-to-one
C
Choose the wrong statement
a. None of the others
b. The database tier executes queries that are requested from the
Application tier
c. There can be many processes in the database tier and the processes.
Can be distributed over many machines or all be together on one
d. Since creating connections to database takes significant time, we
Normally keep a large number of connections open and allow application
Processes to share the connection
A
Choose the wrong statement:
a. The subclasses of a class in uml can be disjoint partial
b. The subclasses of a class in uml can be disjoint overlapping
c. The subclasses of a class in uml can be disjoint complete
d. The subclasses of a class in uml can be overlapping partial
