Free Oracle 1z0-061 Exam Dumps Questions & Answers

You work as a database administrator at ABC.com. You study the exhibit carefully.
Exhibit:

Evaluate the following query:
Exhibit:

The above query produces an error on execution. What is the reason for the error?

• A.  An alias cannot be used in an expression
• B.  The MIDPOINT +100 expression gives an error because CUST_CREDIT_LIMIT contains NULL values
• C.  The alias NAME should not be enclosed within double quotation marks
• D.  The alias MIDPOINT should be enclosed within double quotation marks for the CUST_CREDIT_LIMIT/2 expression

Examine the description of the CUSTOMERS table:

The CUSTOMER_ID column is the primary key for the table.
Which statement returns the city address and the number of customers in the cities Los Angeles or San Francisco?

• A.  SELECT city_address, COUNT (*)FROM. customersWHERE city address IN ( 'Los Angeles', 'San Fransisco')GROUP BY city_address;
• B.  SELECT city_address, COUNT(*)FROM. customersWHERE city_address IN ( 'Los Angeles', 'San Fransisco');
• C.  SELECT city_address, COUNT(customer_id)FROM. customersWHERE city_address IN ( 'Los Angeles', 'San Fransisco')GROUP BY. city_address, customer_id;
• D.  SELECT city_address, COUNT (customer_id)FROM . customersGROUP BY
  city_address IN ( 'Los Angeles', 'San Fransisco');

The CUSTOMERS table has these columns:
CUSTOMER_ID NUMBER(4) NOT NULL
CUSTOMER_NAME VARCHAR2(100) NOT NULL
CUSTOMER_ADDRESS VARCHAR2(150)
CUSTOMER_PHONE VARCHAR2(20)
You need to produce output that states "Dear Customer customer_name, ".
The customer_name data values come from the CUSTOMER_NAME column in the CUSTOMERS table.
Which statement produces this output?

• A.  SELECT 'Dear Customer ' || customer_name || ', ' || FROM customers;
• B.  SELECT 'Dear Customer ' || customer_name || ', ' FROM customers;
• C.  SELECT dear customer, customer_name, FROM customers;
• D.  SELECT 'Dear Customer ' || customer_name ', ' FROM customers;
• E.  SELECT "Dear Customer " || customer_name || ", " FROM customers;
• F.  SELECT "Dear Customer", customer_name || ', ' FROM customers;

Which two statements are true regarding views? (Choose two.)

• A.  The WITH CHECK OPTION constraint can be used in a view definition to restrict the columns displayed through the view.
• B.  A simple view in which column aliases have been used cannot be updated.
• C.  The OR REPLACE option is used to change the definition of an existing view without dropping and recreating it.
• D.  Rows added through a view are deleted from the table automatically when the view is dropped.
• E.  Rows cannot be deleted through a view if the view definition contains the DISTINCT keyword.

Which two statements are true regarding the USING and ON clauses in table joins?
(Choose two.)

• A.  The ON clause can be used to join tables on columns that have different names but compatible data types
• B.  Both USING and ON clause can be used for equijoins and nonequijoins
• C.  The WHERE clause can be used to apply additional conditions in SELECT statement containing the ON or the USING clause
• D.  A maximum of one pair of columns can be joined between two tables using the ON clause