Given:What is the result? A. 42 B. 17 C. The compilation fails due to an error in line 3. D. The compilation fails due to an error in line 5. E. The compilation fails due to an error in line 1. F. The compilation fails due to an error in line 2. G. The compilation fails due to… Read More »
Examine the description of the BOOKS table:The table has 100 rows.Examine this sequence of statements issued in a new session:INSERT INTO books VALUES (‘ADV112’, ‘Adventures of Tom Sawyer’, NULL, NULL); SAVEPOINT a; DELETE FROM books; ROLLBACK TO SAVEPOINT a; ROLLBACK; Which two statements are true? (Choose two.) A. The first ROLLBACK command restores the 101 rows that were… Read More »
The protected modifier on a Field declaration within a public class means that the field ______________. A. Can be read and written from this class and its subclasses defined in any package B. Can be read but not written from outside the class C. Can be read and written from this class and its subclasses only within the… Read More »
Given:What is the result? A. Orange Juice B. The compilation fails. C. Orange Juice Apple Pie Lemmon Ice Raspberry Tart D. The program prints nothing. Correct Answer: C
Which three are types of segments in an Oracle Database? (Choose three.) A. undo B. index C. stored procedures D. sequences E. tables F. clusters Correct Answer: B,E,F Explanation/Reference: http://www.adp-gmbh.ch/ora/concepts/segments.html
Which two are benefits of polymorphism? A. Faster code at runtime B. More efficient code at runtime C. More dynamic code at runtime D. More flexible and reusable code E. Code that is protected from extension by other classes Correct Answer: B,D Reference:https://www.cs.princeton.edu/courses/archive/fall98/cs441/mainus/node5.html
Given:What is the result? A. WorkingUnknown B. Unknown C. TuesdayUnknown D. The compilation fails. E. Tuesday F. Working Correct Answer: B
Given the code fragment:What is the result? A. [green, red, cyan, yellow] B. [green, blue, yellow, cyan] C. [green, red, yellow, cyan] D. An IndexOutOfBoundsException is thrown at runtime. Correct Answer: D
Which three statements are true about single-row functions? (Choose three.) A. They return a single result row per table B. The argument can be a column name, variable, literal or an expression C. They can accept only one argument D. They can be nested to any level E. The data type returned can be different from the data… Read More »
Given:What is the result? A. 23 B. 25 C. 5 D. 3 E. 11 Correct Answer: E