Free Oracle 1z0-071 Exam Dumps Questions & Answers

Examine the description of the PRODUCT_INFORMATION table:

Which query retrieves the number of products with a null list price?

• A.  SELECT COUNT (list_price) FROM product_information WHERE list_price IS NULL;
• B.  SELECT COUNT(NVL(list_price, 0)) FROM product_information WHERE list_price IS NULL;
• C.  SELECT COUNT (DISTINCT list_price) FROM product_information WHERE list_price IS NULL;
• D.  SELECT COUNT (list_price) FROM product_information WHERE list_price = NULL;

Which three are true about privileges and roles? (Choose three.)

• A.  PUBLIC acts as a default role granted to every user in a database.
• B.  A role can contain a combination of several privileges and roles.
• C.  PUBLIC can be revoked from a user.
• D.  A user has all object privileges for every object in their schema by default.
• E.  A role is owned by the user who created it.
• F.  All roles are owned by the SYS schema.
• G.  System privileges always set privileges for an entire database.

Evaluate the following statement.

Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?

• A.  Each row is evaluated by the first WHEN clause and if the condition is false then the row would be evaluated by the subsequent when clauses.
• B.  Each row is evaluated by the first WHEN clause and if the condition is true, then the row would be evaluated by the subsequent when clauses.
• C.  All rows are evaluated by all the three WHEN clauses.
• D.  The INSERT statement will return an error because the ELSE clause is missing.

Which three actions can you perform on an existing table containing data? (Choose three.)

• A.  Define a default value that is automatically inserted into a column containing nulls
• B.  Increase the width of a numeric column
• C.  Add a new column as the table's first column
• D.  Change a DATE column containing data to a NUMBER data type
• E.  Change the default value of a column
• F.  Add a new NOT NULL column with a DEFAULT value

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

You must display product names from the PRODUCTS table that belong to the 'Software/other' category with minimum prices as either $2000 or $4000 and with no unit of measure.
You issue this query:

Which statement is true?

• A.  It executes successfully but returns no result.
• B.  It executes successfully and returns the required result.
• C.  It generates an error because the condition specified for the PROD_CATEGORY column is not valid.
• D.  It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid.