CertsTopics Logo

Special Summer Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Pass Using 1z0-182 Exam Dumps

Page: 2 / 7
Total 94 questions
Get 1z0-182 Full Access Download 1z0-182 PDF

Oracle Database 23ai Administration Associate Questions and Answers

Question 5

Which two statements are true about the UNLIMITED TABLESPACE system privilege and space quota?

Options:

A.

It allows a user to have unlimited space in any tablespace in the database.

B.

It is overridden by a space quota specified for the user.

C.

It allows a user to have unlimited space only in their default permanent tablespace.

D.

It allows a role to have unlimited space in any tablespace in the database.

E.

By default, users have no quota on their default permanent tablespace.

Question 6

You have connected to a PDB to perform the administration operations of changing and verifying a system parameter that is PDB_MODIFIABLE. What is the appropriate mode to open the PDB to achieve this?

Options:

A.

READ WRITE

B.

RESTRICTED READ ONLY

C.

READ ONLY

D.

RESTRICTED WRITE ONLY

Question 7

Which two statements describe why Database Auditing is a security requirement?

Options:

A.

To monitor suspicious activity.

B.

To alert DBAs about system issues.

C.

To protect against data theft by a non-authorized user.

D.

To protect against data corruption.

E.

To monitor proper usage of the system and data by privileged users.

Question 8

Which resource plan is used to manage the resources for the predefined maintenance window?

Options:

A.

By default, all predefined maintenance windows use the DEFAULT_MAINTENANCE_PLANresource plan, and automated maintenance tasks run under subplan called ORA$AUTOTASK.

B.

The resources used by the predefined maintenance window can only be adjusted if you create a new resource plan in Resource Manager ...

C.

The predefined maintenance window starts automatically with 20% of the system resources ...

D.

The SYS_GROUP consumer resource group policies define the resources assigned ...

Page: 2 / 7
Total 94 questions
Get 1z0-182 Full Access Download 1z0-182 PDF