IT QUIZ DBMS 5

1)Which JDBC driver Type(s) can be used in either applet or servlet code?

a)Both Type 1 and Type 2
b)Both Type 1 and Type 3
c)Both Type 3 and Type 4
d)Type 4 only

2)________ is considered to be one of the foundations of data access in the Microsoft world.
a)ODBC
b)OLE DB
c)JPCD
d)ADO

3)What is sent to the user via HTTP, invoked using the HTTP protocol on the user’s computer, and run on the user’s computer as an application?
a)A Java application
b)A Java applet
c)A Java servlet
d)None of the above is correct.

4)A snowflake schema is which of the following types of tables?
a)Fact
b)Dimension
c)Helper
d)All of the above

5)The most popular way to materialize XML documents is to use:
a)DTD.
b)XSLT.
c)HTML.
d)SOAP.

Answers:
1)c
2)b
3)b
4)d
5)b

6)In OLE DB, actions that an object can perform are called:
a)properties.
b)collections.
c)methods.
d)abstractions.

7)A star schema has what type of relationship between a dimension and fact table?
a)Many-to-many
b)One-to-one
c)One-to-many
d)All of the above.

8)How many copies of a JSP page can be in memory at a time?
a)One
b)Two
c)Three
d)Unlimited

9)If the XML data instance conforms to the DTD, the document is said to be:
a)type-invalid.
b)type-valid.
c)not-type-valid.
d)an HTML document.

10)When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers?
Aa)Data source
b)Driver
c)Driver manager
d)OLE DB

Answers:
6)c
7)c
8)a
9)b
10)c