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_AMOUNT
  FROM customers
  WHERE cust_income_level <> NULL
  AND due_amount <> NULL;
• B.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level != NULL
  AND cust_credit_level !=NULL;
• C.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level IS NOT NULL
  AND cust_credit_limit IS NOT NULL;
• D.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level IS NOT NULL
  AND due_amount IS NOT NULL;
• E.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level != NULL
  AND due_amount != NULL;

Comment: *

Name: *

Email: *

Verification: *

Which three activities are recorded in the database alert log? (Choose three.)

• A.Data Definition Language (DDL) statements
• B.non-default database parameters
• C.block corruption errors
• D.deadlock errors
• E.session logins and logouts

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about Enterprise Manager Database Express? (Choose two.)

• A.It is available only when the database is open
• B.It can be used to perform database recovery
• C.The same port number can be used for Database Express configurations for databases on different hosts
• D.It can be used to switch a database into ARCHIVELOGMODE
• E.The same port number can be used for multiple Database Express configurations for multiple databases on the same host

Comment: *

Name: *

Email: *

Verification: *

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 statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)

• A.A TIMESTAMP data type column contains information about year, month, and day
• B.The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
• C.The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
• D.The CURRENT_TIMESTAMP function returns data without time zone information
• E.A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row

Comment: *

Name: *

Email: *

Verification: *