Free Access Oracle.1Z0-082.v2023-03-31.q49 Practice Test (Page 8)

Question 31

Which two statements are true about single row functions? (Choose two.)

A.CONCAT : can be used to combine any number of values

B.MOD : returns the quotient of a division operation

C.TRUNC : can be used with NUMBER and DATE values

D.FLOOR : returns the smallest integer greater than or equal to a specified number

E.CEIL : can be used for positive and negative numbers

Question 32

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Which statement is true?

A.Dynamic service registration cannot be used for this database instance

B.The LREG process registers services dynamically with the LISTENER_1 listener

C.LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration

D.There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances

E.The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

Question 33

View the Exhibit and examine the structure of the PRODUCTS table.
Which two tasks require subqueries? (Choose two.)

A.Display the total number of products supplied by supplier 102 which have a product status of obsolete

B.Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable

C.Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE

D.Display suppliers whose PROD_LIST_PRICE is less than 1000

E.Display the minimum PROD_LIST_PRICE for each product status

Question 34

The orders table has a column ORDER_DATE of data type date.
The default display format for a date Is DD-MON-RR.
Which two where conditions demonstrate the correct usage of conversion functions?

A.WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')

B.WHERE order_date > TO_DATE<ADD_MONTHS(SYSDATE, c) , 'MON DD YYYY')

C.WHERE order_date IN (TO_DATE ('Oct 21 2018', 'Mon DD YYYY'), TC_CHAR('Nov 21 2018', 'Mon DD YYYY'))

D.WHERE order date > TO DATE('JUL 10 2018', *MON DD YYYY')

E.WHERE TO_CHAR(order_date, 'MON DD YYYY') = 'JAN 20 2019'

Question 35

Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)

A.Each SELECT statement in the compound query must have its own ORDER BY clause

B.Each SELECT statement in the compound query can have its own ORDER BY clause

C.Column positions must be used in the ORDER BY clause

D.Only column names from the first SELECT statement in the compound query are recognized

E.The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause

Other Version: 2581Oracle.1Z0-082.v2023-08-24.q111; 4134Oracle.1Z0-082.v2022-07-18.q111; 5340Oracle.1Z0-082.v2022-03-27.q110; 6225Oracle.1Z0-082.v2022-02-11.q110; 98Oracle.Prepawaytest.1Z0-082.v2021-09-10.by.ives.98q.pdf

Latest Upload: 119Microsoft.MS-700.v2025-12-27.q286; 110SAP.C-BCFIN-2502.v2025-12-27.q12; 115SAP.C-BCBTM-2502.v2025-12-26.q9; 122SAP.C_THR89_2505.v2025-12-26.q45; 115SAP.C-BCBTM-2509.v2025-12-26.q10; 166IAPP.AIGP.v2025-12-25.q64; 146CISI.UAE-Financial-Rules-and-Regulations.v2025-12-25.q35; 178SAP.C-S4TM-2023.v2025-12-25.q82; 128EMC.D-VXR-DS-00.v2025-12-24.q43; 184Splunk.SPLK-5001.v2025-12-24.q37

Question 31

Question 32

Question 33

Question 34

Question 35

Download PDF File