Q30. 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?

Q31. A database is configured to use automatic undo management with temporary undo enabled.
An UPDATE is executed on a temporary table.
Where is the UNDO stored?

Q32. 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.)

Q33. Examine the description of the CUSTOMERS table:

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?

Q34. Examine this command:

Which two statements are true? (Choose two.)

Q35. View the Exhibit and examine the structure of the PRODUCTS table.
Which two tasks require subqueries? (Choose two.)

Q36. Examine the description of the CUSTOMERS table:

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?

Q37. Examine this description of the TRANSACTIONS table:

Which two SQL statements execute successfully? (Choose two.)
SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS DATE, amount + 100

Q38. Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:

Which two statements are true? (Choose two.)

Q39. Which two statements are true about the SET VERIFY ON command? (Choose two.)

Q40. What is true about non-equijoin statement performance? (Choose two.)

Q41. In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.
Examine this command:
SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);
Which segment or segments, if any, are created as a result of executing the command?

Q42. You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.
The variables used in your query are never undefined in your session.
Which query can be used?
SELECT &&col1, &&col2

Q43. Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)

Q44. Which two are true about shrinking a segment online? (Choose two.)

Q45. Which three statements are true about inner and outer joins? (Choose three.)