What is determined by the following code? resultSet.last(); int numRows = result
ID: 3771571 • Letter: W
Question
What is determined by the following code?
resultSet.last();
int numRows = resultSet.getRow();
resultSet.first();
(The number of columns in the result, set the sum of all rows in the result set, the number of rows in the result set, The value of the cursor's current position )
What string lists the protocol that should be used to access a database, the name of the database, and potentially other items? (Database specifier, Database URL, JDBC driver, JDBC locator)
Of the following column names, which one is most likely a primary key column? (Quantity, Description, ItemNumber, Price)
Explanation / Answer
resultSet.last(): this operation points the cursor to the last row of the "resultSet" object. It returns "true" if the object has the last row. If it does not have the any last row it returns false.
resultSet.getRow():- This operation is useful for getting the current row in the resultSet object. This method is also useful to get the number of rows in the resultset. it is mainly usefull to check if tthere are any rows there in the resultset or not if the resultSet has no rows it returns 0.
resultSet.first():- this operation is exactly the opposite operation to resulrSet.first. This operation points the cursor to the first row of the resultSet.
Where driver is in the form "jdbc:oracle:<drivertype>:<user>/<password>@<database>"
drivertype: Specifies the driver.
Total string in total indicates the Driver.
<database>: Specifies the database location like the ip of the database.
Among "Quantity, Description, ItemNumber, Price" Item number is most likely a primary key. Because the description,quantity and quantity can be same to more than one item . In order to uniquely identify the each item we should have the different item id for different item.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.