Given the code fragment from three files:Which code fragment, when inserted at line 2, enables the code to compile? A. Option C B. Option B C. Option A D. Option D E. Option E Correct Answer: E
Given:What is the result? A. The compilation fails. B. 1.99,2.99,0 C. 1.99,2.99,0.0 D. 1.99,2.99 Correct Answer: A
Which three statements are true about table data storage in an Oracle Database? (Choose three.) A. Data block headers contain their own Data Block Address (DBA) B. A table row piece can be chained across several database blocks C. Multiple row pieces from the same row may be stored in different database blocks D. Multiple row pieces from… Read More »
Given:What is the result? A. 200 200 B. Compilation fails. C. 400 400 D. 400 200 Correct Answer: D
Given:What is the result? A. watermelonorangelemongrapeapricotapple B. nothing C. appleapricotgrapelemonorangewatermelon D. appleorangegrapelemonapricotwatermelon Correct Answer: A
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 second ROLLBACK command undoes the insert B. The first… Read More »
Given the code fragment:Assume that the system date is June 20, 2014. What is the result? A. Option B B. Option D C. Option A D. Option C Correct Answer: B
Given:What is the result? A. 2134 B. 2143 C. 214 D. 234 Correct Answer: C
You execute this query:SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), `MON’), `dd “Monday for”fmMonth rrrr’)What is the result? A. It executes successfully but does not return any result B. It returns the date for the last Monday of the current month C. It generates an error D. It returns the date for the first Monday of the next month Correct Answer: D
Given the code fragment:Which modification enables the code to print 54321? A. At line7, insert x –; B. Replace line 6 with –x; and, at line 7, insert system, out. print (x); C. Replace line 12 With return (x > 0) ? false: true; D. Replace line 6 with System, out. print (–x) ; Correct Answer: D