Plus, how to prevent and detect fraud using blockchain tables on Oracle Autonomous Database
January 2022
It’s a new year, and that means a new edition of Oracle’s monthly developer newsletter. We have technical articles on Java debugging, using containers, leveraging Oracle Visual Builder, and performing textual sentiment analysis. You’ll also find links to product and service announcements, events, special offers—and a new feature in this newsletter: quizzes!
Coherence Community Edition 21.12 includes distributed Coherence-backed implementations of the concurrency primitives from the java.util.concurrent package.
The free Oracle Cloud Infrastructure certification offer has been extended! Get started with free training, plus validate your knowledge with free certification exams, now available through February 28.
Assess the state of your Java environment and get expert insights with a two-minute quiz.
PL/SQL and Java quizzes
Quiz #1, for PL/SQL
Which of these statements about restrictions on the use of cursor variables are correct? Choose all the answers that apply.
Choice 1: A cursor variable based on a weak REF CURSOR type cannot be declared at the package level (outside of any procedure or function in the package).
Choice 2: You cannot pass a cursor variable as a bind variable in an EXECUTE IMMEDIATE USING clause.
Choice 3: A cursor variable based on a strong REF CURSOR type cannot be declared at the package level (outside of any procedure or function in the package).
Choice 4: You cannot define a parameter whose type is a REF CURSOR in a procedure or function.
Choice 5: You cannot use comparison operators to test cursor variables for equality, inequality, or nullity.
Choice 6: REF CURSOR types (such as SYS_REFCURSOR) cannot be used as the data type of a collection.
Choice 7: Database columns cannot store the values of cursor variables.
Choice 8: No choice is correct.
Submit your choice(s) and see the correct answer here. (If you have never used Oracle DevGym, you will need to create a free account and log in.)
Quiz #2, for Java
Given the class
public class StringComparison { public static void main(String[] args) { var str1 = "Java 11"; var str2 = "Java 11"; var res = "The" + " " + "same:" + str1 == str2; System.out.print(res); } }
What is the output? Choose one.
Choice A. The same:true Choice B. The same:false Choice C. true Choice D. false
Submit your choice and see the correct answer here.
Get a new Developer newsletter delivered to your inbox every month
