The DBA issues this SQL command:
CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?

• A. no privileges
• B. all the privileges of a default user
• C. only the SELECT privilege
• D. only the CONNECT privilege

You work as a database administrator at ABC.com. You study the exhibit carefully.
Exhibit: Examine the structure of PRODUCTS table.

Using the PRODUCTS table, you issue the following query to generate the names, current list price and discounted list price for all those products whose list price fails below $10 after a discount of 25% is applied on it.
Exhibit:

The query generates an error.
What is the reason of generating error?

• A. The column alias should be put in uppercase and enclosed within double quotation marks in the WHERE clause
• B. The double quotation marks should be removed from the column alias
• C. The column alias should be replaced with the expression in the WHERE clause
• D. The parenthesis should be added to enclose the entire expression

The CUSTOMERS table has these columns: A promotional sale is being advertised to the customers in France. Which WHERE clause identifies customers that are located in France?

• A. WHERE lower(country_address) = "france"
• B. WHERE lower(country_address) LIKE %france%
• C. WHERE lower(country_address) = 'france'
• D. WHERE lower(country_address) IS 'france'
• E. WHERE lower(country_address) = '%france%'

View the Exhibit and examine the structure of the ORDERS and CUSTOMERS tables.

Evaluate the following SQL command:
SQL> SELECT o.order_id, c.cust_name, o.order_total, c.credit_limit
FROM orders o JOIN customers c
USING (customer_id)
WHERE o.order_total > c.credit_limit
FOR UPDATE
ORDER BY o.order_id;
Which two statements are true regarding the outcome of the above query? (Choose two.)

• A. The locks are released only when a COMMIT or ROLLBACK is issued.
• B. It locks all the rows that satisfy the condition in the statement.
• C. It locks only the columns that satisfy the condition in both the tables.
• D. The locks are released after a DML statement is executed on the locked rows.

View the Exhibit and examine the structure of the CUSTOMERS table.
In the CUSTOMERS table, the CUST_LAST_NAME column contains the values 'Anderson' and 'Ausson'.
You issue the following query:
SQL> SELECT LOWER(REPLACE(TRIM('son' FROM cust_last_name),'An','O'))
FROM CUSTOMERS
WHERE LOWER(cust_last_name) LIKE 'a%n';
What would be the outcome?

• A. 'Oder' and 'Aus'
• B. an error because the TRIM function specified is not valid
• C. an error because the LOWER function specified is not valid
• D. an error because the REPLACE function specified is not valid