CertsTopics Logo

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

Oracle 1z0-182 Based on Real Exam Environment

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

Oracle Database 23ai Administration Associate Questions and Answers

Question 21

One of your database instances was shut down normally and then started in NOMOUNT state. You then executed this command: ALTER DATABASE MOUNT; Which two of these actions are performed?

Options:

A.

Online data files are opened.

B.

Online redo logs are opened.

C.

The initialization parameter file is read.

D.

Oracle shared memory structures are allocated.

E.

The alert log has instance startup details written to it.

F.

Control files are read.

Question 22

Which three statements are true about Automatic Diagnostic Repository (ADR)?

Options:

A.

It is a file-based repository held outside any database.

B.

It is only used for Oracle database diagnostic information.

C.

It is held inside an Oracle database schema.

D.

It can be used for the problem diagnosis of a database when that database’s instance is down.

E.

The ADR base is specified in the DIAGNOSTIC_DEST database parameter.

Question 23

Which of the following is true about the status of a PDB that has been unplugged from a CDB?

Options:

A.

The STATUS column in CDB_PDBS of the unplugged PDB will be UNPLUGGED.

B.

The STATUS column in CDB_PDBS of the unplugged PDB will be UNAVAILABLE.

C.

The STATUS column in CDB_PDBS of the unplugged PDB will be REMOVED.

D.

The STATUS column in CDB_PDBS of the unplugged PDB will be DISABLED.

Question 24

Which two statements are true about Fine-Grained Auditing (FGA)?

Options:

A.

FGA policies by default can be created by a schema owner on an object in their schema.

B.

FGA policies can only be created by a user with SYSDBA privilege.

C.

FGA policies can be created by a user having the AUDIT_ADMIN privilege.

D.

FGA policies can be created by a user having granted the CREATE_FGA_POLICY role.

E.

FGA policies can be created by a user having EXECUTE privilege on the DBMS_FGA package.

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