You need to display the date 11-oct-2007 in words as 'Eleventh of October, Two Thousand Seven'.
Which SQL statement would give the required result?

• A.SELECT TO_CHAR (TO_DATE ('11-oct-2007'), 'fmDdthsp "of" Month, Year') FROM DUAL
• B.SELECT TO_DATE (TO_CHAR ('11-oct-2007'), 'fmDdspth "of" Month, Year')) FROM DUAL
• C.SELECT TO_CHAR (TO_DATE ('11-oct-2007'), 'fmDdspth of month, year')
  FROM DUAL
• D.SELECT TO_CHAR ('11-oct-2007', 'fmDdspth "of" Month, Year')
  FROM DUAL

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true? (Choose three.)

• A.The data dictionary is created and maintained by the database administrator.
• B.Data dictionary views consist of joins of dictionary base tables and user-defined tables.
• C.The usernames of all users including database administrators are stored in the data dictionary.
• D.The USER_CONS_COLUMNS view should be queried to find the names of columns to which constraints apply.
• E.Both USER_OBJECTS and CAT views provide the same information about all objects that are owned by the user.
• F.Views with the same name but different prefixes, such as DBA, ALL and USER, reference the same base tables from the data dictionary.

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following two queries:
SQL> SELECT cust_last_name, cust_city
FROM customers
WHERE cust_credit_limit IN (1000, 2000, 3000);
SQL> SELECT cust_last_name, cust_city
FROM customers
WHERE cust_credit_limit = 1000 or cust_credit_limit = 2000 or
cust_credit_limit = 3000
Which statement is true regarding the above two queries?

• A.Performance would improve in query 2 only if there are null values in the CUST_CREDIT_LIMIT column.
• B.There would be no change in performance.
• C.Performance would degrade in query 2.
• D.Performance would improve in query 2.

Comment: *

Name: *

Email: *

Verification: *

Examine this SELECT statement and view the Exhibit to see its output:

SELECT constraints_name, constraints_type, search_condition, r_constraints_name, delete_rule, status, FROM user_constraints WHERE table_name = 'ORDERS'; Which two statements are true about the output? (Choose two.)

• A.The R_CONSTRAINT_NAME column contains an alternative name for the constraint.
• B.The DELETE_RULE column indicates the desired state of related rows in the child table when the corresponding row is deleted from the parent table.
• C.The STATUS column indicates whether the table is currently in use.
• D.In the second column, 'c' indicates a check constraint.

Comment: *

Name: *

Email: *

Verification: *

Examine the data in the CUST_NAME column of the CUSTOMERS table.
CUST_NAME
-------------------
Renske Ladwig
Jason Mallin
Samuel McCain
Allan MCEwen
Irene Mikkilineni
Julia Nayer
You need to display customers' second names where the second name starts with "Mc" or "MC".
Which query gives the required output?

• A.SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1)FROM customersWHERE
  INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1))='Mc';
• B.SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1)FROM customersWHERE
  SUBSTR(cust_name, INSTR(cust_name,' ')+1) LIKE INITCAP('MC%');
• C.SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1)FROM customersWHERE
  INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1)) = INITCAP('MC%');
• D.SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1)FROM customersWHERE
  INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1)) LIKE 'Mc%';

Comment: *

Name: *

Email: *

Verification: *