Free Access Oracle.1z1-071.v2025-05-13.q352 Practice Test (Page 29)

Question 136

Which three statements are true regarding group functions? (Choose three.)

A.They can be used on columns or expressions.

B.They can be passed as an argument to another group function.

C.They can be used with a SQL statement that has a GROUP BY clause.

D.They can be used only on one column in the SELECT clause.

E.They can be used together with the single-row functions in the SELECT clause.

Question 137

View the Exhibit and examine, the description for the SALES and CHANNELS tables.
(Choose the best answer.)
You issued this SQL statement:
INSERT INTO SALES VALUES (23, 2300, SYSDATE,
(SELECT CAHNNEL_ID
FROM CHANNELS
WHERE CHANNEL_DESC='DIRECT SALES'), 12, 1, 500);
Which statement is true regarding the result?

A.The statement will fail because the sub-query in the VALUES clause is not enclosed within single quotation marks.

B.The statement will fail because a subquery cannot be used in a VALUES clause.

C.The statement will execute and a new row will be inserted in the SALES table.

D.The statement will fail because the VALUES clause is not required with the subquery.

Question 138

Which three statements are true about indexes and their administration in an Oracle database?

A.An INVISIBLE index is not maintained when Data Manipulation Language (DML) is performed on its underlying table.

B.An index can be created as part of a CREATE TABLE statement.

C.A DROP INDEX statement always prevents updates to the table during the drop operation

D.A UNIQUE and non-unique index can be created on the same table column

E.A descending index is a type of function-based index

F.If a query filters on an indexed column then it will always be used during execution of the query

Question 139

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

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

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

C.COUNT(cust_id) returns the number of rows including rows with duplicate customer IDs and NULLs in the CUST_ID column.

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

E.The COUNT function can be used only for CHAR, VARCHAR2, and NUMBER data types.

Question 140

Examine the structure of the BOOKS_TRANSACTIONS table:

You want to display the member IDs, due date, and late fee as $2 for all transactions.
Which SQL statement must you execute?

A.SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", '$2' AS "LATE FEE" FROM BOOKS_TRANSACTIONS;

B.SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", $2 AS "LATE FEE" FROM BOOKS_TRANSACTIONS;

C.SELECT member_id AS MEMBER_ID, due_date AS DUE_DATE, $2 AS LATE_FEE FROM BOOKS_TRANSACTIONS;

D.SELECT member_id 'MEMBER ID', due_date 'DUE DATE', '$2 AS LATE FEE' FROM BOOKS_TRANSACTIONS;

Other Version: 4654Oracle.1z1-071.v2022-04-30.q200; 36Oracle.Prepawayete.1z1-071.v2022-01-25.by.lauren.209q.pdf

Latest Upload: 281PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 412Nokia.4A0-113.v2026-05-01.q69; 439EC-COUNCIL.312-49v11.v2026-04-30.q214; 396Microsoft.MB-820.v2026-04-30.q101; 273Salesforce.MC-202.v2026-04-30.q57; 322BICSI.INSTC_V8.v2026-04-29.q53; 456NMLS.MLO.v2026-04-28.q82; 299NCARB.Project-Management.v2026-04-28.q27; 543EMC.D-AV-DY-23.v2026-04-27.q184; 1388ServiceNow.CSA.v2026-04-27.q483

Question 136

Question 137

Question 138

Question 139

Question 140

Download PDF File