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

• A.Table aliases can improve performance
• B.The BETWEEN condition always performs better than using the >= and <= conditions
• C.The join syntax used makes no difference to performance
• D.The BETWEEN condition always performs less well than using the >= and <= conditions
• E.The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

Comment: *

Name: *

Email: *

Verification: *

Your database instance is started with a PFILE.
Examine these parameters:

You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?

• A.The value is changed only in the PFILE and takes effect at the next instance startup
• B.The value is changed for the current instance and in the PFILE
• C.It fails because the SCOPE clause is missing
• D.Change is applied to the current instance, but does not persist after instance restart

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

• A.The ADR base defaults to $ORACLE_HOME/rdbms/admin if neither DIAGNOSTIC_DEST nor ORACLE_BASE is set
• B.The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set
• C.It supports diagnostics for Automatic Storage Management (ASM)
• D.It supports diagnostics for Oracle Clusterware
• E.It is held inside an Oracle database schema

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

Comment: *

Name: *

Email: *

Verification: *

In your data center, Oracle Managed Files (OMF) is used for all databases.
All tablespaces are smallfile tablespaces.
SALES_Q1 is a permanent user-defined tablespace in the SALES database.
Examine this command which is about to be issued by a DBA logged in to the SALES database:
ALTER TABLESPACE sales_q1 ADD DATAFILE;
Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)

• A.Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
• B.Add the AUTOEXTEND ON clause with NEXT set to 100M.
• C.Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.
• D.Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.
• E.Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.

Comment: *

Name: *

Email: *

Verification: *