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

Question 41

You execute this command:

Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)

A.AUTOEXTEND is possible for the datafile

B.It will always have a 32K blocksize

C.It will be a dictionary-managed tablespace by default

D.It must be bigger than the largest SMALLFILE tablespace

E.Additional data files may not be added

Question 42

Which two statements are true about views used for viewing tablespace and datafile information? (Choose two.)

A.Tablespace free space can be viewed in DBA_TABLESPACES

B.VSTABLESPACE displays information about tablespaces contained in the data dictionary

C.A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened

D.Tablespace free space can be viewed in VSTABLESPACE

E.VSTABLESPACE displays information that is contained in the controlfile about tablespaces

Question 43

In your data center, Oracle Managed Files (OMF) is used for all databases.
All tablespaces are smallfile tablespaces.
SALES_Q1 is a permanent user-defined tablespace in the SALES database.
Examine this command which is about to be issued by a DBA logged in to the SALES database:
ALTER TABLESPACE sales_q1 ADD DATAFILE;
Which are two actions, either one of which you could take to ensure that the command executes successfully?
(Choose two.)

A.Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.

B.Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.

C.Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.

D.Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.

E.Add the AUTOEXTEND ON clause with NEXT set to 100M.

Question 44

Which two statements are true about segment types in an Oracle Database?

A.Undo segments are only stored in an undo tablespace.

B.Cluster segments may contain data from multiple tables.

C.Index segments always have two or more extents.

D.Temporary segments are only stored in a temporary tablespace.

E.Table segments always have two or more extents.

Question 45

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

A.They support UPDATEs but not INSERTs and DELETEs

B.They cannot be partitioned

C.The ORACLE_LOADER access driver can be used to unload data from a database into an external table

D.The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table

E.The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table

F.External table files can be used for other external tables in a different database

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

Latest Upload: 202PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 299Nokia.4A0-113.v2026-05-01.q69; 258EC-COUNCIL.312-49v11.v2026-04-30.q214; 228Microsoft.MB-820.v2026-04-30.q101; 211Salesforce.MC-202.v2026-04-30.q57; 206BICSI.INSTC_V8.v2026-04-29.q53; 336NMLS.MLO.v2026-04-28.q82; 243NCARB.Project-Management.v2026-04-28.q27; 465EMC.D-AV-DY-23.v2026-04-27.q184; 1120ServiceNow.CSA.v2026-04-27.q483

Question 41

Question 42

Question 43

Question 44

Question 45

Download PDF File