Free Access Oracle.1Z0-082.v2022-03-27.q110 Practice Test (Page 18)

Question 81

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

A.The data type returned can be different from the data type of the argument

B.They can be nested to any level

C.The argument can be a column name, variable, literal or an expression

D.They can accept only one argument

E.They can be used only in the WHERE clause of a SELECT statement

F.They return a single result row per table

Question 82

Which three are types of segments in an Oracle Database? (Choose three.)

A.undo

B.index

C.stored procedures

D.sequences

E.tables

F.clusters

Question 83

Which three are types of segments in an Oracle Database? (Choose three.)

A.undo

B.index

C.stored procedures

D.sequences

E.tables

F.clusters

Question 84

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_AMOUNTFROM customersWHERE cust_incoms_level IS NOT NULLAND due_amount IS NOT NULL;

B.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND cust_credit_level !=NULL;

C.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level <> NULLAND due_amount <> NULL;

D.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND cust_credit_limit IS NOT NULL;

E.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND due_amount !=NULL;

Question 85

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

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

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

C.Partition key columns cannot be dropped.

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

E.A DROP COLUMN command can be rolled back

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

Other Version: 2262Oracle.1Z0-082.v2023-08-24.q111; 1402Oracle.1Z0-082.v2023-03-31.q49; 3871Oracle.1Z0-082.v2022-07-18.q111; 5799Oracle.1Z0-082.v2022-02-11.q110; 97Oracle.Prepawaytest.1Z0-082.v2021-09-10.by.ives.98q.pdf

Latest Upload: 117Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 156TheSecOpsGroup.CNSP.v2025-09-08.q20; 208CFAInstitute.ESG-Investing.v2025-09-08.q173; 155PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 145Salesforce.Data-Architect.v2025-09-05.q216; 139Adobe.AD0-E605.v2025-09-05.q50; 182Nutanix.NCP-MCI-6.10.v2025-09-05.q55; 114Oracle.1z0-591.v2025-09-05.q104

Question 81

Question 82

Question 83

Question 84

Question 85

Download PDF File