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

Question 81

You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
1. Be stored in a format supporting date arithmetic without using
conversion functions
2. Store a loan period of up to 10 years
3. Be used for calculating interest for the number of days the loan
remains unpaid
Which data type should you use?

A.TIMESTAMP WITH LOCAL TIMEZONE

B.INTERVAL YEAR TO MONTH

C.TIMESTAMP

D.INTERVAL DAY TO SECOND

E.TIMESTAMP WITH TIMEZONE

Question 82

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

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

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

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

D.They can be nested to any level

E.They can accept only one argument

F.They return a single result row per table

Question 83

Which two tasks can you perform using DBCA for databases? (Choose two.)

A.Configure a nonstandard block size for a new database

B.Register a new database with an available Enterprise Manager Management server

C.Change the standard block size of an existing database

D.Configure incremental backups for a new database

E.Enable flashback database for an existing database

Question 84

Which two statements are true about the DUAL table? (Choose two.)

A.It can be accessed only by the SYS user

B.It consists of a single row and single column of VARCHAR2 data type

C.It can display multiple rows but only a single column

D.It can be used to display only constants or pseudo columns

E.It can be accessed by any user who has the SELECT privilege in any schema

F.It can display multiple rows and columns

Question 85

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

A.A DROP COLUMN command can be rolled back

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

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

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

E.Partition key columns cannot be dropped.

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

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

Latest Upload: 101OCEG.GRCP.v2025-09-11.q211; 101HP.HPE0-V27.v2025-09-11.q78; 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; 164TheSecOpsGroup.CNSP.v2025-09-08.q20; 222CFAInstitute.ESG-Investing.v2025-09-08.q173; 156PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 146Salesforce.Data-Architect.v2025-09-05.q216; 140Adobe.AD0-E605.v2025-09-05.q50

Question 81

Question 82

Question 83

Question 84

Question 85

Download PDF File