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

Question 91

Which statement is true about smallfile tablespaces?

A.The number of data files is constrained only by the size of the storage array.

B.Segments can span multiple tablespaces.

C.Maximum file size can be set to unlimited only if the logical volume manager supports striping.

D.Extent location metadata is stored in the data dictionary by default.

E.Segments can span multiple data files.

Question 92

In one of your databases, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)

A.Revoke the CREATE SESSION privilege from other users

B.Revoke the CREATE SESSION privilege from user HR

C.Log in to the database instance

D.Grant the CREATE SESSION privilege with ADMIN OPTION to other users

E.Execute DDL statements in the HR schema

F.Execute DML statements in the HR schema

Question 93

The sales table has columns prod_id and quantity_sold of data type number In two queries execute successfully? x

A.SELECT prod_id FROM sales WHERE quantity_sold > 5S000 AND COUNT(-) > 10 GROUP BY prod_id HAVING COUNT(-) > 10;

B.SELECT prod_id FROM sales WHERE quantity_scld > 55000 AND COUNT(-) > 10 GROUP BY COUNT(-) > 10;

C.SELECT COUNTlprod_id> FROM sales GROUP BY prod_id WHERE quantity_Sold > 55000;

D.SELECT COUNT|prod_id> FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;

E.SELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id HAVING COUNT(-) > 10;

Question 94

You want to apply the principle of Least Privilege in all your live databases.
One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.
Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package?
(Choose three.)

A.analysis of all privileges used by all users including administrative users in the database

B.analysis of all privileges used by all users but excluding administrative users in the database

C.analysis of privileges that a user has on their own schema objects that they did not use

D.analysis of privileges that a user has on their own schema objects that they did use

E.analysis of privileges granted directly to a role that are then used by a user who has been granted that role

F.analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role

Question 95

Which two are true about shrinking a segment online? (Choose two.)

A.It always eliminates all migrated rows if any exist in the table

B.It must be in a tablespace that uses Automatic Segment Space Management (ASSM)

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 is not possible to shrink either indexes or Index Organized Tables (IOTs)

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

Latest Upload: 206Cisco.300-610.v2026-08-19.q170; 204CompTIA.PT0-003.v2026-08-19.q179; 153Databricks.Databricks-Generative-AI-Engineer-Associate.v2026-08-18.q40; 148SAP.C_CR125_2601.v2026-08-17.q28; 210Salesforce.Field-Service-Consultant.v2026-08-17.q134; 167Oracle.1Z0-1170.v2026-08-16.q64; 176Oracle.1Z1-1170.v2026-08-16.q64; 200Juniper.JN0-336.v2026-08-13.q60; 377EMC.NCP-AII.v2026-08-13.q200; 222CIRO.RSE.v2026-08-12.q41

Question 91

Question 92

Question 93

Question 94

Question 95

Download PDF File