Which type of driver provides JDBC access via one or more ODBC
drivers? - ANSWER Type 1 driver
Which of the following provides the application-to-JDBC Manager
connection. - ANSWER JDBC API
With the code below, indicate JDBC coding best practices that have
been violated (this code does compile and run!):
import java.sql.*;
public class StudentData{public static void main(String[] args) {ResultSet
rs = null;Statement stmt = null;Connection conn = null;try
{Class.forName("org.postgresql.Driver");conn =
DriverManager.getConnection(args[2], args[0], args[1]);stmt =
conn.createStatement();rs = stmt.executeQuery("SELECT * FROM
Student WHERE rollno='" + args[3] + "'");while (rs.next())
{System.out.print(rs.getInt(1) + "\t");System.out.print(rs.getString(2) + "\t
");System.out.print(rs.getInt(3) + "\t
");System.out.println(rs.getDate(4));}stmt.close();stmt = null;rs.close();rs
= null;}catch (Exception exc) {exc.printStackTrace();}}} - ANSWER
Answers 1-6 all apply
In JDBC, it is a good practice to use standard SQL statement and avoid
using db specific query until necessary. - ANSWER true
Which statement about JDBC is true? - ANSWER JDBC stands for
Java Database Connectivity
Match the resource type with the best description - ANSWER
Represents the socket between client and server
Connection
Represents a query to the database
Statement
Corresponds to a cursor in the database server
ResultSet
, Represents a pre-compiled and/or parameterized query
Prepared Statement
Which of the following are not benefits of XML over traditional relational
data modelling? - ANSWER Support for Large Objects (LOBs)
When XML is used as a DDL, we want to ensure the XML conforms to
this so structural constraints may be specified: - ANSWER DTD or XML
Schema
The type of XML Parsing that is parses an XML document based on
expression and is used extensively in conjunction with XSLT. -
ANSWER XPath Parsing
On the XML below, which XPath expression will return all of the values
of title attributes?
<slideshowtitle="Sample Slide Show"date="Date of
publication"author="Yours Truly"><!-- TITLE SLIDE --><slide
type="all"><title>Wake up to WonderWidgets!</title></slide><!--
OVERVIEW --><slide type="all"><title>Overview</title><item>Why
<em>WonderWidgets</em> are great</item><item>Who
<em>buys</em> WonderWidgets</item></slide></slideshow> -
ANSWER //@title
Well formed XML document means - ANSWER must contain one or
more elements and root element must contain all other elements
A transaction is delimited by statements (or function calls) of the form
__________. - ANSWER Begin transaction and End transaction
All functional dependencies must _________. - ANSWER have
attributes of the same table
Assume that a relation R has the following properties. What is the
normal form of R?
No multi-valued attributes
No partial key dependencies - ANSWER Second Normal Form
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller luzlinkuz. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.49. You're not tied to anything after your purchase.