Database Questions

Q:

 Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?

A) Type 1 B) Type 2
C) Type 3 D) Type 4
 
Answer & Explanation Answer: A) Type 1

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 4219
Q:

88%of 370 +24% of 210-x =118 find x

Answer

From the given equation,


88x370/100 + 24x210/100 - 118 = x


=> x = 325.6 + 50.4 - 118


x = 258.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Exam Prep: CAT , Bank Exams , AIEEE
Job Role: Bank PO , Bank Clerk

7 4074
Q:

 Stored procedures have which of the following advantages?

A) It takes a longer time to write them as compared to writing Visual Basic. B) Data integrity improves as multiple applications access the same stored procedure.
C) Network traffic increases D) Result in thicker client and thinner database server.
 
Answer & Explanation Answer: B) Data integrity improves as multiple applications access the same stored procedure.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 4042
Q:

 ________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.

A) ASP B) XML
C) ODBC D) ADO
 
Answer & Explanation Answer: D) ADO

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 3983
Q:

 A distributed database is which of the following?

A) A single logical database that is spread to multiple locations and is interconnected by a network B) A loose collection of file that is spread to multiple locations and is interconnected by a network
C) A single logical database that is limited to one location. D) A loose collection of file that is limited to one location.
 
Answer & Explanation Answer: A) A single logical database that is spread to multiple locations and is interconnected by a network

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

1 3741
Q:

 The expression FOR XML RAW tells SQL Server to:

A) place the values of the columns as attributes in the resulting XML document. B) place the values of the columns into elements rather than attributes.
C) place some columns into elements and others into attributes. D) None of the above is correct.
 
Answer & Explanation Answer: A) place the values of the columns as attributes in the resulting XML document.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 3741
Q:

Using OQL, you may do which of the following?

A) Return an entire collection of elements including duplicates. B) Return a collection of elements without duplicates.
C) Return a specific subset of elements using a given criteria. D) All of the above.
 
Answer & Explanation Answer: D) All of the above.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 3678
Q:

Does the minimum spanning tree of a graph give the shortest distance between any 2 specified nodes?

A) Yes B) No
C) May be Yes or No D) None
 
Answer & Explanation Answer: B) No

Explanation:

No.Minimal spanning tree assures that the total weight of the tree is kept at its minimum. But it doesn’t mean that the distance between any two nodes involved in the minimum-spanning tree is minimum.

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

1 3657