Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.) A. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds B. SYSDATE can be queried only from the DUAL table C. CURRENT_DATE returns the current date and time as per the session… Read More »
Which two are true about a SQL statement using SET operators such as UNION? (Choose two.) A. The number, but not names, of columns must be identical for all SELECT statements in the query. B. The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by… Read More »
Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.) A. The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause B. Only… Read More »
Given the following class:Which three pieces of code, when inserted independently, set the value of amount to 100? A. Option C B. Option E C. Option F D. Option A E. Option D F. Option B Correct Answer: A,B,F
Given:Which two constructors will compile and set the class field strings? (Choose two.) A. Option E B. Option D C. Option C D. Option A E. Option B Correct Answer: A,C
Which two statements set the default locale used for formatting numbers, currency, and percentages? (Choose two.) A. Locale.setDefault(“en_CA”); B. Locale.setDefault(Locale.Category.FORMAT, Locale.CANADA_FRENCH); C. Locale.setDefault(Locale.Category.FORMAT, “zh-CN”); D. Locale.setDefault(Locale.SIMPLIFIED_CHINESE); E. Locale.setDefault(“es”, Locale.US); Correct Answer: A,B
In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:Which statement is true? A. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration B. Dynamic service registration cannot be used for this database instance C. The LREG process registers services dynamically… Read More »
Given:Which two constructors will compile and set the class field strings? (Choose two.) A. Option D B. Option E C. Option B D. Option C E. Option A Correct Answer: B,D
Given the code from the Greeting.Java file:Which set of commands prints Hello Duke in the console? A. Option C B. Option A C. Option B D. Option D Correct Answer: A
Which two are true about a SQL statement using SET operators such as UNION? (Choose two.) A. The data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query. B. The names and number of columns must be identical for all SELECT statements in… Read More »