Which three statements are true about sequences in a single instance Oracle database? (Choose three.)

• A.A sequence number that was allocated can be rolled back if a transaction fails
• B.A sequence can issue duplicate values
• C.Two or more tables cannot have keys generated from the same sequence
• D.Sequences can always have gaps
• E.A sequence's unallocated cached value are lost if the instance shuts down
• F.A sequence can only be dropped by a DBA

Comment: *

Name: *

Email: *

Verification: *

* MANAGER is an existing role with no privileges or roles.
* EMP is an existing role containing the CREATE TABLEprivilege.
* EMPLOYEES is an existing table in the HR schema.
Which two commands execute successfully? (Choose two.)

• A.GRANT CREATE ANY SESSION, CREATE ANY TABLE TO manager;
• B.GRANT CREATE SEQUENCE TO manager, emp;
• C.GRANT SELECT, INSERT ON hr.employees TO manager WITH GRANT OPTION;
• D.GRANT CREATE TABLE, emp TP manager;
• E.GRANT CREATE TABLE, SELECT ON hr.employees TO manager;

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the ORDERS table: (Choose the best answer.)

You want to find the total value of all the orders for each year and issue this command:
SQL> SELECT TO_CHAR(order_date,'rr'), SUM(order_total) FROM orders
GROUP BY TO_CHAR(order_date, 'yyyy');
Which statement is true regarding the result?

• A.It executes successfully and gives the correct output.
• B.It executes successfully but does not give the correct output.
• C.It returns an error because the TO_CHAR function is not valid.
• D.It return an error because the datatype conversion in the SELECT list does not match the data type conversion in the GROUP BY clause.

Comment: *

Name: *

Email: *

Verification: *

The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2.
The table has two rows whose COST_LAST_MANE values are Anderson and Ausson.
Which query produces output for CUST_LAST_SAME containing Oder for the first row and Aus for the second?

• A.SELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name),'An','O')) FROM customers;
• B.SELECT REPLACE (SUBSTR(cust_last_name,-3),'An','O') FROM customers;
• C.SELECT REPLACE (REPLACE(cust_last_name,'son',''),'An','O') FROM customers;
• D.SELECT REPLACE (TRIM(TRALING'son' FROM cust_last_name),'An','O') FROM customers;

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the ORDERS table. (Choose the best answer.)

You must select ORDER_ID and ORDER_DATE for all orders that were placed after the last order placed by CUSTOMER_ID 101.
Which query would give you the desired result?

• A.SELECT order_id, order_date FROM ordersWHERE order_date > ALL(SELECT MAX(order_date) FROM orders ) AND customer_id = 101;
• B.SELECT order_id, order_date FROM ordersWHERE order_date > IN(SELECT order_date FROM orders WHERE customer_id = 101);
• C.SELECT order_id, order_date FROM ordersWHERE order_date > ALL(SELECT order_date FROM orders WHERE customer_id = 101);
• D.SELECT order_id, order_date FROM ordersWHERE order_date > ANY(SELECT order_date FROM orders WHERE customer_id = 101);

Comment: *

Name: *

Email: *

Verification: *