Online Access Free 1z1-061 Practice Test

In which three situations does a transaction complete?

• A.When a TRUNCATE statement is executed after the pending transaction
• B.When a ROLLBACK command is executed
• C.When a PL/SQL anonymous block is executed
• D.When a data definition language (DDL) statement is executed
• E.When a DELETE statement is executed

The CUSTOMERS table has these columns:
The CUSTOMER_ID column is the primary key for the table.
You need to determine how dispersed your customer base is.
Which expression finds the number of different countries represented in the CUSTOMERS table?

• A.COUNT(UPPER(country_address))
• B.COUNT(DIFF(UPPER(country_address)))
• C.COUNT(UNIQUE(UPPER(country_address)))
• D.COUNT(DISTINCT (UPPER(country_address)))
• E.COUNT DISTINCT UPPER(country_address)

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

You want to display the category with the maximum number of items.
You issue the following query:
SQL>SELECT COUNT(*), prod_category_id
FROM products
GROUP BY prod_category_id
HAVING COUNT(*) = (SELECT MAX(COUNT(*)) FROM products);
What is the outcome?

• A.It generates an error because the subquery does not have a GROUP BY clause.
• B.It generates an error because = is not valid and should be replaced by the IN operator.
• C.It executes successfully and gives the correct output.
• D.It executes successfully but does not give the correct output.

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

Using the customers table, you need to generate a report that shows an increase in the credit limit by 15% for all customers. Customers whose credit limit has not been entered should have the message "Not Available" displayed.
Which SQL statement would produce the required result?

• A.Option C
• B.Option A
• C.Option B
• D.Option D

Which three tasks can be performed using SQL functions built into Oracle Database?

• A.Finding the number of characters in an expression
• B.Displaying a date in a nondefault format
• C.Substituting a character string in a text expression with a specified string
• D.Combining more than two columns or expressions into a single column in the output