To obtain data from a table, you _____ the database. (Points : 4) select query get None of the above Which SQL keyword is used to merge rows from multiple tables? (Points : 4) JOIN INNER JOIN GROUP MERGE Pattern matching in a SQL query is performed with which clause? (Points : 4) FROM. WHERE. SELECT. LIKE. When joining tables, the _____ clause specifies the columns from each table that are com¬pared to determine which rows are merged. (Points : 4) ON WHERE LIKE GROUP Question 5. 5. (TCO 7) Which statement is false? (Points : 4) A DELETE statement removes rows from a table. A DELETE statement must specify the table from which to delete. A DELETE statement starts with the keyword DELETE. A WHERE clause must be present in a DELETE statement. Question 6. 6. (TCO 7) Classes and interfaces for the JDBC API can be found in which package? (Points : 4) java.jdbc javax.jdbc java.sql java.sql.jdbc Question 7. 7. (TCO 7) The _____ interface configures the database connection and prepares query statements automatically. (Points : 4) ResultSet RowSet Both of the above Neither of the above Question 8. 8. (TCO 7) Transaction processing enables a program to _____ or _____ a transaction based on whether the transaction was successful. (Points : 4) save; delete commit; rollback save; rollback commit; delete Question 9. 9. (TCO 7) Transaction processing enables a program to treat a database operation, or set of operations, as a single operation. This is known as a(n) _____ or a(n) _____ (Points : 4) atomic operation; unique operation. unique operation; transaction. atomic operation; transaction. None of the above Question 10. 10. (TCO 2) How many String objects are instantiated by the following code segment (not including the literals)? String s1, output; s1 = “hello”; output = “nThe string reversed is: ” ; for ( int i = s1.length() – 1; i >= 0; i– ) output += s1.charAt( i ) + ” ” ; (Points : 4) 1 4 5 7 Question 11. 11. (TCO 2) For String c = “Now is the time for all”; The Java statements String i = c.substring( 7 ); String j = c.substring( 4, 15 ); will result in (Points : 4) i = “he time for all” and j = “is the time”. i = “the time for all” and j = “s the time”. i = “the time for all” and j = “is the time “. i = “he time for all” and j = “s the time”. Question 12. 12. (TCO 2) Which of the following is not a method of class String? (Points : 4) toUpperCase trim toCharacterArray All of the above are methods of class String. Question 13. 13. (TCO 2) Given the following declarations: StringBuilder buffer = new StringBuilder( Testing Testing ); buffer.setLength( 7 ); buffer.ensureCapacity( 5 ); Which of the following is true? (Points : 4) buffer has capacity 5 buffer has capacity 31 buffer has content Testin buffer has length 15 Question 14. 14. (TCO 2) Which of the following creates the string of the numbers from 1 to 1,000 most efficiently? (Points : 4) String s; for ( int i = 1; i <= 1000; i++ ) s += i; StringBuilder sb = new StringBuilder( 10 ); for ( int i = 1; i <= 1000; i++ ) sb.append( i ); String s = new String( sb ); StringBuilder sb = new StringBuilder( 3000 ); for ( int i = 1; i <= 1000; i++ ) sb.append( i ); String s = new String( sb ); All are equivalently efficient. Question 15. 15. (TCO 2) Which of the following statements is true? (Points : 4) Class Matcher provides methods find, lookingAt, replaceFirst, and replaceAll. Method matches (from class String, Pattern, or Matcher) will return true only if the entire search object matches the regular expression. Methods find and lookingAt (from class Matcher) will return true if a portion of the search object matches the regular expression. All of above Question 16. 16. (TCO 6) How many comparisons will the linear search algorithm make if the search key is not in an array of 10 elements? (Points : 4) 0 10 9 5 Question 17. 17. (TCO 6) A(n) _____ allows a program to walk through the collection and remove elements from the collection. (Points : 4) Set Queue Iterator List Qu...
Looking for solution of this Assignment?
WHY CHOOSE US?
We deliver quality original papers |
Our experts write quality original papers using academic databases.We dont use AI in our work. We refund your money if AI is detected |
Free revisions |
We offer our clients multiple free revisions just to ensure you get what you want. |
Discounted prices |
All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount |
100% originality |
We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity.We have ZERO TOLERANCE TO USE OF AI |
On-time delivery |
We will deliver your paper on time even on short notice or short deadline, overnight essay or even an urgent essay |