Starting Out with Java: From Control Structures through Objects (7th Edition) (What's New in Computer Science)
7th Edition
ISBN: 9780134802213
Author: Tony Gaddis
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 16, Problem 12MC
Program Description Answer
The method that is specified in Statement interface, and should be used to execute an UPDATE statement is “executeUpdate”.
Hence, the correct answer is option “B”.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Create java application with user friendly menu and sub menu which allows user to
1. a.Add Inventory
b.Update Inventory Cost Price
c.Update Quantityin Stock
d.Update Selling Price
2. a.Add A Customer
b.Update Address
c.Update Contact
3. a.Add Employee
b.Calculate Wage
c.Print Pay Slip
Which of a database file’s properties determines if and when the file is copied to the project’s bin\Debug folder? a. Copy to Debug b. Copy to Output c. Copy to Output Directory d. Copy to bin\Debug
Which statement is not correct? The goal of batch controls is to endure that during processing
a. Transactions are not omitted
b. Transactions are processed more than once
c. Transactions are not added
d. An audit trial is created
Chapter 16 Solutions
Starting Out with Java: From Control Structures through Objects (7th Edition) (What's New in Computer Science)
Ch. 16.1 - Why do most businesses use a DBMS to store their...Ch. 16.1 - When a Java programmer uses a DBMS to store and...Ch. 16.1 - Prob. 16.3CPCh. 16.1 - Prob. 16.4CPCh. 16.1 - Prob. 16.5CPCh. 16.1 - Prob. 16.6CPCh. 16.1 - What static JDBC method do you call to get a...Ch. 16.2 - Describe how the data that is stored in a table is...Ch. 16.2 - What is a primary key?Ch. 16.2 - What Java data types correspond with the following...
Ch. 16.3 - Prob. 16.11CPCh. 16.3 - Prob. 16.12CPCh. 16.3 - Prob. 16.13CPCh. 16.3 - Prob. 16.14CPCh. 16.3 - What is the purpose of the % symbol in a character...Ch. 16.3 - How can you sort the results of a SELECT statement...Ch. 16.3 - Assume that the following declarations exist:...Ch. 16.3 - How do you submit a SELECT statement to the DBMS?Ch. 16.3 - Prob. 16.19CPCh. 16.3 - Prob. 16.20CPCh. 16.4 - Prob. 16.21CPCh. 16.4 - Prob. 16.22CPCh. 16.5 - The Midnight Coffee Roastery is running a special...Ch. 16.5 - Prob. 16.24CPCh. 16.6 - Prob. 16.25CPCh. 16.6 - Write a statement to delete the Book table you...Ch. 16 - Prob. 1MCCh. 16 - This is a standard language for working with...Ch. 16 - Prob. 3MCCh. 16 - The data that is stored in a row is divided...Ch. 16 - This is a column that holds a unique value for...Ch. 16 - This type of SQL statement is used to retrieve...Ch. 16 - This contains the results of an SQL SELECT...Ch. 16 - This clause allows you to specify search criteria...Ch. 16 - Prob. 9MCCh. 16 - Prob. 10MCCh. 16 - Prob. 11MCCh. 16 - Prob. 12MCCh. 16 - This method is specified in the Statement...Ch. 16 - This SQL statement is used to insert rows into a...Ch. 16 - This SQL statement is used to remove rows from a...Ch. 16 - Prob. 16MCCh. 16 - Prob. 17MCCh. 16 - True/False: Java comes with its own built-in DBMS.Ch. 16 - True/False: A Java programmer that uses a DBMS to...Ch. 16 - True/False: You use SQL instead of Java to write...Ch. 16 - True/False: In SQL, the not-equal-to operator is...Ch. 16 - Prob. 22TFCh. 16 - Prob. 23TFCh. 16 - Prob. 24TFCh. 16 - Prob. 1FTECh. 16 - Prob. 2FTECh. 16 - Prob. 3FTECh. 16 - What SQL data types correspond with the following...Ch. 16 - Look at the following SQL statement. SELECT Name...Ch. 16 - Write a SELECT statement that will return all of...Ch. 16 - Write a SELECT statement that will return the...Ch. 16 - Prob. 5AWCh. 16 - Write a SELECT statement that will return the...Ch. 16 - Write a SELECT statement that will return all of...Ch. 16 - Write a SELECT statement that will return the...Ch. 16 - Write a SELECT statement that will return the...Ch. 16 - Prob. 10AWCh. 16 - Write an SQL statement that does the following:...Ch. 16 - Prob. 12AWCh. 16 - Prob. 13AWCh. 16 - Assuming that conn references a valid Connection...Ch. 16 - Look at the following declaration. String sql =...Ch. 16 - Prob. 16AWCh. 16 - Prob. 17AWCh. 16 - Prob. 18AWCh. 16 - Prob. 1SACh. 16 - Prob. 2SACh. 16 - Prob. 3SACh. 16 - What is a primary key?Ch. 16 - Prob. 5SACh. 16 - What are the relational operators in SQL for the...Ch. 16 - What is the number of the first row in a table?...Ch. 16 - Prob. 8SACh. 16 - Prob. 9SACh. 16 - Customer Inserter Write an application that...Ch. 16 - Customer Updater Write an application that...Ch. 16 - Unpaid Order Sum Write an application that...Ch. 16 - Population Database Make sure you have downloaded...Ch. 16 - Personnel Database Creator Write an application...Ch. 16 - Employee Inserter Write a GUI application that...Ch. 16 - Employee Updater Write a GUI application that...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- What is the maximum number of records that can be modified with a single UPDATE command? 1 2 3 unlimitedarrow_forwardExecute a command that undoes the change in Step 7.arrow_forwardWhat happens if the following command is executed to manage the garbage files?find . "(" -name A -o -name B")" -exec rm {} \; Choose an answer A The garbage file with the name “A” will be removed. B The garbage files with the names “A” and “B” will be removed. C The garbage file with the name “A” will be located. D The garbage files with the names “A” and “B” will be located.arrow_forward
- please use store procedures to answer the following question Create a procedure to update Job Title for a given JOB_ID This procedure is called Update_Job_Title will have two INPUT parameters. p_job_id as VARCHAR2 as INPUT parameter and also p_new_job_title as VARCHAR2 as INPUT parameter. In BEGIN and END executable section Execute UPDATE command on JOBS table to change title of a JOB_ID Here is the command that you can use in BEGIN and END UPDATE JOBS SET job_title= p_new_job_title WHERE job_id= p_job_id; Test your code by executing procedure for below job_id. Currently in Jobs table you have Job_id = ‘MK_MAN’ and job_title=’ Marketing Manager’ Change title from Marketing Manager to Marketing Sr. Manager execute Update_Job_Title(‘MK_MAN’, ‘Marketing Sr. Manager’ )arrow_forwardExecuting an UPDATE statement will return______. the number of records updated the set of records updated the identifiers of updated records NULLarrow_forward.Which function is used to perform some action when the object is to be destroyed? a) finalize() b) delete() c) main() d) none of the mentionedarrow_forward
- The distinction between edit, brief, and update runarrow_forwardSet the following permission for all the users; User:read, write and execute Group:execute Other:readarrow_forward(a) Which command makes updates permanent?(b) Which command reverses updates? (c) Which updates are reversed?arrow_forward
- Which of the following attributes of a database file influences whether or not the file is moved to the project's binDebug folder? a. Copy to Debugb. Copy to Outputc. Copy to Output Directoryd. Copy to bin\Debugarrow_forwardIf you are unsure of the location of the update.txt file on your computer, print a copy.arrow_forwardYou accidentally deleted all the orders in the ORDERS table. How can the error be corrected after a COMMIT command has been issued?a. ROLLBACK;b. ROLLBACK COMMIT;c. REGENERATE RECORDS orders;d. None of the above restores the deleted ordersarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Programming Logic & Design ComprehensiveComputer ScienceISBN:9781337669405Author:FARRELLPublisher:CengageProgramming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning