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

Question 76

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

A.A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.

B.A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.

C.A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

D.Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.

E.GLOBAL TEMPORARY TABLE space allocation occurs at session start.

F.GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.

Question 77

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Segment creation is not deferred.
You execute this command:

Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)

A.The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema

B.The sales user must have their quota on the users tablespace removed

C.The sales user must have been granted the CREATE TABLE privilege

D.The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema

E.The sales user must have a quota on the TEMP tablespace

F.The sales user must have been granted the CREATE SESSION privilege

Question 78

In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:
1. A size of 100 MB
2. AUTOEXTEND is off
3. UNDO_RETENTION is set to 15 minutes
4. It has RETENTION GUARANTEE
UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens.
What will happen when the next update is attempted by any transaction?

A.It succeeds and the generated undo is stored in SYSTEM.

B.It fails and returns the error message "ORA-30036: unable to extend segment by 8 in undo tablespace
'UNDOTBS1' ".

C.It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.

D.It succeeds and the generated undo is stored in SYSAUX.

E.It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.

Question 79

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE.
You want to display the date of the first Monday after the completion of six months since hiring.
The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day on the wee.
Which query can be used?

A.SELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;

B.SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 'MONDAY') FROM employees;

C.SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY('MONDAY') FROM employees;

D.SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;

Question 80

Which three statements are true concerning logical and physical database structures? (Choose three.)

A.A smallfile tablespace might be bigger than a bigfile tablespace

B.The extents of a segment must always reside in the same datafile

C.Segments can span multiple tablespaces

D.A segment might have only one extent

E.A segment's blocks can be of different sizes

F.A segment can span multiple data files in some tablespaces

G.All tablespaces may have one or more data files

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 76

Question 77

Question 78

Question 79

Question 80

Download PDF File