Oracle 1z1-071 - Oracle Database SQL

In the PROMOTIONS table, the PROMO_BEGIN_DATE column is of data type DATE and the default date format is DD-MON-RR.
Which two statements are true about expressions using PROMO_BEGIN_DATE contained a query? (Choose two.)

• A. PROMO_BEGIN_DATE ?5 will return a date.
• B. PROMO_BEGIN_DATE ?SYSDATE will return a number.
• C. PROMO_BEGIN_DATE ?SYSDATE will return an error.
• D. TO_DATE(PROMO_BEGIN_DATE * 5) will return a date.
• E. TO_NUMBER(PROMO_BEGIN_DATE) ?5 will return a number.

You have the privileges to create any type of synonym.
Which statement will create a synonym called EMP for the HCM.EMPLOYEE_RECORDS table that is accessible to all users?

• A. CREATE SYNONIM emp FOR hcm.employee_records;
• B. CREATE SYNONIM PUBLIC.emp FOR hcm.employee_records;
• C. CREATE GLOBAL SYNONIM emp FOR hcm.employee_records;
• D. CREATE PUBLIC SYNONIM emp FOR hcm.employee_records;
• E. CREATE SYNONIM SYS.emp FOR hcm.employee_records;

Which three tasks can be performed by DDL statements? (Choose three.)

• A. creating multiple savepoints to enable partial rollback of a transaction
• B. providing an alternative name for a table
• C. preventing data retrieval from a table outside of office hours
• D. modifying a table to prevent data that violate certain conditions from being entered in a column
• E. preventing any data modification to a table

Which statement is true about transactions?

• A. Each Data Definition Language (DDL) statement executed forms a single transaction.
• B. A set of Data Manipulation Language (DML) statements executed in a sequence ending with a SAVEPOINT forms a single transaction.
• C. A set of DDL statements executed in a sequence ending with a COMMIT forms a single transaction.
• D. A combination of DDL and DML statements executed in a sequence ending with a COMMIT forms a single transaction.

View the Exhibit and examine the structure of the SALES table.

The following query is written to retrieve all those product IDs from the SALES table that have more than 55000 sold and have been ordered more than 10 times.
SQL> SELECT prod_id
FROM sales
WHERE quantity_sold > 55000 and COUNT(*) > 10
GROUP BY prod_id
HAVING COUNT(*) > 10;
Which statement is true regarding this SQL statement?

• A. It executes successfully and generates the required result.
• B. It produces an error because COUNT(*) should be specified in the SELECT clause also.
• C. It produces an error because COUNT(*) should be only in the HAVING clause and not in the WHERE clause.
• D. It executes successfully but produces no result because COUNT(prod_id) should be used instead of COUNT(*).