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

• A.It can be used only in SQL*Plus
• B.It displays values for variables used only in the WHERE clause of a query
• C.It displays values for variables prefixed with &&
• D.It displays values for variables created by the DEFINE command
• E.It can be used in SQL Developer and SQL*Plus

Comment: *

Name: *

Email: *

Verification: *

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

• A.FROM "&table"
  WHERE &condition;
  SELECT '&&col1', '&&col2'
• B.FROM &table
  WHERE &&condition = &&cond;
  SELECT &col1, &col2
• C.FROM &table
  WHERE &&condition;
• D.FROM &&table
  WHERE &condition;
  SELECT &col1, &col2
• E.FROM &table
  WHERE '&&condition' = '&cond';
  SELECT &&col1, &&col2

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the description of the tables.
You execute this SQL statement:

Which three statements are true?

• A.The statement will execute successfully and a new row will be inserted into the sales table.
• B.The sales table has five foreign keys.
• C.A customer can exist in many countries.
• D.A product can have a different unit price at different times.
• E.The statement will fall if a row already exists in the sales table for product 23.
• F.The statement will fail because a subquery may not be contained in a values clause.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the PMON background process? (Choose two.)

• A.It registers database services with all local and remote listeners known to the database instance
• B.It frees resources held by abnormally terminated processes
• C.It records checkpoint information in the control file
• D.It frees unused temporary segments
• E.It kills sessions that exceed idle time

Comment: *

Name: *

Email: *

Verification: *

The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)

• A.SELECT NVL(cust_credit_limit * .15, `Not Available') FROM customers;
• B.SELECT TO_CHAR(NVL(cust_credit_limit * .15, `Not Available')) FROM customers;
• C.SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;
• D.SELECT NVL2(cust_credit_limit * .15, `Not Available') FROM customers;
• E.SELECT NVL(TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;

Comment: *

Name: *

Email: *

Verification: *