QUESTION 1 What will happen if you try to store duplicate data in a primary key

Question

QUESTION 1

What will happen if you try to store duplicate data in a primary key column?

The column is duplicated.

An error will occur.

The duplicate data will have concurrency issues

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.

GET

SELECT

RETRIEVE

READ

1 points   

QUESTION 3

A result set is an object that is somewhat similar to a collection and

contains the results of an SQL Select statement.

allows the program to execute an SQL statement.

predicts the outcome of an SQL statement.

provides rules for how an SQL statement should be executed.

1 points   

QUESTION 4

What does JDBC stand for?

Java data binary collection

Java database connectivity

Java database collection

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?

JDBC driver

Database URL

JDBC locator

Database specifier

1 points   

QUESTION 6

Which Statement interface method should be used to execute a SELECT statement?

executeSQL

executeStatement

executeUpdate

executeQuery

1 points   

QUESTION 7

Which Statement interface method should be used to execute an INSERT statement?

execute

executeStatement

executeQuery

executeSQL

1 points   

QUESTION 8

What term refers to data that describes other data?

Pseudo-data

Micro data

Abstract data

Meta data

1 points   

QUESTION 9

Which of the following is a key benefit of using JDBC?

It is a simple-to-use database management system.

Allows developers to change the underlying database without modifying the Java code.

It is a multi-platform database management system.

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?

java.jdbc.

javax.jdbc.

java.sql.

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 JDBC’s executeQuery method?

NoSuchClassException

ClassCastException.

SQLException

IllegalClassException.

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.

Explanation / Answer

1)The primary Key column will not display the duplicate data

2) SELECT is used to retrieve the rows from a table

EG:  Table name is TABLE123 which contains username and Email(PRIMARY KEY). There are  50 records inserted in table. So, to access row which has email is “chegg@123” SQL statement would be

SELECT * from TABLE123 WHERE Email LIKE ‘chegg@123’

3)contains the result of an SQL Select Statement

4) JDBC stands for Java Database Connectivity

5)JDBC Driver

6)executeQuery

7)executeSQL

8)Meta data

9)it is a multiplatform database Management System

10)java.sql.

11)SQL Exception

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.