Which two statements are true regarding savepoints? (Choose two.)

• A.Savepoints may be used to ROLLBACK.
• B.Savepoints can be used for only DML statements.
• C.Savepoints are effective only for COMMIT.
• D.Savepoints are effective for both COMMITand ROLLBACK.
• E.Savepoints can be used for both DML and DDL statements.

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the SALES table. (Choose two.)
Examine this statement:
SQL > CREATE TABLE sales1 (prod_id, cust_id, quantity_sold, price)
AS
SELECT product_id, customer_id, quantity_sold, price
FROM sales
WHERE 1 = 2;
Which two statements are true about the SALES1 table?

• A.It is created with no rows.
• B.It will not be created because the column-specified names in the SELECT and CREATE TABLE clauses do not match.
• C.It will have NOT NULL constraints on the selected columns which had those constraints in the SALES table.
• D.It has PRIMARY KEY and UNIQUE constraints on the selected columns which had those constraints in the SALES table.
• E.It will not be created because of the invalid WHERE clause.

Comment: *

Name: *

Email: *

Verification: *

Examine the data in the CUST_NAMEcolumn of the CUSTOMERStable.
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?
SELECT SUBSTR(cust_name, INSTR (cust_name, ' ')+1)

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

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the CUSTOMERS table:

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.
Which query can be used?

• A.SELECT * FROM customers WHERE city LIKE 'D_%';
• B.SELECT * FROM customers WHERE city = 'D_%';
• C.SELECT * FROM customers WHERE city LIKE 'D_';
• D.SELECT * FROM customers WHERE city = '%D_';

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the PRODUCT_ DETAILS table:

Which two statements are true?

• A.PRODUCT_ PRICE can be used in an arithmetic expression even if it has no value stored in it.
• B.PRODUCT_ PRICE contains the value zero by default if no value is assigned to it.
• C.PRODUCT_ NAME cannot contain duplicate values.
• D.EXPIRY_ DATE cannot be used in arithmetic expressions.
• E.EXPIRY_ DATE contains the SYSDATE by default if no date is assigned to it.
• F.PRODUCT_ ID can be assigned the PRIMARY KEY constraint.

Comment: *

Name: *

Email: *

Verification: *