You want to display 5 percent of the rows from the SALES table for products with the lowest AMOUNT_SOLD and also want to include the rows that have the same AMOUNT_SOLD even if this causes the output to exceed 5 percent of the rows.
Which query will provide the required result?

1. A. SELECT prod_id, cust_id, amount_soldFROM salesORDER BY amount_soldFETCH FIRST 5 PERCENT ROWS WITH TIES;
2. B. SELECT prod_id, cust_id, amount_soldFROM salesORDER BY amount_soldFETCH FIRST 5 PERCENT ROWS ONLY WITH TIES;
3. C. SELECT prod_id, cust_id, amount_soldFROM salesORDER BY amount_soldFETCH FIRST 5 PERCENT ROWS WITH TIES ONLY;
4. D. SELECT prod_id, cust_id, amount_soldFROM salesORDER BY amount_soldFETCH FIRST 5 PERCENT ROWS ONLY;

Correct Answer: A

Which statement is true about transactions?

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

Correct Answer: B
References:
https://docs.oracle.com/database/121/CNCPT/transact.htm#CNCPT038

You must create a table for a banking application. (Choose the best answer.) One of the columns in the table has these requirements:
1: A column to store the duration of a short team loan
2: The data should be stored in a format supporting DATE arithmetic with DATE datatypes without using conversion functions.
3: The maximum loan period is 30 days.
4: Interest must be calculated based on the number of days for which the loan remains unpaid. Which data type would you use?

1. A. Date
2. B. Number
3. C. Timestamp
4. D. Interval day to second
5. E. Interval year to month

Correct Answer: D

Which three arithmetic operations can be performed on a column by using a SQL function that is built into Oracle database? (Choose three.)

1. A. Finding the lowest value
2. B. Finding the quotient
3. C. Raising to a power
4. D. Subtraction
5. E. Addition

Correct Answer: ACE

Evaluate the following ALTER TABLE statement:
ALTER TABLE orders
SET UNUSED (order_date); Which statement is true?

1. A. After executing the ALTER TABLE command, you can add a new column called ORDER_DATE to the ORDERS table.
2. B. The ORDER_DATE column should be empty for the ALTER TABLE command to execute succsessfully.
3. C. ROLLBACK can be used to get back the ORDER_DATE column in the ORDERS table.
4. D. The DESCRIBE command would still display the ORDER_DATE column.

Correct Answer: A