Oracle 1Z0-071 Quiz 14 Topic 12 Questions 66-70

Question: 1

Which two statements are true regarding the COUNT function? (Choose two.)

AA SELECT statement using the COUNT function with a DISTINCT keyword cannot have a WHERE clause.

BCOUNT(DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULLs in the INV_AMT column.

CCOUNT(inv_amt) returns the number of rows in a table including rows with NULL in the INV_AMT column.

DCOUNT(*) returns the number of rows including duplicate rows and rows containing NULL value in any column.

EIt can only be used for NUMBER data types.

Show Answer

Question: 2

Examine the description of the PRODUCT_INFORMATION table:

q2_1Z0-071

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

ASELECT COUNT (DISTINCT list_price) FROM product_information WHERE list_price IS NULL;

BSELECT COUNT (list_price) FROM product_information WHERE list_price IS NULL;

CSELECT COUNT (list_price) FROM product_information WHERE list_price = NULL;

DSELECT COUNT(NVL(list_price, 0)) FROM product_information WHERE list_price IS NULL;

Show Answer

Question: 3

Which two commands execute successfully?

*MANAGER is an existing role with no privileges or roles.

*EMP is an existing role containing the CREATE TABLE privilege.

*EMPLOYEES is an existing table in the HR schema.

AGRANT CREATE SEQUENCE TO manager, emp;

BGRANT CREATE ANY SESSION, CREATE ANY TABLE TO manager;

CGRANT SELECT, INSERT ON hr.employees TO manager WITH GRANT OPTION;

DGRANT CREATE TABLE, emp TP manager;

EGRANT CREATE TABLE, SELECT ON hr.employees TO manager;

Show Answer

Question: 4

Which statement is true regarding the default behavior of the ORDER BY clause?

AIn a character sort, the values are case-sensitive.

BNULLs are not included in the sort operation.

COnly columns that are specified in the SELECT list can be used in the ORDER BY clause.

DNumeric values are displayed in descending order if they have decimal positions.

EColumn aliases can be used in the ORDER BY clause.

Show Answer

Question: 5

You execute this query:

q5_1Z0-071

What is the result?

AIt returns the date for the first Monday of the next month.

BIt returns the date for the last Monday of the current month.

CIt executes successfully but does not return any result.

DIt generates an error.

Show Answer

Oracle 1Z0-071 Quiz:14 Topic:12 Questions:66-70