WHERE ID = ?
Consider the following statement:
prepStmt = dbConn.prepareStatement (” DELETE
FROM MyTable
WHERE ID = ?”);
The prepStmt member is of type PreparedStatement. The dbConn member is of type Connection
and represents a connection to a database. The ID column is an int data type. The value for the ?
placeholder in the SQL statement is held by a member variable named id. The id member’s value
was acquired via a getPhmaryKey() method. Which of the following statements would properly
execute the statement given in this question?
How should Mario rewrite the first line to correct the errors?
Mario is debugging his colleagues SQL statement and ASP code. He finds at least four errors in
the following section of code:
<%
SQL1 = UPDATE mytableSET LocID=0007,Material=13 1/4 Description=T-shirts ListPrice=35
WHERE
CusID=97
SQL2 = INSERT INTO authors (AU_ID, author, year_born) VALUES (7000, Joe Smith,1950)
SQL3 = SELECT * from atable where state = MD and year born<1955
key=request.querystring(“id”)
au=request.querystring(“author”)
birthyear=request.querystring(“year”)
SQLstmt=”INSERT INTO authors (AU_ID, author, year_born) VALUES (” SQLstmt= SQLstmt &
key
& “,”
SQLstmt= SQLstmt & author & “,”
SQLstmt= SQLstmt & birthyear & “)” %>
How should Mario rewrite the first line to correct the errors?
An ObjectBuilder defines the properties and methods of a custom object.
An ObjectBuilder defines the properties and methods of a custom object.
which item?
According to the HTML 4.0 Recommendation, an HTML tag can consist of several items, all of
which are contained within angle brackets (<and >). The main instruction of an HTML tag is
usually contained in which item?
What does this script do?
Luis uses JavaScript code in his Web site’s home page. The script notifies Microsoft Internet
Explorer 5.0 users of a possible usability problem. What does this script do?
Which of the following is the correct way to test for the presence of a cookie?
Which of the following is the correct way to test for the presence of a cookie?
The _________ method, allows you to create text that is dynamically written to the window as the script is exe
The _________ method, allows you to create text that is dynamically written to the window as the
script is executed.
Which type of server is the target in such an attack?
A hacker has just changed information during a zone transfer. This attack caused false information
to be passed on to network hosts as if it were legitimate. Which type of server is the target in such
an attack?
Which technique is referred to as inline scripting?
Which technique is referred to as inline scripting?
which these activities occur during a typical interaction between a client and an EJB?
Consider the following four activities that occur during a typical interaction between a client and an
enterprise bean:
1 .A reference to an EJB home object is returned to the client.
2.A reference to the EJB object is returned to the client.
3.JNDI is used to acquire a reference to an enterprise bean’s home object.
4.The client requests the bean’s home object to create or find an enterprise bean.
Which choice lists the correct order in which these activities occur during a typical interaction
between a client and an EJB?