Oracle 1Z0-071 Quiz 29 Topic 15 Questions 141-145

Question: 1

View the Exhibit and examine the details of the PRODUCT_INFORMATION table.

Exhibit

q1_1Z0-071

You must display PRODUCT_NAME from the table where the CATEGORY_ID column has values 12 or 13, and the SUPPLIER_ID column has the value 102088.

You executed this SQL statement:

q1_1Z0-071

Which statement is true regarding the execution?

AIt would not execute because the entire WHERE clause is not enclosed within parentheses.

BIt would execute but would return no rows.

CIt would not execute because the same column has been used twice with the AND logical operator.

DIt would execute and return the desired result.

Show Answer

Question: 2

You need to produce a report where each customer's credit limit has been incremented by $1000. In the output, the customer's last name should have the heading Name and the incremented credit limit should be labeled New Credit Limit. The column headings should have only the first letter of each word in uppercase.

Which statement would accomplish this requirement?

ASELECT cust_last_name AS ''Name'', cust_credit_limit + 1000AS ''New Credit Limit''FROM customers;

BSELECT cust_last_name AS Name, cust_credit_limit + 1000AS New Credit LimitFROM customers;

CSELECT cust_last_name AS Name, cust_credit_limit + 1000''New Credit Limit''FROM customers;

DSELECT INITCAP (cust_last_name) ''Name'', cust_credit_limit + 1000INITCAP (''NEW CREDIT LIMIT'')FROM customers;

Show Answer

Question: 3

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

q3_1Z0-071

Which UPDATE statement is valid?

AUPDATE ordersSET order_date = '12-mar-2007',order_total IS NULLWHERE order_id = 2455;

BUPDATE ordersSET order_date = '12-mar-2007',AND order_total = TO_NUMBER(NULL)WHERE order_id = 2455;

CUPDATE ordersSET order_date = '12-mar-2007',order_total = NULLWHERE order_id = 2455;

DUPDATE ordersSET order_date = TO_DATE('12-mar-2007','dd-mon-yyyy'),SET order_total = TO_NUMBER (NULL)WHERE order_id = 2455;

Show Answer

Question: 4

SCOTT is a user in the database.

Evaluate the commands issued by the DBA:

q4_1Z0-071

Which statement is true regarding the execution of the above commands?

AStatement 1 would not execute because the WITH GRANT option is missing.

BStatement 2 would not execute because system privileges and object privileges cannot be granted together in a single GRANT command.

CStatement 3 would not execute because role and system privileges cannot be granted together in a single GRANT statement.

DStatement 1 would not execute because the IDENTIFIED BY clause is missing.

Show Answer

Question: 5

View the Exhibit and examine the data in the PRODUCT_INFORMATION table.

q5_1Z0-071

Which two tasks would require subqueries? (Choose two.)

Adisplaying all the products whose minimum list prices are more than average list price of products having the status orderable

Bdisplaying the total number of products supplied by supplier 102071 and having product status OBSOLETE

Cdisplaying the number of products whose list prices are more than the average list price

Ddisplaying all supplier IDs whose average list price is more than 500

Edisplaying the minimum list price for each product status

Show Answer

Oracle 1Z0-071 Quiz:29 Topic:15 Questions:141-145