Question
QUESTION 1 What will happen if you try to store duplicate data in a primary key column? a. The column is duplicated. b. An error
QUESTION 1
What will happen if you try to store duplicate data in a primary key column?
a. | The column is duplicated. | |
b. | An error will occur. | |
c. | The duplicate data will have concurrency issues | |
d. | The primary key column will not display the duplicate data. |
1 points
QUESTION 2
This type of SQL statement is used to retrieve the rows from a table.
a. | GET | |
b. | SELECT | |
c. | RETRIEVE | |
d. | READ |
1 points
QUESTION 3
A result set is an object that is somewhat similar to a collection and
a. | contains the results of an SQL Select statement. | |
b. | allows the program to execute an SQL statement. | |
c. | predicts the outcome of an SQL statement. | |
d. | provides rules for how an SQL statement should be executed. |
1 points
QUESTION 4
What does JDBC stand for?
a. | Java data binary collection | |
b. | Java database connectivity | |
c. | Java database collection | |
d. | Java data basic computation |
1 points
QUESTION 5
What string lists the protocol that should be used to access a database, the name of the database, and potentially other items?
a. | JDBC driver | |
b. | Database URL | |
c. | JDBC locator | |
d. | Database specifier |
1 points
QUESTION 6
Which Statement interface method should be used to execute a SELECT statement?
a. | executeSQL | |
b. | executeStatement | |
c. | executeUpdate | |
d. | executeQuery |
1 points
QUESTION 7
Which Statement interface method should be used to execute an INSERT statement?
a. | execute | |
b. | executeStatement | |
c. | executeQuery | |
d. | executeSQL |
1 points
QUESTION 8
What term refers to data that describes other data?
a. | Pseudo-data | |
b. | Micro data | |
c. | Abstract data | |
d. | Meta data |
1 points
QUESTION 9
Which of the following is a key benefit of using JDBC?
a. | It is a simple-to-use database management system. | |
b. | Allows developers to change the underlying database without modifying the Java code. | |
c. | It is a multi-platform database management system. | |
d. | It provides a GUI for database management systems. |
1 points
QUESTION 10
Classes and interfaces for the JDBC API can be found in which package?
a. | java.jdbc. | |
b. | javax.jdbc. | |
c. | java.sql. | |
d. | java.sql.jdbc. |
1 points
QUESTION 11
What exception is thrown if a syntax error is in the SQL query that is beining invoked by the JDBCs executeQuery method?
a. | NoSuchClassException | |
b. | ClassCastException. | |
c. | SQLException | |
d. | IllegalClassException. |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started