Free Access Oracle.1Z0-082.v2023-08-24.q111 Practice Test (Page 2)

Question 1

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 promo_cost, promo_category FROM promotions ORDER BY 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 DISTINCT promo_cost || ' in ` || DISTINCT promo_category FROM promotions ORDER BY 1;

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

Question 2

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 IS NOT NULL AND due_amount IS NOT 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 cust_credit_level !=NULL;

D.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level <> NULL AND due_amount <> 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;

Question 3

Which three statements are true about dropping and unused columns in an Oracle database?
(Choose three.)

A.A column that is set to UNUSED still counts towards the limit of 1000 columns per table

B.A DROP COLUMN command can be rolled back

C.An UNUSED column's space is reclaimed automatically when the row containing that column is next queried.

D.A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.

E.An UNUSED column's space is reclaimed automatically when the block containing that column is next queried.

F.Partition key columns cannot be dropped.

Question 4

Which two are true about shrinking a segment online? (Choose two.)

A.It is not possible to shrink either indexes or Index Organized Tables (IOTs)

B.It always eliminates all migrated rows if any exist in the table

C.To shrink a table it must have a PRIMARY KEY constraint

D.To shrink a table it must have a UNIQUE KEY constraint

E.To shrink a table it must have row movement enabled

F.It must be in a tablespace that uses Automatic Segment Space Management (ASSM)

Question 5

Which two actions can you perform using DBCA for an existing database?

A.Change the character set.

B.Create nonstandard block size tablespaces.

C.Create a template that can be used to clone the database.

D.Change the server mode from dedicated to shared, and vice versa.

E.Create an additional listener.

Other Version: 1762Oracle.1Z0-082.v2023-03-31.q49; 4384Oracle.1Z0-082.v2022-07-18.q111; 5755Oracle.1Z0-082.v2022-03-27.q110; 6576Oracle.1Z0-082.v2022-02-11.q110; 98Oracle.Prepawaytest.1Z0-082.v2021-09-10.by.ives.98q.pdf

Latest Upload: 201PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 296Nokia.4A0-113.v2026-05-01.q69; 253EC-COUNCIL.312-49v11.v2026-04-30.q214; 228Microsoft.MB-820.v2026-04-30.q101; 209Salesforce.MC-202.v2026-04-30.q57; 205BICSI.INSTC_V8.v2026-04-29.q53; 333NMLS.MLO.v2026-04-28.q82; 242NCARB.Project-Management.v2026-04-28.q27; 458EMC.D-AV-DY-23.v2026-04-27.q184; 1112ServiceNow.CSA.v2026-04-27.q483

Question 1

Question 2

Question 3

Question 4

Question 5

Download PDF File