Free Access Oracle.1Z1-082.v2026-07-18.q117 Practice Test (Page 17)

Question 76

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 77

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

A.The ADR base defaults to $ORACLE_HOME/rdbms/admin if neither DIAGNOSTIC_DEST nor ORACLE_BASE is set

B.The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set

C.It supports diagnostics for Automatic Storage Management (ASM)

D.It supports diagnostics for Oracle Clusterware

E.It is held inside an Oracle database schema

Question 78

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 79

Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)

A.Each SELECT statement in the compound query must have its own ORDER BY clause

B.Each SELECT statement in the compound query can have its own ORDER BY clause

C.The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause

D.Column positions must be used in the ORDER BY clause

E.Only column names from the first SELECT statement in the compound query are recognized

Question 80

Your database instance is started with a PFILE.
Examine these parameters:

You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?

A.The value is changed only in the PFILE and takes effect at the next instance startup

B.The value is changed for the current instance and in the PFILE

C.It fails because the SCOPE clause is missing

D.Change is applied to the current instance, but does not persist after instance restart

Other Version: 1487Oracle.1Z1-082.v2023-04-08.q100

Latest Upload: 169MedicalProfessional.CCM.v2026-08-20.q62; 211Cisco.300-610.v2026-08-19.q170; 258CompTIA.PT0-003.v2026-08-19.q179; 159Databricks.Databricks-Generative-AI-Engineer-Associate.v2026-08-18.q40; 158SAP.C_CR125_2601.v2026-08-17.q28; 212Salesforce.Field-Service-Consultant.v2026-08-17.q134; 173Oracle.1Z0-1170.v2026-08-16.q64; 182Oracle.1Z1-1170.v2026-08-16.q64; 204Juniper.JN0-336.v2026-08-13.q60; 436EMC.NCP-AII.v2026-08-13.q200

Question 76

Question 77

Question 78

Question 79

Question 80

Download PDF File