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?

• A.in the undo tablespace
• B.in the SYSAUX tablespace
• C.in the SGA
• D.in the PGA
• E.in the temporary tablespace

Comment: *

Name: *

Email: *

Verification: *

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

• A.Online table segment shrink
• B.Online index segment shrink
• C.Automatic data file extension (AUTOEXTEND)
• D.Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)
• E.Oracle Managed Files (OMF)

Comment: *

Name: *

Email: *

Verification: *

Examine these commands:

Which two statements are true about the sqlldrexecution? (Choose two.)

• A.It overwrites data in EMP with data in EMP.DAT
• B.It generates a sql script that it uses to load data from EMP.DAT to EMP
• C.It uses the database buffer cache to load data
• D.It appends data from EMP.DAT to EMP
• E.It generates a log that contains control file entries, which can be used with normal SQL*Loader operations

Comment: *

Name: *

Email: *

Verification: *

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.Column positions must be used in the ORDER BY clause
• B.Each SELECT statement in the compound query can have its own ORDER BY clause
• C.Only column names from the first SELECT statement in the compound query are recognized
• D.Each SELECT statement in the compound query must have its own ORDER BY clause
• E.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

Comment: *

Name: *

Email: *

Verification: *

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?

• A.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND cust_credit_level !=NULL;
• B.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND due_amount IS NOT NULL;
• C.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level <> NULLAND due_amount <> NULL;
• D.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND due_amount != NULL;
• E.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND cust_credit_limit IS NOT NULL;

Comment: *

Name: *

Email: *

Verification: *