EMILLECT 2024/2025 ACADEMIC YEAR ©2024 EMILLECT. ALL RIGHTS RESERVED FIRST PUBLISH OCTOBER, 2024
DBI202 Exam Practice Questions and
Answers Updated 2024
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 - Answer✔✔-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 - Answer✔✔-A
There is a way of describing xml data, how?
Page 1/50
,EMILLECT 2024/2025 ACADEMIC YEAR ©2024 EMILLECT. ALL RIGHTS RESERVED FIRST PUBLISH OCTOBER, 2024
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 - Answer✔✔-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) - Answer✔✔-A
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
Page 2/50
,EMILLECT 2024/2025 ACADEMIC YEAR ©2024 EMILLECT. ALL RIGHTS RESERVED FIRST PUBLISH OCTOBER, 2024
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 - Answer✔✔-C
Which sql statement is used to return only different values?
a. Select distinct
b. Select different
c. Select unique
d. Select different all - Answer✔✔-A
We can turn the result of a query into a data cube by appending ______
Page 3/50
, EMILLECT 2024/2025 ACADEMIC YEAR ©2024 EMILLECT. ALL RIGHTS RESERVED FIRST PUBLISH OCTOBER, 2024
To a group-by clause
a. With sum
b. With cube
c. All of the others
d. With aggregate - Answer✔✔-B
Choose a well-formed xml document
a. <?Xml version="1.0"?>
<to>tove</to><from>jani</from><heading>reminder</heading><body>don't
Forget me this weekend!</body>
b. <?Xml version="1.0"?>
<envelope><to>tove</to><from>jani</from><heading>reminder</heading><body>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>
Page 4/50
