Online Access Free Oracle.1Z0-082.v2024-02-27.q119 Practice Test (Page 14)

1Z0-082 Exam Question 61

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

A.MOD : returns the quotient of a division operation

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

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

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

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

1Z0-082 Exam Question 62

Which two statements are true about Oracle synonyms?

A.A synonym can be created on an object in a package.

B.A synonym has an object number.

C.Any user can create a PUBLIC synonym.

D.All private synonym names must be unique in the database.

E.A synonym can have a synonym.

1Z0-082 Exam Question 63

Examine the description of the CUSTOMERS table:

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?

A.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level != NULL
AND cust_credit_level !=NULL;

B.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level != NULL
AND due_amount != NULL;

C.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level <> NULL
AND due_amount <> NULL;

D.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level IS NOT NULL
AND due_amount IS NOT NULL;

E.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level IS NOT NULL
AND cust_credit_limit IS NOT NULL;

1Z0-082 Exam Question 64

Examine the description of the PROMOTIONS table:

You want to display the unique promotion costs in each promotion category.
Which two queries can be used? (Choose two.)

A.SELECT DISTINCT promo_cost || ' in ` || DISTINCT promo_category FROM promotions ORDER BY 1;

B.SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

C.SELECT DISTINCT promo_category || ` has ` || promo_cost AS COSTS FROM promotions ORDER BY 1;

D.SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;

E.SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;

1Z0-082 Exam Question 65

Which two statements are true about Enterprise Manager Database Express? (Choose two.)

A.It is available only when the database is open

B.It can be used to perform database recovery

C.The same port number can be used for Database Express configurations for databases on different hosts

D.It can be used to switch a database into ARCHIVELOGMODE

E.The same port number can be used for multiple Database Express configurations for multiple databases on the same host

Other Version: 779Oracle.1Z0-082.v2026-07-20.q79; 1560Oracle.1Z0-082.v2025-05-12.q116; 3667Oracle.1Z0-082.v2022-08-18.q109; 165Oracle.Vceengine.1Z0-082.v2022-05-13.by.belinda.102q.pdf; 3942Oracle.1Z0-082.v2022-02-08.q102; 3625Oracle.1Z0-082.v2022-02-06.q99; 144Oracle.Examboosts.1Z0-082.v2021-09-12.by.truda.103q.pdf

Latest Upload: 157Oracle.1Z0-931-26.v2026-10-19.q61; 156Microsoft.AI-200.v2026-10-19.q43; 132Oracle.1z0-1195-26.v2026-10-19.q23; 213Microsoft.MS-102.v2026-10-19.q259; 201ECCouncil.312-50v13.v2026-10-19.q453; 201Oracle.1Z0-1110-26.v2026-10-17.q71; 265CloudSecurityAlliance.CCSK.v2026-10-17.q153; 293Salesforce.Platform-App-Builder.v2026-10-17.q161; 177Salesforce.AP-204.v2026-10-17.q40; 272Microsoft.AI-103.v2026-10-16.q46

1Z0-082 Exam Question 61

1Z0-082 Exam Question 62

1Z0-082 Exam Question 63

1Z0-082 Exam Question 64

1Z0-082 Exam Question 65

Download PDF File