Which two statements are true regarding a SAVEPOINT? (Choose two.)

• A.A SAVEPOINT does not issue a COMMIT
• B.Only one SAVEPOINT may be issued in a transaction
• C.Rolling back to a SAVEPOINT can undo a TRUNCATE statement
• D.Rolling back to a SAVEPOINT can undo a CREATE INDEX statement
• E.Rolling back to a SAVEPOINT can undo a DELETE statement

Comment: *

Name: *

Email: *

Verification: *

Examine this query:
SELECT TRUNC(ROUND(156.00, -2), -1) FROM DUAL;
What is the result?

• A.16
• B.200
• C.100
• D.160
• E.150

Comment: *

Name: *

Email: *

Verification: *

Which two are true about a SQL statement using SEToperators such as UNION? (Choose two.)

• A.The number, but not names, of columns must be identical for all SELECT statements in the query.
• B.The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.
• C.The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.
• D.The data type group of each column returned by the second query must match the data type group of the corresponding column returned by the first query.
• E.The names and number of columns must be identical for all SELECT statements in the query.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the structure of the CUSTOMERS table.

Which two tasks would require subqueries or joins to be executed in a single statement? (Choose two.)

• A.finding the number of customers, in each city, whose credit limit is more than the average credit limit of all the customers
• B.listing of customers who do not have a credit limit and were born before 1980
• C.finding the average credit limit of male customers residing in 'Tokyo' or 'Sydney'
• D.listing of those customers, whose credit limit is the same as the credit limit of customers residing in the city 'Tokyo'.
• E.finding the number of customers, in each city, whose marital status is 'married'.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the ORDERS table. The ORDER_ID column is the PRIMARY KEY in the ORDERS table.
Evaluate the following CREATE TABLE command:
CREATE TABLE new_orders(ord_id, ord_date DEFAULT SYSDATE, cus_id)
AS
SELECT order_id.order_date,customer_id
FROM orders;
Which statement is true regarding the above command?

• A.The NEW_ODRDERS table would get created and all the constraints defined on the specified columns in the ORDERS table would be passed to the new table.
• B.The NEW_ODRDERS table would get created and only the NOT NULL constraint defined on the specified columns would be passed to the new table.
• C.The NEW_ODRDERS table would not get created because the DEFAULT value cannot be specified in the column definition.
• D.The NEW_ODRDERS table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match.

Comment: *

Name: *

Email: *

Verification: *