Which three are true about the Oracle Optimizer? (Choose three.) A. It determines the optimal table join order and method. B. It generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found in the Data Dictionary. C. It can re-optimize execution plans after previous executions detect suboptimal plans. D. It… Read More »
Given the code fragment:What is the result? A. A B C Work done B. A Work done C. A B C D Work done D. Compilation fails Correct Answer: B
Given:What is the result? A. An exception is thrown at runtime. B. 42=(x+y)=42 C. 42=(x+y)=6 D. 6=(x+y)=42 E. 6=(x+y)=6 Correct Answer: D
In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance whose listener listens on port 1531 by using this statement:CONNECT HR/[email protected]No name server is used.Which statement is true about ORCL? A. It must be the value of the SERVICE_NAMES parameter on the client side B. It must be… Read More »
Given the code fragment: A. Compilation fails at line n2 B. Contract Contract Super C. Compilation fails at line n1 D. Super Sub Sub Correct Answer: A
Given:What is the result? A. JoeMarry B. Joenull C. nullnull D. nullMary Correct Answer: D
Which two statements are true about the rules of precedence for operators? (Choose two.) A. The concatenation operator | | is always evaluated before addition and subtraction in an expression B. NULLS influence the precedence of operators in an expression C. The + binary operator has the highest precedence in an expression in a SQL statement D. Arithmetic… Read More »
Given the following main method:What is the result? A. 5 4 3 2 1 B. 5 4 3 2 1 0 C. 4 2 1 D. 5 E. Nothing is printed Correct Answer: D
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 four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.) A. It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted B. A table can have only one primary… Read More »