Which three statements are true reading subqueries? (Choose three.)

Which two are true about transactions in the Oracle Database?

You have the privileges to create any type of synonym.
Which statement will create a synonym called EMPfor the HCM.EMPLOYEE_RECORDS table that is accessible to all users?
CREATE PUBLIC SYNONIM emp FOR hcm.employee_records;

Examine the structure of the CUSTOMERS table: (Choose two.)

CUSTNO is the PRIMARY KEY.
You must determine if any customers' details have been entered more than once using a different CUSTNO, by listing all duplicate names.
Which two methods can you use to get the required result?

Examine these statements and results:
SQL> SELECT COUNT(*) FROM emp
COUNT(*)
---------------------
14
sQL> CREATE GLOBAL TEMPORARY TABLE t emp As SELECT * FROM emp;
Table created
SQL> INSERT INTo temp SELECT * FROM emp;
14 rows created
SQL> COMMIT:
Commit complete*
SQL> INSERT INTo temp SELECT * EROM emp;
14. rows created
SQL> SELECT COUNT(*) FROM t emp
How many rows are retrieved by the last query?