100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
SER 322 FINAL EXAM QUESTIONS AND ANSWERS $11.49   Add to cart

Exam (elaborations)

SER 322 FINAL EXAM QUESTIONS AND ANSWERS

 4 views  0 purchase
  • Course
  • SER 322
  • Institution
  • SER 322

SER 322 FINAL EXAM QUESTIONS AND ANSWERS...

Preview 2 out of 7  pages

  • November 8, 2024
  • 7
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • SER 322
  • SER 322
avatar-seller
luzlinkuz
SER 322 FINAL EXAM QUESTIONS AND
ANSWERS

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

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

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

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.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

62890 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$11.49
  • (0)
  Add to cart